brownie
|
Yes, this error can be resolved with the help of SQL Database recovery and for that you will have to follow these steps:
• At the command prompt you are required to run the following command in order to start the SQL server and also to bypass the upgrade scripts:
net start mssqlserver /f /T3608
• Then you will have to change the account that you have renamed back to the SA account and connect to the SQL Server with the help of dedicated administration connection (DAC). For that you will have to run the following query in the SQL CMD command utility:
sqlcmd -E -A -Q"alter login <sys-admin> with name = sa"
• Then you will have to run the following command to exit SQL Server:
net stop mssqlserver
• Then repair the SQL server 2008 installation
• In order to complete the upgrade process, start the SQL Server and after the upgrade process has completed, you can rename the sa account again.
In this way the error can be resolved with the help of SQL Database recovery.
 Posted 831 days ago
|