Connector Guides › Connectors Guide › Connecting to Endpoints › MS SQL Server Connector › Connector-Specific Features › Acquire an MS SQL Server Using the Provisioning Manager

Acquire an MS SQL Server Using the Provisioning Manager

You must acquire each MS SQL server before you can administer it with CA Identity Manager. To acquire an MS SQL server, you must do the following:

From the Endpoint Type task view

1. Register the machine as a endpoint using the Provisioning Manager.

   Use the MS SQL server Endpoint property sheet to register an MS SQL server instance. During the registration process, the Provisioning Server identifies the MS SQL server that you want to administer, and gathers information about it.

2. Explore the objects that exist in the endpoint.

   After registering the machine with the Provisioning Manager, you can explore its contents, using the Explore and Correlate Endpoint dialog. The Exploration process finds all MS SQL server objects. You can correlate the logins with global users at this time, or later.

3. Correlate the explored logins with global users.

   When you correlate logins, the Provisioning Server creates or links the logins on an endpoint with global users, as follows:

   1. The Provisioning Server attempts to match the login name with each existing global user name. If a match is found, the Provisioning Server associates each MS SQL server login with the respective global user. If a match is not found, the Provisioning Server performs the next step.
   2. If the Create Global Users as Needed button is checked, the Provisioning Server creates a new global user and then associates the login with the global user. If the Create Global Users as Needed is unchecked, the Provisioning Server performs the next step.
   3. The Provisioning Server associates the login with the default user object.