Clever Geek Handbook

Configuring Sql Server 2005 Security Service

I am new to SQL Server and I was instructed to set permissions on a remote server. I need to restrict domain administrator access to any of the databases on a specific server. How can i do this?

0


source to share


2 answers


Remove BUILTIN / Administrators from SA group.



+2


source


Important! Before you do this, make sure you have:

  • the password for the "sa" account, or
  • your domain account is a member of the sysadmin server role


Otherwise, you may end up locked from the server .. not that this has ever happened to me. -)

+1


source






More articles:


All Articles