Grant the Service Account Access to the Database

Use this procedure to grant database access to the service account that you created for the Cobra Web Service.

To grant the service account access to the database:

1. Open SQL Management Studio and log in using a SYSADMIN account.
2. Expand the Security folder, right-click Logins, and click New Login.
   
3. On the Login-New screen, click Search next to the Login name field.
   
4. In the Select User or Group dialog box, perform the following:
   1. Click Locations and select Entire Directory in the list.
   2. In the Enter the object name to select field, enter the service account user name that you created, and click Check Names.
   3. Click OK.
   
5. On the Login-New screen, perform the following:
   1. In the Select a page pane, click Server Roles.
   2. In the Server roles pane, select sysadmin.
   3. Click OK to complete the process.