Managing Microsoft SQL Servers › Registering Microsoft SQL Servers

Registering Microsoft SQL Servers

To register a Microsoft SQL server, follow these steps:

1. Install Microsoft Data Access Components (MDAC) 2.8.
2. Register the Windows domain in which the Microsoft SQL server belongs using the CA SRM Computer Registration Wizard. For more information, see the chapter “Managing Network Storage Objects.”
3. Register the Microsoft SQL server using the CA SRM SQL Registration Wizard. For more information, see Using the CA SRM SQL Registration Wizard in this chapter.

If you want to register Microsoft SQL Server 2005, you need to install the Microsoft SQL 2005 client software on the proxy collector. You also need to use the Windows authentication method during this collection.

To assure that SQL discovery finds all of the SQL servers in the domain, make sure that the domain proxy machine has the Microsoft SQL 2005 client installed.