You may encounter the below error while performing SQL Server 2008 R2 Installation
At the end of installation you will see a report showing SQL Server database services failed etc., etc.,
workaround
1. Open SQL Server Configuration manager and try to change the service account name to any local admin account.
2. You can start the service though you could not login into SQL Server using the current credentials
3. Stop SQL Server from Configuration manager
4. Start SQL Server from command prompt using below command
net start MSSQLServer /c /m /T3608
5. Try login to server from SSMS and add your login as sysadmin, If not use the below command to login into SQL Server using DAC from command prompt
6. sqlcmd Admin:SQLServername\InstanceName
7. sp_addsrvrolemember 'domain\username', 'sysadmin'
8. stop and start sql server using configuration manager
9. It helps to login into SQL Server then you can add logins whatever are required.
At the end of installation you will see a report showing SQL Server database services failed etc., etc.,
workaround
1. Open SQL Server Configuration manager and try to change the service account name to any local admin account.
2. You can start the service though you could not login into SQL Server using the current credentials
3. Stop SQL Server from Configuration manager
4. Start SQL Server from command prompt using below command
net start MSSQLServer /c /m /T3608
5. Try login to server from SSMS and add your login as sysadmin, If not use the below command to login into SQL Server using DAC from command prompt
6. sqlcmd Admin:SQLServername\InstanceName
7. sp_addsrvrolemember 'domain\username', 'sysadmin'
8. stop and start sql server using configuration manager
9. It helps to login into SQL Server then you can add logins whatever are required.
The sql database recovery process is not an easy process. I have used so many tool to sql database recovery but sql database recovery tool is the best for me. There are so many features in this tool.
ReplyDelete