Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

Need to setup sa account

I am stuck there is no sa account. There is just the windows authentication.
How can I fix this?
0
mathieu_cupryk
Asked:
mathieu_cupryk
  • 2
1 Solution
 
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
 
dportasCommented:
It's called Secure by Default. Access to the database is disabled except where you specifically allow it.
0
 
mathieu_cuprykAuthor Commented:
Ok so I should search this one out and break my head into pieces.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now