What to do if I face errors while Installing SQL Server 2008 R2

Home » Troubleshooting » What to do if I face errors while Installing SQL Server 2008 R2
Troubleshooting No Comments

Starting from the release of AutoCount version 1.8, AutoCount started to use SQL Server 2008 R2 as the default Database Engine to be installed into server. Due to this we had found some unexpected issues that causes errors while installing SQL Server 2008 R2. So if anyone of you out there faced the similar, you may try the following in order to proceed with the installation of SQL Server 2008 R2 without problem.

 

1) In order to install SQL Server 2008 R2 Database Engine, the Windows Login name and Computer Name should not be the same. If both name are same, this will cause the installation of SQL to face errors in the middle of installation.

 

To check for Computer Name, simply just right click My Computer and select Properties

sql1

Windows 7 / Windows 8

sql2

Windows XP

 

To check for Windows User Login Name, open Control Panel –> User Accounts

sql3

Windows User Login Name

 

2) Go into Registry Editor and check the registry value of HKEY_USERS –> S-1-5-18 –> Software –> Microsoft –> Windows –> CurrentVersion –> Explorer –> User Shell Folders –> AppData, ensure the value is %USERPROFILE%\AppData\Roaming.

 

In order to open this Registry Editor, click on the Start button and search for RegEdit.

sql4

Registry editor

 

3) Restart your computer. This is because sometimes could be certain services or process is running and causes the installation unable to start. Restarting computer and install it again usually able to solve this issue.

*Before you restart your computer, please check if Microsoft SQL Server is not installed. To check you may go to Control Panel –> Program Features and check if it had already been installed. If installed already please uninstall first only restart.

 

4) Make sure there is no duplicate Instance Name. Installation by default using AutoCount CD will use Instance name of “A2006″. If you had installed SQL Server using this Instance Name before, you may uninstall the previous one or install using another Instance name in order to proceed.

 

To check if you had already installed particular instance name, you can go to your services and see if there is any SQL Service with that instance name.

sql5

Local Services

 

Above are just some of the common suggestion if faced errors during installation of SQL Server 2008. If these common suggested solution does not work in your case, you may look online for further help and solutions by keying in the exit / error code prompt by Microsoft SQL Server.