Home > IT Answers > SQL Server > Configuring a SQL Server installation to acce...
Help

Question

  Asked: Jun 9 2008   3:42 PM GMT
  Asked by: SQL Server Ask the Experts

Configuring a SQL Server installation to accept only SQL Server authentication


SQL Server, SQL Server installation, Windows authentication, SQL Server authentication

How do you configure a SQL Server installation to accept only SQL Server authentication and not both SQL and Windows authentication?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jun 9 2008  10:37 PM GMT  by Mrdenny




There is no way to configure the server to not accept Windows Authenticaion.

You should consider using Windows Authentication as it is more secure than SQL Server authentication.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server and Security.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   Jun 9 2008  10:40PM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.