View Complete Post
We are getting the following error when trying to install SQL Server (2005 and 2008) software on a Windows Server 2008 R2 Enterprise machine:
"The Windows Installer Service could not be accessed. This can occur if you are running Windows in safe mode, or if the Windows Installer in not correctly installed. Contact you support personnel for assistance."
We had installed SQL Server 2005 previously, but are now trying to install other components from the SQL Server installation materials. We get the same error with the SQL Server 2005 and 2008 installers.
In our reasearch we've found references to corrupt or missing files and incorrect registry entries, and from the advice in those posts we have:
- Reregistered msi.dll
- Reregistered msiexec.exe
- Checked that the image path registry setting is correct
- Compared MD5 values for msi.dll and misexec.exe to those from a functioning server.
- imported registry settings from; Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\msisrver, from a properly functioning server
but have not been able to correct the issue.
which edition of sql server are best for me Developer edition or express editon for development purpose.
i try to install last time sql server in my system but not successful so what i do for get the sql server in my system.
Recently I had a weird problem while trying to install SQL Server Reporting Service in my local PC. I am using Windows Vista Home Premium and I wanted to configure SSRS in my PC. During the installation, the setup wizard listed all the services that we want to install and I found that only Reporting Server checkbox option was disabled and I wondered why??? I thought it may be becuase of some installation problem and tried again and its useless... I googled lot of sites for 3 days and finally found that due to some IIS issues, it is not possible to install Reporting Server in Vista Home Premium version. Reporting Server needs some specific IIS features to be installed in the machine.
But unfortunately those features are not available for Home Premium users which in term restricts users not to install reporting server in our PCs... Also, Microsoft has accepted it as an issue and its not possible to get it install in Home Premium...just wanted to share and might be useful for someone like me.