Giving SQL Server Permissions to Network Service or the Application Pool Identity

< Previous section  |  Table of Contents  |  Index  |  Next section >

In order for the appropriate identity to access the MainBoss database, it must be given appropriate permissions within SQL Server. To do so, follow these steps:

Start SQL Server Management Studio (or Management Studio Express). Specify the instance of SQL Server that holds the MainBoss database. In the left hand column of Management Studio, expand the entry for Security. Right-click on Logins, then click New Login. In the resulting window, click General in the left hand column. In the right hand part of the window, click Search. In the resulting window, under "Enter the object names to select", enter Network Service (with a space between the words) or else the application pool identity.
  1. Click Check Names to have Windows verify the specified name.
  2. Click OK to return to the previous window. You should see an appropriate identity filled into the "Login name" field.
In the left hand column of the window, click User Mapping. In the right hand part of the window, checkmark the checkbox associated with the MainBoss database. Under "Database role membership", checkmark the checkbox associated with MainBoss. (The "public" checkbox should be checkmarked automatically.) Click OK to return to Management Studio, then exit Management Studio.

< Previous section  |  Table of Contents  |  Index  |  Next section >