Menu
My SQL 2008 R2 Server is configured for Windows authentication, but only my domain administrator account is granted access to connect to the object explorer.
I need to grant my non-administrator domain-user access as well, so I can log in from my local workstation.
313
Right-click a stored procedure and select Properties. In the Stored Procedure Properties -stored_procedure_name dialog box, under select a page, select Permissions. Use this page to add users or roles to the stored procedure and specify the permissions those users or roles have.
Using SQL Server Management Studio First, move to “Object Explorer” and expand the database that you want. Next, under the database, expand the “Security” directory. Now, under Security, expand the “Users” option. This will display a list that contains all the users created in that database.
Use xp_logininfo to retrieve AD group members list.
Connect to the object explorer. Navigate down to the server > Security > Logins. Right click and select new login (or add login). In the new window put your domain account (or group) and grant it what ever rights you want it to have. If this is just your personal SQL instance on your workstation then just make your account a sysadmin.
65
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
