|
1 |
Open the SQL Server Security module. |
|
3 |
|
4 |
Type a name, or click Search to locate a name. |
|
5 |
Select whether to use Windows® or SQL Server® Authentication. If you select SQL Server Authentication, assign a password. |
|
7 |
To assign server roles, open the Server Roles tab. |
|
8 |
To assign user mappings, open the User Mappings tab. |
|
1 |
Open the SQL Server Security module. |
|
3 |
|
4 |
You can change the default database, server role, and user mapping.
|
1 |
Open the SQL Server Security module. |
|
3 |
Select a login, and select Tools | Properties. |
If you are using Microsoft® SQL Server® 2012, 2014, 2016, or 2019, you can manage SRS roles and permissions.