RE: Authentication in MSDE 2000
- From: changliw@xxxxxxxxxxxxxxxxxxxx ("Charles Wang [MSFT]")
- Date: Tue, 21 Apr 2009 02:20:25 GMT
Dear Strawberry,
Welcome to Microsoft TechNet Managed Newsgroup. My name is Charles
Wang[MSFT]. It is my pleasure to work with you on this post.
For your 1st question, "How to remove windows Authentication mode in MSDE
2000?", unfortunately it cannot be removed. The reason is that by design
SQL Server supports two authentication modes, one is Windows Authentication
Mode, while the other is mixed mode which contains both Windows
Authentication and SQL Server Authentication. No matter which
authentication mode you choose, it will use Windows Authentication.
Please refer to:
Authentication Mode
http://msdn.microsoft.com/en-us/library/aa176599.aspx
If you are concerned with the windows administrators group, you can
explicitly limit the permissions of the BUILTIN\Administrators group in
your SQL Server. For example:
exec sp_dropsrvrolemember 'BUILTIN\Administrators','sysadmin'
Go
Regarding the stored procedures of adding or dropping the existing fixed
server roles assigned to a login, you can refer to these articles:
sp_dropsrvrolemember
http://msdn.microsoft.com/en-us/library/aa933289(SQL.80).aspx
sp_addsrvrolemember
http://msdn.microsoft.com/en-us/library/aa259597(SQL.80).aspx
Regarding your 2nd question, as I have explained, I am afraid that you have
to live with it. However you can restrict Windows account's access
permissions in your SQL Server instance by removing the existing
permissions to the mapped sql logins or simply removing the logins. To
remove a login, you can use the stored procedure sp_droplogin:
sp_droplogin
http://msdn.microsoft.com/en-us/library/aa933285(SQL.80).aspx
If you have any other questions or concerns, please do not hesitate to let
me know. I will do my best to help.
Best regards,
Charles Wang
Microsoft Online Community Support
Get Secure! - www.microsoft.com/security
====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
====================================================
.
- References:
- Authentication in MSDE 2000
- From: strawberry
- Authentication in MSDE 2000
- Prev by Date: RE: Script Wizard in Sql Express 2008 -- missing objects, blowing
- Next by Date: RE: How to recover deleted records in transaction log
- Previous by thread: Authentication in MSDE 2000
- Next by thread: RE: Authentication in MSDE 2000
- Index(es):
Relevant Pages
|
