Modify an existing SQL Server ODBC connection for vCenter Server


1
Take the snapshot of vCenter Servers.
2
Click the System DSN tab and do one of the following.
To modify an existing SQL Server ODBC connection, select the connection from the System Data Source list and click Configure.
To create a new SQL Server ODBC connection, click Add, select SQL Native Client, and click Finish.
3
Type an ODBC datastore name (DSN) in the Name text box.
For example, VMware vCenter Server.
4
(Optional) Type an ODBC DSN description in the Description text box.
5
Select the server name from the Server drop-down menu.
Type the SQL Server host name in the text box if it is not in the drop-down menu.
6
Select one of the authentication methods.
Integrate Windows authentication. Optionally, enter the Service Principal Name (SPN).
SQL Server authentication. Type your SQL Server login name and password.
7
Select the database created for the vCenter Server system from the Change the default database to menu.
8
Click Finish.
9
For SQL Server 2005 and SQL Server 2008 editions, test the data source by selecting Test Data Source and clicking OK from the ODBC Microsoft SQL Server Setup menu.
10
Verify that the SQL Agent is running on your database server.

No comments:

Post a Comment