Solved

Need to setup sa account

Posted on 2009-04-14
4
294 Views
Last Modified: 2012-05-06
I am stuck there is no sa account. There is just the windows authentication.
How can I fix this?
0
Comment
Question by:mathieu_cupryk
  • 2
4 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24145273
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
 

Author Comment

by:mathieu_cupryk
ID: 24148229
oh my, why so difficult?
0
 
LVL 22

Accepted Solution

by:
dportas earned 500 total points
ID: 24148672
It's called Secure by Default. Access to the database is disabled except where you specifically allow it.
0
 

Author Comment

by:mathieu_cupryk
ID: 24151793
Ok so I should search this one out and break my head into pieces.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now