Step 17 - Add ADRMSService to SQL Logins

Applies To: Windows Server 2008, Windows Server 2008 R2, Windows Server 2012

This step explains how to add the AD RMS Service Account (ADRMSService) to SQL Logins on SQL2. This allows the service account to connect to SQL2.

To add ADRMSService to SQL Logins

1. Log on to SQL2.fabrikam.com as Administrator.

2. Click Start, select All Programs, click Microsoft SQL Server 2008 and select SQL Server Management Studio. This will bring up the Connect to Server dialog box. Ensure that the Server name is SQL2 and that Authentication is set to Windows Authentication. Click Connect.

3. On the right, expand Security, right-click Logins, and select New Login. This will bring up the Login – New screen.

   

4. On the Login – New screen, click Search. This will bring up a Select User or Group box.

5. On the Select User or Group box, enter fabrikam\ADRMSService in the box below Enter the object name to select (examples) and click Check Names. This should resolve with an underline. Click Ok.

   

6. On the Login – New screen, click OK. This will close the Login – New screen.

7. Close SQL Server Management Studio.