Need to setup sa account

I am stuck there is no sa account. There is just the windows authentication.
How can I fix this?
mathieu_cuprykAsked:
Who is Participating?
 
dportasCommented:
It's called Secure by Default. Access to the database is disabled except where you specifically allow it.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you want to change from "windows authentication only" to "mixed authentication"...
check the sql server instance proprties for the configuration, and restart the instance.

the sa account shall always be there, but with "windows authentication only", you cannot use it.
note also that with sql 2005+, the sa account is LOCKED by default, so you might need to unlock it first
0
 
mathieu_cuprykAuthor Commented:
oh my, why so difficult?
0
 
mathieu_cuprykAuthor Commented:
Ok so I should search this one out and break my head into pieces.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.