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.
1 |
Open the SQL Server Security module. |
3 |
Select Server Roles, and select Tools | New. Alternatively, right-click Server Roles, and choose New. |
6 |
Click Add to add logins to the selected server role. |
7 |
Select the server role, open the Memberships tab, and select the database roles to assign to the server role. |
8 |
1 |
Open the SQL Server Security module. |
3 |
Select a server role, and select Tools | Delete. Alternatively, right-click a server role, and choose Delete. |
4 |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center