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 |
|
muralidaran_r
Starting Member
13 Posts |
 Posted - 2009-04-09 : 02:49:44
|
| We have our project installed in client place.Operating system Windows 2003Databases on SQL Server 2005I have backup jobs running daily(owner <servername>\Administrator)I have mirrored using certificatesSQL services logon as <servername>\AdministratorWe want to disable the SQL Server windows authentication login.I have a plan to remove below logins:<servername>\AdministratorBuiltin\Administrator<servername>\SQLServer2005MSFTEUser$<servername>$MSSQLSERVER<servername>\SQLServer2005MSSQLUser$<servername>$MSSQLSERVER<servername>\SQLServer2005SQLAgentUser$<servername>$MSSQLSERVERPlease help me in finding what side effects I will face if i do this. |
|
|
Mangal Pardeshi
Posting Yak Master
110 Posts |
Posted - 2009-04-09 : 04:05:07
|
| Before doing this, make sure you have atleast one login with sysadmin rights.Read the - What steps should I take prior to considering removing this group? from follwoing linkhttp://www.mssqltips.com/tip.asp?tip=1017Mangal Pardeshihttp://mangalpardeshi.blogspot.com |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-09 : 22:26:10
|
| You just can't disable Windows authentication. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-04-11 : 08:03:02
|
| If your intention is to disallow all Windows Authentication - manage this through the various Logon\user accounts.Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
|
|
|
Removing Windows Authentication