Reconfiguring a Microsoft SQL database

Article:HOWTO26899  |  Created: 2010-01-08  |  Updated: 2010-01-15  |  Article URL http://www.symantec.com/docs/HOWTO26899
Article Type
How To


Environment


Reconfiguring a Microsoft SQL database

You need to use the Management Server Configuration Wizard to reconfigure the Microsoft SQL database.

See About the reconfiguration of a database.

To reconfigure a Microsoft SQL database

  1. Stop the Symantec Endpoint Protection Manager service by selecting Start > All Programs > Administrative Tools > Services.

  2. Locate Symantec Endpoint Protection Manager and then right-click to select Stop.

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

  4. In the Welcome to the Management Server Configuration Wizard screen, click Reconfigure the management server.

  5. Click Next to begin the reconfiguration.

  6. Edit the name of the computer on which the management server is installed in the Server name box.

  7. Edit the HTTPS port number that the management server listens on in the Server port box.

    The default port number is 8443.

  8. Edit the location of the server data folder or browse to the root folder where data files are located.

    The root folder includes backups, replication, and other management server files.

    The default pathname is C:\​Program Files\​Symantec\Symantec Endpoint Protection Manager\data)

  9. Click Next.

  10. Click Microsoft SQL Server.

  11. Click Next.

  12. Type the name of the database server in the Database server box, if applicable.

    Type the IP address or host name of the database server where the SQL Server Enterprise Manager (SEM) server saves application data.

  13. Type the number of the SQL server port in the SQL server port box.

    The default port number is 1433.

  14. Type the name of the database in the Database Name box.

    The name of the Microsoft SQL database where application data is stored.

  15. Type the name of the user in the User box

    This name represents the user who is responsible for the database.

  16. Type the password in the Password field.

    This password is for the database user. This field cannot be blank.

  17. Type the name of the SQL client path in the SQL Client Path.

    By default, the SQL client bin folder contains the bcp.exe file. For example, C:\Program Files\Microsoft SQL Server\80\Tools\Binn.

    The bcp.exe file must reside on the same computer as the one on which you installed the management server. This file is part of the SQL Server client package. You must also correctly specify the Microsoft SQL Client pathname in the Management Server Configuration Wizard. If the pathname is not specified correctly or the Microsoft SQL Client package was never installed, then you cannot reconfigure the database.

  18. Click Next.

    The database is then created. This process only takes a few minutes. A database message appears during that period of time if the management server service is still running.

  19. You can select to Start Symantec Endpoint Protection Manager and Start Management Console.

    These options are selected by default.

  20. Click Finish.

    You completed the reconfiguration of the database. If you kept the start options selected, the console logon appears.


Legacy ID



349256


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


Terms of use for this information are found in Legal Notices