Adding a SQL Server User

Now that you have created the screensteps_workgroup database you need to create a user account that can be used to log into the database from the ScreenSteps Desktop client.

Locate Logins

Locate Logins

Expand the Security > Logins folder to show a list of users.

Create New Login

Create New Login

Right-click on the Logins folder and select New Login... from the contextual menu.

Configure General Properties

Configure General Properties

In the dialog that appears do the following:

1) Set the login name. This example uses odbc_user but you could also choose something like screensteps_user.

2) Set a password using SQL Server authentication.

3) Turn off Enforce password expiration

4) Set the default database to screensteps_workgroup.

Configure Server Roles

Configure Server Roles

Now switch to Server Roles (1). Make sure public and sysadmin are checked (2).

The Result

The Result

The new user account will appear in the Security > Logins folder.

0 Comments

Add your comment

E-Mail me when someone replies to this comment