Solved

Cannot Install SQL Server 2005 on Windows Server 2008

Posted on 2010-08-17
4
1,214 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

I was supporting a handful of Windows 2008 (non-R2) 2 node clusters with shared quorum disks. Some had SQL 2008 installed and some were just a vendor application that we supported. For the purposes of this article it doesn’t really matter which so w…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
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…

856 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