Google Custom Search

Thursday, March 5, 2009

Disabling Windows Authentication in SQL Server????????

I have seen lot of people asking in forums "Can I disable windows authentication in SQL Server and have only SQL Authentication?". The obvious answer that he/she is going to get is "NO". For SQL server experts, they know the reason why it cannot be disabled but when a person asks this kind of question we have to understand that he/she is in infact stage of learning SQL Server. The reason why Windows Authentication cannot be disabled is that SQL Server runs as a SERVICE in Windows Operating System and the service runs under a Windows Local/Domain account.

No comments: