Category Archives: SQL server

Pending restart SQL server installation

SQL server, windows

If you  have tried to install SQL Server 2008  and cannot install, because of  the errormessage the prerequistite “Restart the computer is required”.

But every time you restart  computer and try to execute the setup of SQL Server 2008, you get the same message

Then you have change a registry entry in computer

  • Open Regedit
  • Find the key “HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession Manager”
  • Rename the “PendingFileRenameOperations” value to “PendingFileRenameOperations2”
  • Try again

This will solve the Restart Problem

Remove SQL Server Password

SQL server

Reset Forgotten Sa password

To configure startup options

  1. Login computer from administrator Account
  2. At  SQL Server Configuration Manager, click SQL Server Services.
  3. In the right side, right-click SQL Server (<instance_name>), and then click Properties.
  4. Startup Parameters boxtype the parameters separated by semicolons (;). at the Advanced tab, ,

    For example, to start in single-user mode, insert -m; in front of the existing startup options, and then restart the database.

    Important
    you must remove the -m; after  finished using single-user mode, from the Startup Parameters box before you can start a multiuser mode in production.
  5. Click OK.
  6. Restart the Database Engine.
  7. Change security authentication mode (You may not require this step if you have already enabled sa user)
    1. In SQL Server Management Studio Object Explorer, right-click the server, and  click Properties.
    2. On the Security page, under Server authentication, select the new server authentication mode, and click OK.
    3. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.
    4. You can change password here.
  8. Enable the sa login by using Management Studio(You may not require this step if you have already enabled dual authentication )
    1. In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties.
    2. On the General page, you might have to create and confirm a password for the sa login.
    3. On the Status page, in the Login section, click Enabled, and then click OK.
  9. Now you can logon with sa user and password .You can also set permission of the local user account from that.