0

I'm trying to enable 'sa' account in SQL Server 2008 through the MS SQL Server Management Studio Express. When I set the properties through the 'Properties' section of the login and click Ok, there are no error messages! But when I revisit the properties, password is rolled back to the previous one.

enter image description here

enter image description here

Ultimately can't access the account!

enter image description here

CRoshanLG
  • 145
  • 1
  • 11
  • sorry if you have checked this but does the user you are making the changes as have the sysadmin privilege? –  Dec 27 '12 at 12:07
  • @Time Alexander I run the MSSQLSMSE as administrator, and log to windows as administrator! – CRoshanLG Dec 27 '12 at 13:25
  • 1
    [Check your logs and see what the error state is](http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx) to get a better idea of the problem. And post it here if you want help. – HopelessN00b Dec 27 '12 at 13:43
  • Got the issue solved with this --> [link](http://sarangasl.blogspot.com/2011/06/sql-server-authentication-enabling.html) – CRoshanLG Dec 27 '12 at 14:25
  • not sure how that solved it when your screenshots show the account is enabled already? –  Dec 27 '12 at 14:29
  • @TimAlexander I'm not sure either as I'm no expert of SQL Server, but I can assure you it worked. I'm using this login now, with no issues at all! – CRoshanLG Dec 27 '12 at 15:22

1 Answers1

1

Got this issue solved by enabling "SQL Server and Windows Authentication mode" in the server properties.

enter image description here

Got help from this article.

CRoshanLG
  • 145
  • 1
  • 11