mathieu_cupryk
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?
How can I fix this?
ASKER
oh my, why so difficult?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok so I should search this one out and break my head into pieces.
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