CODEWITHSUNDEEP
sql-server
tester lol
tester lol

Reputation: 43

cannot connect back to sql server authentication

I was using sql server authentication for my local pc database but then I set it to window authentication and restart the database . After that, I can't login the sql server authentication with the correct user and password . how to set it back to default ?

was using microsoft sql server 2012

Upvotes: 0

Views: 38

Answers (1)

user3777201
user3777201

Reputation:

You can change the registry key, here is a quick guide: http://www.sqldbadiaries.com/2010/08/15/change-authentication-mode-from-windows-registry/

Once changed, you'll need to restart the instance.

Upvotes: 1

Related Questions