Home > Management Studio, SQL Configuration, SQLServer, SQLServer 2005, SQLServer 2008, SQLServer 2008 R2, SQLServer 2012 > SQL Server – How to connect to SQL Server when ‘sa’ account is disabled
  1. Manuel Acosta
    July 14, 2013 at 11:37 pm

    Thank you very much. This comes in as a very handy solution. One of my customers will also greatly appreciate it.

  2. July 16, 2013 at 3:11 am

    I was wondering for several months how to login to an old SQL Server 2005, installed before I start to work here. Noone had the ‘sa’ password, and no Windows Authentication enable it. Thanks a lot for the article. A simple adjust though, cause ALTER SERVER ROLE, is a brand new command in SQL Server 2012, however the documented procedure ‘sp_addsrvrolemember’ completed the task perfectly in SQL Server 2005.

    • July 16, 2013 at 3:26 am

      I was wondering for several months how to login to an old SQL Server 2005, installed before I start to work here. Noone had the ‘sa’ password, and no additional Windows Login configured. Thanks a lot for the article. A simple adjust though, cause ALTER SERVER ROLE, is a brand new command in SQL Server 2012, however the documented procedure ‘sp_addsrvrolemember’ completed the task perfectly in SQL Server 2005

  3. Joe
    May 6, 2014 at 8:33 pm

    Great article! You can also enable the sa account by logging into Windows Authentication mode or using this software – SQL Server Password Changer.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 263 other followers

%d bloggers like this: