• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 86
  • Last Modified:

Logging in SQL Server as SA

Hi,

I have 'control server' permission in SQL Server 2012,
Currently I am trying to assign 'sa' a password in order to log in as 'sa' when there is a need.

 Using SQL Server Management Studio I click on security > log in  and right click sa > properties,
 select the general tab and set the password and confirm it after unchecking the 'enforce password policy' box.
I then click OK and everything seem to be in working fine (no error messages) but when I try to log in with the newly assigned password the log in fails.

Can you help? Thank you

Adam
0
adamtrask
Asked:
adamtrask
  • 2
1 Solution
 
Mike EghtebasDatabase and Application DeveloperCommented:
During the installation, regardless you have started with windows authentication or Mixed authentication, there is a need to identify a user with admin rights. If you have not installed this instance, then get this user name and its password to work with the database. Or ask the installer to grant you given the rights you need in this instance. SA account by default is disabled to force installer to choose an existing user for system admin role. SA could be enable but it really needs to remain disabled and not used at all (at least this is how it should be in 2012 and later).


Mike


This link may be of some use for you: https://sudeeptaganguly.wordpress.com/2010/04/20/how-to-enable-sa-account-in-sql-server/

post revised...
0
 
adamtraskAuthor Commented:
Thank you. That is what I needed.
0
 
adamtraskAuthor Commented:
Thank you very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

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