SCSP - Error "Database population FAILED" and "MDAC"

Article:TECH182922  |  Created: 2012-03-02  |  Updated: 2014-10-03  |  Article URL http://www.symantec.com/docs/TECH182922
Article Type
Technical Solution


Issue



During the installation of the SCSP Managenent Server, it fails while creating the database with the error "Database population FAILED".

 

Or possibly with the below MDAC error:


Solution



Causes & Solutions

1. The SCSPDBA password that was entered during setup was not complex enough.

Specific length must be respected

Specific length must be respected: 8 characters minimum including uppercase, lowercase, a number and a non-alphanumeric character (only _ or # are allowed by SCSP).

2. The TCP/IP setting is disable in SQL Server Configuration.

To enable TCP/IP setting in SQL Server Configuration

  1. In the Microsoft SQL Server Configuration Window, in the left pane expand your server group.
  2. Right-click TCP/IP and then click Enable.
  3. Click OK.
  4. Restart the SQL Server service.

Re-run the Symantec Critical System Protection install.

 

3. The SQL Browser service is stopped.

Start the SQL Browser service from services.msc

 Check the collation was set to Latin 

 

4. The SQL database is offline.

To verify that your database is online

  1. In the Microsoft SQL Management console, in the left pane expand your server group.
  2. Look at the icon for your server and verify that the icon for it has a green circle with a white arrow 
  3. If it does not have the green circle with a white arrow, right click and select Start.

Stopped  to Started .

 

5. The communication between the CSP Management Server and the SQL Server is blocked.

To verify the communication

In SQL Server 2005, the below command is preferred:

  1. Open a command prompt.
  2. Run the command:
    OSQL –U sa –P <sa password> -S <hostname or IP address of SQL box>\SCSP (or database instance name used during the install)
  3. If successful, 1> will be returned.

In SQL Server 2008, the below command is preferred:

sqlcmd -U sa -P <password> -S tcp:<computer name>\<instance name>

 

6. Mixed mode for the authentication mode is not selected.

To verify the authentication mode

  1. In the Microsoft SQL Server Enterprise Manager console, in the left pane expand your server group.
  2. Right-click the your server and then click Properties.
  3. In the Instance Properties dialog box, on the Security tab, verify that the SQL Server and Windows option button is selected.
  4. Click OK.

Re-run the Symantec Critical System Protection install.

7. Incorrect instance name used.

Make sure to use the correct instance name during the installation

8. Previous installation leftovers.

Manually delete all the files/folders in C:\Program Files (x86)\Common Files\Symantec Shared\SCSP\MSSQL.1\MSSQL\ directory before doing fresh SCSP server installation.

Logs

- %ProgramFiles%\Symantec\Critical System Protection\Server\SISManagementInstallWrapper.txt

- %ProgramFiles%\Symantec\Critical System Protection\Server\SISManagerSetup.txt

- %ProgramFiles%\Symantec\Critical System Protection\Server\msde-dbStatus.txt

 

 


Attachments

defaultcollation.gif (80 kBytes)


Article URL http://www.symantec.com/docs/TECH182922


Terms of use for this information are found in Legal Notices