Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Windows Logon vs SQL Server 'SA' Logon Expand / Collapse
Posted Tuesday, June 23, 2009 2:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 16, 2013 4:25 PM
Points: 2, Visits: 44
How can I eliminate SQL SERVER 2005 from authenticating users through WINDOWS LOGON and simply use SQL SERVER 'SA' username and password or other such defined users?
Post #740536
Posted Tuesday, June 23, 2009 2:43 PM



Group: General Forum Members
Last Login: Today @ 6:24 AM
Points: 23,522, Visits: 37,765
You can't disable Windows Authentication. The best you can do is not grant access to your servers to windows user or group accounts. If you don't authorize them access, they can't connect or access your servers.

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #740558
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse