Optionally provide private feedback to help us improve this article...

Thank you for your feedback!


Updating the InstantKB Connection String

New

Once your InstantKB database is installed the next step is to modify the InstantKB database connection string to point towards the database we created in the previous step.

NOTE:  The database connection string can be found within the  <connectionStrings> area within the web.config file in the root of your InstantKB web site installation.If your using an earlier version of InstantKB the default connection string can be found within the <appSettings> section of the InstantKB web.config file.

The web.config file can be found within the root of the InstantKB web application folder. You should edit the web.config within Notepad or similar ASCII editor..

The only setting you'll need to update to ensure you can start using InstantKB is the database connection string. There are other settings for additional functionality such as exception handling which we won't cover right now. All settings within the web.config offer further information within the inline comments.

Updating the Database Connection String

By default InstantKB uses a trusted connection within the default connection string. This is great for local development however you may need to modify the connection string to use a specific SQL Server user account. This is shown below...

InstantKB 2018

<connectionStrings>    
   <add name="InstantASP_ConnectionString"
   connectionString="SERVER=localhost;UID=username;PWD=password;DATABASE=InstantKB2018;" />
</connectionStrings>

The connection string should be updated to contain a valid connection string to your InstantKB SQL Server database. A typical connection string consists of four parts which will all need to be updated to use your SQL Server connection details.

SERVER=TheSQLServerName
UID=YourSQLUsername
PWD=YourSQLPassword
DATABASE=TheForumDatabase

For example, say your InstantKB database is called "InstantKB", installed on a remote server for this example lets say "SQL.MYDOMAIN.COM" and you have a dedicated SQL Server account with username "Jon", password "Bob". You would need to update the connection string as shown below to accommodate these details...

SERVER=SQL.MYDOMAIN.COM;UID=Jon;PWD=Bob;DATABASE=InstantKB;