Creating a New SQL Server Admin User

A SQL Server user with system administrator rights is required to perform subsequent setup steps.

This user requires the following permissions:
  • Either sysadmin or both db_ddladmin and db_owner.
  • db_datareader.
  • db_datawriter.

These permissions are required because the user needs to be able to create indexes by using the CREATE INDEX (Transact-SQL) statement. Once the Silk Test Workbench database has been created, all users who connect to the database only require db_datareader and db_datawriter permissions.

  1. To create a new user with system administrator rights, perform the following steps:
    1. In the Object Explorer of SQL Server Management Studio, navigate to the Security folder and expand it.
    2. Right-click the Logins folder and choose New Login. The Login - New dialog box opens.
    3. Select the General page, and then enter a user name in the Login name text box.
    4. Select SQL Server Authentication and enter a password.
    5. Select the default database from the Default database list.
    6. Select the Server Roles page, and then check the sysadmin check box in the Server roles list.
    7. Select the User Mapping page.
    8. In the Map column, check the check box for the database that the new login can access. By default, the login name appears in the User column. Leave this value.
    9. In the Database role membership for list, check the db_owner check box.
    10. Click OK.
  2. To create a new schema for the new user, perform the following steps:
    1. In the Object Explorer, navigate to the database in which you want to create a schema.
    2. Expand the database object tree to show the Schemas folder. The Schemas folder is a child of the Security folder for the database. For example, if you are adding a schema to the master database, expand the following folders to show the Schemas folder: Databases > System Databases > master > Security.
    3. Right-click the Schemas folder and choose New Schema.
    4. In the Schema name text box, type a name for the new schema. The new schema name must match the name of the previously created user with system admin rights.
    5. Assign the new user with system administrator rights as the owner of the schema.
    6. Click OK.
  3. To add the schema to the database, perform the following actions:
    1. Expand the database object tree to show the Users folder. The Users folder is a child of the Security folder for the database. For example, if you are adding a schema to the master database, click Databases > System Databases > master > Security > Users.
    2. Double-click the admin user you have just created. The Database User dialog box appears.
    3. Select the Owned Schemas page and check that the schema you have just created has been assigned to the new database.