Cb Protection: How to Verify Connection Settings in the Web.config File

[#1]

Environment

• Cb Protection Server: 8.0 and Higher

Objective

To verify the connection string in the Web.config file is correct.

Resolution

1. Navigate to C:\Program Files (x86)\Bit9\Parity Console\API\
2. Backup the Web.config file to your Desktop
3. Edit the file
4. Locate a string similar to:

   <add name="ConnectionString" connectionString="Integrated Security=SSPI; server=.; database=das;" providerName="System.Data.SqlClient"/>

5. Make sure that the server= and the database= are both correct for this installation.
   • A server address of . means local. If you are running a two-tier configuration you will need to add the database server name Master\Master (normally found in the object explorer of SQL Server Management Studio)
   • In some instances the server name will be something like .\SQLEXPRESS and removing that trailing information can help resolve issues as well (This was seen when upgrading from Version 8 Patch 4 to Version 8 Patch 6)