Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrades.
Please accept our apologies in advance for any inconvenience this might cause.

How to install SCSP with Microsoft SQL Server 2008 R2 Express Edition

Created: 20 Mar 2012 • Updated: 23 Sep 2012 | 7 comments
Language Translations
Shulk's picture
+11 11 Votes
Login to vote

Content:

  • Overview
  • Descriptive steps
  • Related articles

Overview

  1. How to obtain SCSP,
  2. Installation and configuration of Microsoft SQL Server 2008 R2 Express Edition,
  3. Installation of the CSP Management Server,
  4. Installation of the CSP Management Console,
  5. First login.

Descriptive steps

The installation and configuration is quite simple and fast.

1) How to obtain SCSP:

a. Go to the Symantec FileConnect Web site.
b. Click your language to log on to the FileConnect system.
c. In the Serial Number box, type the serial number that is printed on your certificate or upgrade insurance notice, and then click Login.
Note: If you do not know your serial number, contact Symantec Enterprise Customer Service.
d. On the End User License Agreement Web page, click I Agree.
e. Under Products, click the product version that you want to download.
Note: You will select the specific build that you want to download on a later screen.
f. Select a download method, and then click Continue.
g. Select the file for the build that you want to download, and then click Download.

Basic or Essential support customers in other regions
Refer to the technical support telephone number that you received when you purchased your product and maintenance contract. For a list of technical support telephone numbers in other regions, go to the Symantec Worldwide Corporate Directory Web site.

Customers without a support contract
To purchase a current version of a Symantec product, go to the Symantec PartnerNet Locator Web site to locate a Symantec Partner.

2) Installation and configuration of Microsoft SQL Server 2008 R2 Express Edition:

a. Download Microsoft SQL Server 2008 R2 Express Edition from http://www.microsoft.com/download/en/details.aspx?id=23650

b. Run SQLEXPRWT_x64_ENU

Note: Only the key points of the installation and configuration will be shown below.

Installation Configuration - Specify the name for the instance of SQL Server (in this case SCSP):

Server Configuration - Select Automatic as startup type for the SQL Server Browser:

Database Engine Configuration - Specify Mixed Mode as authentication mode and specify the sa password:

Complete the installation.

c. Once the installation completed, open the SQL Server Configuration Manager from Start > All Programs > Microsoft SQL Server 2008 R2 > Configuration Tools,

Expand SQL Server Network Configuration and click on Protocols for SCSPDB and finally enable TCP/IP protocol:

Once TCP/IP protocol enabled, the restart of the services is required to apply the modification.

3) Installation of the CSP Management Server:

a. Double click the server.exe file from the installation folder or CD to start the installation,

b. Select Production Installation:

c. Specify the same sa password specified during the SQL Server installation:

Note: If the wrong instance name and/or sa password are/is entered, the error below will pop up:

d. Specify an SCSP database owner password:

Note: If the specific password lengh is not respected, the below window will show up:

Complete the installation.

Note: If the installation fails with the error "Database population FAILED", see below article for troubleshooting.

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

4) Installation of the CSP Management Console:

a. Double click the console.exe file from the installation folder or CD to start the installation,

Complete the installation.

5) First login:

a. Click Start > Programs > Symantec Critical System Protection > Management Console.
b. In the Login window, click the green plus sign.
c. In the New Server Configuration panel, replace New Server with the name that you want to use to identify your server.
d. In the New Server Configuration panel, specify the server configuration parameters, and then click OK.
e. In the Login window, type symadmin in the User name box, select the new server that you added, and then click Login.
f. In the Verify Server Certificate panel, select Always accept this certificate, and then click OK.
g. In the Set Password panel, in the Password and Confirm Password boxes, type the password to associate with the symadmin user name, type the password again to confirm, and then click OK.

Related articles

How to install SCSP with Microsoft SQL Server 2008 R2 Express Edition

SCSP - Error "Database population FAILED"

How to install SCSP agent on Windows, UNIX and Solaris

How to use the SCSP Agent Configuration Tool

How to upgrade SCSP to a newer release

How to import, create and update default policies in SCSP

Configuring Virtual Agents in SCSP 5.2 RU8

How to install the SCSP SymIDS ISAPI filter on Windows Server 2008 R2

Symantec Critical System Protection 5.2 RU9 Docs

Comments 7 CommentsJump to latest comment

pete_4u2002's picture

A very helpful article :-). Thumbs up !

0
Login to vote
Shulk's picture

Hi Pete,

Thanks a lot for your comment, very appreciated!

Best regards,

Shulk

0
Login to vote
cemilebaşak's picture

Thanks this is a very use full article. Because on KB and also on the pdf I was not able to find use full things.

Regards;

Cemile Denerel BAŞAK

Note: Please mark as solution if its help you.

0
Login to vote
Shulk's picture

Thank you for the feedback Cemile ;)

Shulk

0
Login to vote
Jay_1182's picture

Thanks Shulk for posting the steps,

I need to migrate the SCSP manager and DB (OS- Win2k3, SQL-2005) on same server setup to a new server (OS- Win2k8r2, SQL-2008r2) with same IP details, how should i plan to proceed inorder to acheive successful migration and resume the agents reporting.

 

Regards,

Jay 

 

 

0
Login to vote
Dharamveer Yadav's picture

Good artical, It works. Thanks a lot.  yes

0
Login to vote