Link to home
Start Free TrialLog in
Avatar of mathieu_cupryk
mathieu_cuprykFlag for Canada

asked on

Need to setup sa account

I am stuck there is no sa account. There is just the windows authentication.
How can I fix this?
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

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
Avatar of mathieu_cupryk

ASKER

oh my, why so difficult?
ASKER CERTIFIED SOLUTION
Avatar of dportas
dportas

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Ok so I should search this one out and break my head into pieces.