Solved

Cannot Install SQL Server 2005 on Windows Server 2008

Posted on 2010-08-17
4
1,211 Views
Last Modified: 2013-11-14
I am trying to install MS SQL Server 2005 on Windows Server 2008 x64 SP2, and the installer fails at the beginning of the install (Microsoft SQL Native Client) with the message :-

MSI (s) (BC:08) [11:46:41:405]: Product: Microsoft SQL Server Native Client -- Error 1719. The Windows Installer Service could not be accessed. This can occur if you are running Windows in safe mode, or if the Windows Installer is not correctly installed. Contact your support personnel for assistance.

I can confirm that the the server is not in safe mode, and that the Windows Installer service is on Manual and started. I have attempted to unregister/reregister windows installer using the recommended procedure:-
%windir%\system32\msiexec.exe /unregister
%windir%\system32\msiexec.exe /regserver
%windir%\syswow64\msiexec.exe /unregister
%windir%\syswow64\msiexec.exe /regserver
and rebooted the server. No change.

Another kb article suggested renaming the msi.dll's and reinstalling Windows Installer. I have remotely logged onto the server using the Administrator account in RDP (the server is at a remote site) and note that the required files in Windows\System32 have only Read & Execute and Read permissions, and the Oo/s won't allow me to modify the permissions so I can rename them.  Since I am new to Windows Server 2008 security, I don't know how to change the policy settings to allow this.

If anyone can help with any of these items, I would be very grateful.
0
Comment
Question by:cwruck
  • 2
4 Comments
 
LVL 40

Assisted Solution

by:Vadim Rapp
Vadim Rapp earned 100 total points
ID: 33460377
check the ideas in this thread:
http:Q_26395673.html
0
 

Author Comment

by:cwruck
ID: 33460611
I tried all those suggestions already - none helped.
0
 
LVL 14

Assisted Solution

by:Dhanasekaran Sengodan
Dhanasekaran Sengodan earned 100 total points
ID: 33462771
0
 

Accepted Solution

by:
cwruck earned 0 total points
ID: 33470311
Thanks to those who responded.  We managed to fix the problem as follows:-

The version of Windows Installer 4.5 installed with Windows Server 2008 SP2 was damaged.  We were able to rename the files:-
%windir%\system32\msi.dll, msi_dll.old
%windir%\system32\msiexec.exe, msiexec_exe.old
%windir%\system32\msihnd.dll,msihnd_dll.old
%windir%\syswow64\msi.dll,msi_dll.old
%windir%\syswow64\msiexec.exe,msiexec_exe.old
%windir%\syswow64\msihnd.dll,msihnd_dll.old

after turning UAC off, taking ownership of the files as Administrator, and setting write access to the files We then requested, download and installed the hot fix from Microsoft at http://support.microsoft.com/kb/981929. This installed a later, patched and working version of Windows Installer 4.5.  We were then able to install SQL Server 2005 successfully.

I hope this solution helps someone else.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question