You must reconfigure the Symantec Endpoint Protection Manager after you migrate to SQL Server 2008 from a previous version of SQL Server.
Before you reconfigure the Symantec Endpoint Protection Manager, and after upgrading to SQL Server 2008 and restarting the computer, do the following:
To reconfigure Symantec Endpoint Protection Manager after migration to Microsoft SQL 2008
Click Start > All Programs > Symantec Endpoint Protection Manager > Management Server Configuration Wizard.
On the Welcome panel, check Reconfigure the management server and then click Next.
Make sure that the following information is retained from the previous Symantec Endpoint Protection Manager installation:
Web console port
Server data folder
On the Database type selection panel, click Microsoft SQL Server and then click Next.
Make sure that the following database parameters are correct:
SQL server port
About Microsoft SQL database authentication modes
User and Password
In the SQL Client folder dialog box, type the SQL Client folder location. The SQL Client folder is typically located in one of the following locations:
SQL 2000: C:\Program Files\Microsoft SQL\Server\80\Tools\Binn
SQL 2005: C:\Program Files\Microsoft SQL\Server\90\Tools\Binn
SQL 2008: C:\Program Files\Microsoft SQL\Server\100\Tools\Binn
Click Next and then complete the wizard with no other changes.
Upgrading to a new release of Symantec Endpoint Protection or Symantec Network Access Control