The following procedure should be performed on the database server computer for each user who needs to connect to the SQL
server database.
In the Object Explorer of SQL Server Management Studio, navigate to the
Security folder and expand it. Right-click the
Logins folder and choose
New Login.
The
Login - New dialog box opens.
Select the
General page, and then enter a name for the database in the
Login name text box.
Select either
Windows Authentication or
SQL Server Authentication.
Select the default database from the
Default database list.
Select the
User Mapping page.
In the
Map column, check the check box for the database that your login can access.
By default, the login name appears in the
User column. Leave this value.
In the
Default Schema column, enter the default schema.
For use with
Silk Test Workbench, the default schema must match the schema of the previously created user with system admin rights.
In the
Database role membership for list, leave the default option
public selected.
Check the
db_datareader and
db_datawriter
check boxes.
Click
OK.
Important: To use SQL Server Express with multiple users, each SQL Server Express installation must be enabled for remote connectivity.
To enable SQL Server Express for remote connectivity, refer to the Microsoft support article
How to enable remote connections on SQL Server
.