13.4 Adding SQL Server Endpoints in Secure Configuration Manager

To add SQL Server endpoints to an existing agent in Secure Configuration Manager:

1. Log in to the Windows console for Secure Configuration Manager.

2. Expand IT Assets > Agents > OS > Windows.

3. In the content pane, right-click the Windows agent to which you want to add the endpoint, and then click Add Endpoint.

4. Click Next.

5. (Optional) To find an existing system on which to add an endpoint, click Existing Systems. Select a system and click OK.

6. In the Name field, type a name for the endpoint.

   NOTE:Secure Configuration Manager does not allow an endpoint to be monitored by more than one agent, so you must enter an endpoint name that does not already exist on the computer. For more information, see Planning Microsoft SQL Server Endpoint Deployment.

7. For Endpoint Type, select SQL Server.

8. Click IP Lookup to look up the IP address of the endpoint or type the IP address in the IP Address field. Secure Configuration Manager supports IPv4 and IPv6 addresses.

9. In the endpoint properties table, verify or type the following required information.

   Field	Description
   Host Name	Name of the host computer running the SQL Server database.
   IP Address	IP address of the database. Secure Configuration Manager supports IPv4 and IPv6 addresses.
   Database Protocol	Connection protocol used by the Windows agent to connect to the SQL Server database.
   Database Port or Pipe	Property for the database connection protocol specified in the Database Protocol field. If you selected TCP/IP, enter the port number (1433 by default). If you selected Named Pipes and the pipe name is the default \\.\pipe\sql\query, enter sql\query. Otherwise, enter the full pipe name.
   Authentication Mode	Account used by the Windows agent to log in to the SQL Server endpoint. Select SQL to use a SQL Server account (requires mixed-mode) defined in Enterprise Manager. Select Current Credentials to use the Windows-authenticated account defined when you installed the Windows agent. Select Use Impersonation to use another specified Windows authenticated account. This account must be within your domain. Whether you use a SQL Server or Windows authenticated account, ensure that you have added this account to the sysadmin (System Administrators) role in SQL Server Enterprise Manager.
   User Name	User name for the SQL Server authenticated login account or the account being impersonated. This field is not required if you selected Current Credentials in the Authentication Mode field.
   Password	Password for the SQL Server authenticated login account or the account being impersonated. This field is not required if you selected Current Credentials in the Authentication Mode field.
   Major Version	Version of SQL Server the endpoint is running.

10. (Optional) To add more information about the endpoint, complete the following endpoint properties.

    Field	Description
    Instance Name	Name of the database instance.
    Contact Email	Email address of the contact person.
    Contact Name	Name of the designated contact person.
    Importance	Criticality level of the endpoint.
    License Type	Product for which you are licensing this endpoint.
    Location	Location of the computer hardware.
    Notes	Descriptive notes about the endpoint.
    Time Zone	Time zone in which the computer hardware is located.
    Service Pack	Microsoft Service Pack applied to the Windows operating system.
    Version	Version of the SQL Server database that the endpoint represents.

11. (Optional) To add the endpoint to a group, complete the following steps:

    1. Click Add Endpoint to a Group, and then click Groups.

    2. To add the endpoint to an existing group, select the group.

    3. To add a new group for the endpoint, enter the new group name and description, and then click Create New Group.

    4. Click Finish to return to the Define Endpoint window.

12. (Optional) To add more than one endpoint, click Add Endpoint. Repeat Step 5 through Step 11 for each endpoint that you want to add.

13. Click Finish.