Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server Authentication Mode

Status
Not open for further replies.

DebbieCoates

Programmer
Oct 2, 2007
23
GB
Can anyone help me I have seriously messed up my SQL Security on my local SQL server. i am trying to set it back but I cant. i tried Deleting my sql Server registration, then adding it again, but that didn't work.

what I did was change it to SQL and windows authentication, however, when I try to set it back to windows it wont let me.

What I want is to have my local sql server set to windown authentication, with one logon which is sa, but i am getting really confussed trying to achieve this, any help would be appreciated
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top