Navigation:  Installation Guide > Webserver Installation > IIS > Database Connection configuration >

Connection String

Previous pageReturn to chapter overviewNext page

In order to let SSP communicate with the database the web.config files in the root needs to be updated. The updates mentioned below should be done in only in that web.config file (NOT in the folders common, workflow, KM, webstore and forms !)

Update the connectionstring setting in the “web.config” file so that it connects with your database. Search for the string: <add key="SMTXSSP7" value="SMTXSSP7"/>

If the SQL Server catalog name is different from "SMTXSSP7" as mentioned above, an extra update needs to be done in the 5 “web.config” files. Search the following:

<sqlServerCatalogNameOverwrites>
   <add key="SMTXSSP7" value="NewSSP7DBName" />   </sqlServerCatalogNameOverwrites>

And update the contents of the value  attribute (DO NOT update the key attribute, it should stay 'SMTXSSP7') to the chosen catalog (database name).

If the Oracle schema name is different from "SMTXSSP7", an extra update needs to be done in the 3 "web.config" files. Search the following:

<oracleSchemaNameOverwrites>

 <add key="SMTXSSP7" value="NewSSP7SchemaName" />

</oracleSchemaNameOverwrites>

And update the contents of the value  attribute (DO NOT update the key attribute, it should stay 'SMTXSSP7') to the chosen schema.

Further down this file, also update the database connection string:

clip0420

Examples of connection strings:

Oracle: <add key="Main.ConnectionString" value="data source=TNSNAME;user id=USERNAME;password=PASSWORD;persist security info=false;" />
SQL Server: <add key="Main.ConnectionString" value="data source=SERVER\INSTANCE;initial catalog=CATALOG;User ID=USERID;Password=PASSWORD;persist security info=False;packet size=4096"/>