0

I am actually using SQL server for my application. If I work with one user (Install and Update app with WIX installer) everything works good, but if I try to change me windows user account to the other user, who can work with such database, but do not have Login of the user who was installing app with publishing DB, in Logins directory in SSMS. This user uses SQL Server Authentication. Is there a way to allow users who are in the Windows Active directory in domain admin group to add them all database previlages? Thanks in advance

1 Answer 1

0

If I understand correctly, you may add your domain admin group by following steps:-

  1. Right-click on the Logins under Security at your database server: New Login

  2. Add new login under Windows authentication: Windows authentication

  3. Tick sysadmin at Server Roles page: sysadmin Server Roles

Notes: Be careful to the server roles you are assigning to your domain admin group users, just assign the minimum privilege they need for their jobs.

Read more on Server-level roles: https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles?view=sql-server-ver16

3
  • Another way to go would be to grant the group DBO to the needed (or all) databases. Don't hand out SA unless absolutely necessary.
    – SQLMac
    Nov 11, 2022 at 16:51
  • Thank you so much Nov 11, 2022 at 20:55
  • You're most welcome! Nov 12, 2022 at 2:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.