MSSQL Server 2008 – Reset sa password

In this week, we were implementing PoC environment for voice analytics solution and received VMware image from vendor. After hosting image in our environment, which obviously required server name, IP address and domain changes, they were unable to login into SQL Server 2008 database.

We need to do ‘sa’ password reset and followed steps below for the same. Hope this helps.

  • From windows services, stop SQLServer(MSSQLServer) service
SQLServer Services

SQLServer Services

  • Open SQL Server Configuration Manager ( Start -> All Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> SQL Server Configuration Manager)
  • Select SQL Server Services -> SQL Server(MSSQLServer). Right click and select ‘Properties’
  • Go to ‘Advanced’ tab and change startup parameters by prefixing -m; as below

Prefix -m;

  • Click ‘Ok’ to save the changes
  • Start ‘SQLServer(MSSQLServer)’ from windows services
  • Open command prompt (Start -> Run -> cmd and press ‘Enter’)
  • Type ‘sqlcmd’ to start SQL command window and create new user as below

Create Login

sqlcmd


  •  Stop SQLServer(MSSQLService) from windows services
  • Remove ‘-m’ from startup parameters, click ‘Ok’ to apply the changes and start SQLServer(MSSQLService) service

SQLServer_default

  • Open ‘SQL Server Management Studio’ and login using newly created account (username : lucky, password=’BeHappy#3′)
  • Right-click login account ‘sa’ from ‘Security -> Login’ and select ‘Properties’
sa_properties

‘sa’ login properties

  • Change the password
sa_password

Reset ‘sa’ password

(Visited 22 times, 1 visits today)

Tagged: ,

1 comment

  1. Harold January 3, 2015 at 1:44 pm Reply

    Great article and very helpful..
    I also faced problem of forgetting sa password…I solved by using the SQL Server Password Changer utility.

Leave a Reply

Your email address will not be published. Required fields are marked *

MSSQL Server 2008 – Reset sa password

In this week, we were implementing PoC environment for voice analytics solution and received VMware image from vendor. After hosting image in our environment, which obviously required server name, IP address and domain changes, they were unable to login into SQL Server 2008 database.

We need to do ‘sa’ password reset and followed steps below for the same. Hope this helps.

  • From windows services, stop SQLServer(MSSQLServer) service
SQLServer Services

SQLServer Services

  • Open SQL Server Configuration Manager ( Start -> All Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> SQL Server Configuration Manager)
  • Select SQL Server Services -> SQL Server(MSSQLServer). Right click and select ‘Properties’
  • Go to ‘Advanced’ tab and change startup parameters by prefixing -m; as below

Prefix -m;

  • Click ‘Ok’ to save the changes
  • Start ‘SQLServer(MSSQLServer)’ from windows services
  • Open command prompt (Start -> Run -> cmd and press ‘Enter’)
  • Type ‘sqlcmd’ to start SQL command window and create new user as below

Create Login

sqlcmd


  •  Stop SQLServer(MSSQLService) from windows services
  • Remove ‘-m’ from startup parameters, click ‘Ok’ to apply the changes and start SQLServer(MSSQLService) service

SQLServer_default

  • Open ‘SQL Server Management Studio’ and login using newly created account (username : lucky, password=’BeHappy#3′)
  • Right-click login account ‘sa’ from ‘Security -> Login’ and select ‘Properties’
sa_properties

‘sa’ login properties

  • Change the password
sa_password

Reset ‘sa’ password

(Visited 1 times, 1 visits today)

Tagged: ,

1 comment

  1. Harold January 3, 2015 at 1:44 pm Reply

    Great article and very helpful..
    I also faced problem of forgetting sa password…I solved by using the SQL Server Password Changer utility.

Leave a Reply

Your email address will not be published. Required fields are marked *