Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
walidb
Starting Member
4 Posts |
 Posted - 2008-10-08 : 03:11:47
|
| Hi,how i can deny and stop network administrator from accessing my databases in SQL 2005, before in SQL 2000 there was option for SQL authentication but now no choices mixed mode or windows.I can managed by adding his windows login in the security and deny him from accessing the databses but, any new user in the domain can access the sql server also can open the data bases.so how i can have a solid solution. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-10-08 : 05:23:58
|
| Maybe this:Control it using logon triggerhttp://technet.microsoft.com/en-us/library/bb326598(SQL.90).aspxWebfredPlanning replaces chance by mistake |
 |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-10-08 : 05:33:15
|
| maybe i'm misunderstanding the problem, but can you not just remove the builtin\administrators group?Em |
|
|
|
walidb
Starting Member
4 Posts |
Posted - 2008-10-08 : 06:15:23
|
quote:
Originally posted by elancaster
maybe i'm misunderstanding the problem, but can you not just remove the builtin\administrators group?Em
If I removed the builtin\administrators group this will prvent any windows user who has access to the SQL Server from opening the database.or accessing the SQL management studio ? |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-10-08 : 06:24:40
|
| the builtin\administrators group (be default at least) means that anyone with admin rights on the server itself has sysadmin rights on your sql server. if you remove it you then need to give individual windows users the rights they actually needEm |
|
|
|
|
|
|
disables windows authentication