Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is it possible to connect to a SQL server in SQL Server Authentication if the server has been installed with Windows Authentication?

share|improve this question
it doesn't matter how SQL server was "installed", you can switch the authentication method at any time. –  adaptr Feb 22 '12 at 10:41
add comment

migrated from serverfault.com Feb 22 '12 at 11:51

This question came from our site for professional system and network administrators.

1 Answer

No. You'd need to be in "mixed mode" which is both SQL and Windows Authentication

share|improve this answer
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.