[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Cannot Install SQL Server 2005 on Windows Server 2008

Posted on 2010-08-17
4
Medium Priority
?
1,234 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 400 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 400 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

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Question has a verified solution.

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

With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
Create a Windows 10 custom Image with custom task bar and custom start menu using XML for deployment.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
Suggested Courses

830 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