Solved

Cannot Install SQL Server 2005 on Windows Server 2008

Posted on 2010-08-17
4
1,221 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
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…

705 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