Adding Windows Users to SQL Server¶
The following instructions will show you how to add a user to SQL 2005 or 2008. It is necessary to create logins for the users of JustWare so that they will have access to the JustWare database from the JustWare client on their machines and from SQL Reporting Services.
- Navigate from the Start Menu to Programs | Microsoft SQL Server | SQL Management Studio.
- In Microsoft SQL Server Management Studio, connect to the SQL Server instance on which the JustWare database is installed.
- In the Object Explorer, expand Security and Logins.
Right-click Logins, and select New Login.
The Login - New dialog box opens.
Type the name of the user or group in the New Login window (e.g., Domain\UserName or Domain\GroupName).
Click User Mapping in the left pane.
The Users mapped to this login and Database role membership for tables open.
Select the JustWare database check box in the Users mapped to this login table.
The available roles for the JustWare database will appear in the Database role membership for table.
Select the role you want the user/group to have, and click OK.
The user/group will be added to the JustWare database with the role you have assigned.
Note: If the user/group name you selected already exists in SQL Server, an error message will appear. However, the user/group will be added to the role you selected and have the appropriate client and SRS access to database information.