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](https://media.screensteps.com/image_assets/assets/005/560/520/original/media_1280408684283.png)
Expand the Security > Logins folder to show a list of users.
Create New Login
![Create New Login](https://media.screensteps.com/image_assets/assets/005/560/522/original/media_1280408697964.png)
Right-click on the Logins folder and select New Login... from the contextual menu.
Configure General Properties
![Configure General Properties](https://media.screensteps.com/image_assets/assets/005/560/524/original/media_1282240794864.png)
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](https://media.screensteps.com/image_assets/assets/005/560/526/original/media_1280413576719.png)
Now switch to Server Roles (1). Make sure public and sysadmin are checked (2).
The Result
![The Result](https://media.screensteps.com/image_assets/assets/005/560/528/original/media_1280408807352.png)
The new user account will appear in the Security > Logins folder.
0 Comments
Add your comment