Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Need to setup sa account

Posted on 2009-04-14
4
Medium Priority
?
303 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 143

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 1500 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

972 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