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
Windows 7 / Windows 8
To check for Windows User Login Name, open Control Panel –> User Accounts
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.
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.
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.