Re: Windows users
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 10/19/05
- Next message: Sue Hoegemeier: "Re: Stop Users from editing stored Procesdures through Enterprise Mana"
- Previous message: Rob R. Ainscough: "Re: sa loginname being hacked"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 18 Oct 2005 19:56:25 -0600
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
On Tue, 18 Oct 2005 17:23:02 -0700, "Andy"
<Andy@discussions.microsoft.com> wrote:
>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
- Next message: Sue Hoegemeier: "Re: Stop Users from editing stored Procesdures through Enterprise Mana"
- Previous message: Rob R. Ainscough: "Re: sa loginname being hacked"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
