Create the database

The GRA uses its own database to store reading program data. This database can be completely segregated from any other databases on the same SQL Server.

There are two options when creating the database: you can execute a script or manually create the database and users using SQL Server Management Studio (SSMS).

From a script

  1. Connect to the database server to run a query (this can be done with SQL Server Management Studio by right-clicking on the server in the Object Explorer on the left and choosing New Query).

  2. Copy the text from the database create script and paste it into the query window.

  3. Click the Execute button in the toolbar.

From the user interface

Create the database

  1. Launch SQL Server Management Studio and connect to the database server.

  2. Double-click the server name to show the Databases folder.

  3. Right-click on the Databases folder and select the New Database… option.

  4. In the New Database window, enter a database name, for example: SRP.

  5. If you wish to have the database files stored in a different location than the default, scroll the Database files list to the right and change the presented Path to where you’d like to store the database files.

  6. Select Options from the page list on the left.

  7. For the Recovery model drop-down, change the selection from Full to Simple.

  8. Select OK to create the database.

Create the logins and users

  1. Right-click the Security folder and select New -> Login….

  2. Enter the Login name for the database owner user, for example: srp_owner.

  3. Select SQL Server authentication.

  4. Enter a secure password for this user in the Password and Confirm password fields. Make a note of this password.

  5. You can uncheck Enforce password policy so that the password for this account will not expire.

  6. Select User mapping from the Select a page list on the left.

  7. Locate the name of the database (this tutorial used SRP in Create the database step 4 above) in the Users mapped to this login list on the left.

  8. Check the appropriate box in the Map column to map this login to a user in the database.

  9. In the Database role membership for: list, select db_owner.

  10. Select OK to create the login and user.