Control Manager uses an ODBC driver to communicate with the SQL server. For most instances, ODBC version 3.7 is sufficient. However, to use a Named Instance of SQL 2000, version 2000.80.194.00 is required.
The Control Manager setup program can verify the ODBC driver version if the SQL server is installed on the Control Manager machine. For remote SQL servers, verify the driver manually to ensure that Control Manager can access the database.
See also:
Understanding the Control Manager database
Understanding Control Manager data storage
Database recommendations
Authentication