Windows Logon vs SQL Server 'SA' Logon

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Kelley » Windows Logon vs SQL Server 'SA' Logon

Windows Logon vs SQL Server 'SA' Logon

Rate Topic

Display Mode

Topic Options

Author

Message

waynejps1

Posted Tuesday, June 23, 2009 2:03 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, May 11, 2013 4:50 PM
Points: 2, Visits: 38

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

Lynn Pettis

Posted Tuesday, June 23, 2009 2:43 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 11:23 AM
Points: 21,600, Visits: 27,422

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.

Cool

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 »

Permissions