Migrating to Microsoft SQL 2008 from a previous version

Article:HOWTO17917  |  Created: 2009-01-02  |  Updated: 2011-07-08  |  Article URL http://www.symantec.com/docs/HOWTO17917
Article Type
How To


Environment


Migrating to Microsoft SQL 2008 from a previous version

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:

  1. In SQL Server Network Configuration, open Protocols for <instance name>.
  2. Enable IP1 and IP2 (host IP and loopback IP, respectively).
  3. Save the changes and proceed to reconfigure the Symantec Endpoint Protection Manager .

To reconfigure Symantec Endpoint Protection Manager after migration to Microsoft SQL 2008

  1. Click Start > All Programs > Symantec Endpoint Protection Manager > Management Server Configuration Wizard.

  2. On the Welcome panel, check Reconfigure the management server and then click Next.

  3. Make sure that the following information is retained from the previous Symantec Endpoint Protection Manager installation:

    • Server name

    • Server port

    • Web console port

    • Server data folder

  4. Click Next.

  5. On the Database type selection panel, click Microsoft SQL Server and then click Next.

  6. Make sure that the following database parameters are correct:

  7. 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

  8. 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


Legacy ID



330692


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


Terms of use for this information are found in Legal Notices