Updated November 2024: Stop getting error messages and slow down your system with our optimization tool. Get it now at this link
- Download and install the repair tool here.
- Let it scan your computer.
- The tool will then repair your computer.
This week we will discuss one of the most common error messages we receive when installing SQL Server 2008 R2 on Windows systems. This is the fourth article in the SQL troubleshooting series we started four weeks ago. Over the past few weeks, we have discussed several error messages when installing SQL. This week, we discuss the most common mistakes:
The installer has encountered an unexpected error. The error code is 2203. database : C:WindowsInstaller29cf05.ipi. The database file cannot be opened. System error -2147287035
and
Error when writing to C:WindowsInstaller29cf32.msi file. Make sure you have access to this directory. Click’Repeat’ to repeat the failed action or click’Cancel’ to continue.
In the previous articles, we discussed the permissions needed for SQL Server to work properly. Let me mention again that with SQL installations, it is better to always install it under the local administrator account, instead of installing it under the domain administrator, because even if you are the domain administrator, you may still have some security restrictions. For a clear understanding, it is best to refer to this TechNet article.
The installer has encountered an unexpected fault 2203
November 2024 Update:
You can now prevent PC problems by using this tool, such as protecting you against file loss and malware. Additionally, it is a great way to optimize your computer for maximum performance. The program fixes common errors that might occur on Windows systems with ease - no need for hours of troubleshooting when you have the perfect solution at your fingertips:
- Step 1 : Download PC Repair & Optimizer Tool (Windows 10, 8, 7, XP, Vista – Microsoft Gold Certified).
- Step 2 : Click “Start Scan” to find Windows registry issues that could be causing PC problems.
- Step 3 : Click “Repair All” to fix all issues.
The first method is performed first. Before changing the installer permissions, it is a good idea to create a system restore point just to be sure.
- Click Start and enter Create system restore point.
- It must open the system properties
- Click Create and enter a name for the system restore point.
Now that we have created a system restore point, we give permission to the installer folder.
- Go to Start -> Run -> Run – Install
- Right-click the folder Install and click Properties
- Click the tab Security
- Click Edit and then click Add.
- In the Enter object names field to select , type the word System and press Enter.
- Now select System from the list of user names and select Full control under Allow column. Click Apply
- Now click Edit and then click Add.
- In the Inter object names to select and enter the user account Windows .
- Now select Windows User Account from the list of user names and select Full Control under Allow column. Click Apply & OK
Now try reinstalling SQL Server 2008 R2 and see if it works.
The other common reason I have seen is that security software like Norton, McAfee or Panda etc. sometimes cause problems when installing SQL 2008 R2 and display this error message. Therefore, it is best to completely disable any security software on your computer and try reinstalling SQL Server 2008 R2 to see if it works.
Sometimes it’s the wrong time, real-time antivirus scanning scans the file in Install at the same time as Setup tries to open the file and install it from it, you get this kind of error. At other times, after a while, it may repair itself by restarting the computer. Once you have done this, try installing SQL Server 2008 R2 again and see if it works.
These methods should help you correct this error. If you need help, please let us know in the comments section.
Expert Tip: This repair tool scans the repositories and replaces corrupt or missing files if none of these methods have worked. It works well in most cases where the problem is due to system corruption. This tool will also optimize your system to maximize performance. It can be downloaded by Clicking Here