Windows users

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andy - 19 Oct 2005 01:23 GMT

Hi All,
Is there a way to keep the windows users off from the sql databases. My
problem is all our lanwan people are admin on the server and they go in any
database and can do whatever they want. How can I keep them out.
I just want the databases to be access by sql users only.
I want to keep those lanwan and other windows users out of sql databases.
Please help.

Thanks
Andy

Reply to this Message

Sue Hoegemeier - 19 Oct 2005 02:56 GMT

By default, SQL Server will add the BUILTIN\Administrators
group to the sysadmin role. So everyone in the local admins
group is a sysadmin.
You can remove the builtin\administrators group from SQL
Server. However, under some scenarios, this can cause
problems. Whether you experience problems or not depends.
The following article has a more information section with
links to some issues that could come up:
INF: How to impede Windows NT administrators from
administering a clustered instance of SQL Server
http://support.microsoft.com/?id=263712

-Sue

>Hi All,
>Is there a way to keep the windows users off from the sql databases. My
[quoted text clipped - 6 lines]
>Thanks
>Andy

Reply to this Message