I want to access mssql2000 server only by 'sa' & database login ids. I want to restrict windows administrator account to access the database. Please help !!!
Our enviorment :- SQL2000 with SP3 on Windows2000 advanced server with latest service pack..Create new login under the Logins node in EM and add "domain Admins" group. Select "Deny Access" under the Authentication option.
You can also restrict the group to individual databases by adding it in a particular database and assinging it specific roles(deny datareader,deny datawriter) etc.|||What's the SQL Server Agent running under?
Builtin\Admin?
In that case it will have sa rights..
You need to create a new account, give it sa, change the sql server agent to run with that
And remove auth to builtin...builtin still needs to be around to start up the box...
Oh and buy the book SQL Server 2000 ADMIN 911
Talks all about it...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment