Web Platform Installer

Re: Continuous reboots while installing SQL Server Mgt Studio Express

PeterSad — Tue, 28 Jul 2009 04:28:04 GMT

This morning, we released an update to Web PI to address this issue.

Thanks,

Peter

Re: Continuous reboots while installing SQL Server Mgt Studio Express

Duffau — Mon, 20 Jul 2009 14:12:28 GMT

It is JULY 20, 2009 and I am getting the same reboot endless loop on WPI installation.

It is not fixed YET!!!

Re: Continuous reboots while installing SQL Server Mgt Studio Express

richma — Mon, 20 Jul 2009 14:07:43 GMT

@techman2000

Unfortunately this data really doesnt tell me enough technical details to give any ideas on how to resolve this. I would recommend contacting support for the AHLERS program since they should have the best idea on how to configure their program in various environments.

Re: Continuous reboots while installing SQL Server Mgt Studio Express

PeterSad — Mon, 20 Jul 2009 01:00:00 GMT

SQL Server 2005 only needs to be uninstalled if it installs an instance called "SQLExpress". If this is the case the Web Platform Installer should let you know that SQL Server 2005 is not compatible with SQL Server 2008.

Re: Continuous reboots while installing SQL Server Mgt Studio Express

msh001 — Mon, 20 Jul 2009 00:17:31 GMT

I read in another post here that SQl Server 2005 must be removed first, so I removed that and also deleted the Registry entry. This completed the installation. (would be nice if the installer checks things like that wouldm't it?)

Anyway, thanks so much to all who contributed to this thread....

Re: Continuous reboots while installing SQL Server Mgt Studio Express

techman2000 — Thu, 16 Jul 2009 20:59:19 GMT

AHLERS SOFTWARE Uses The SQL Server 2008 Express as its background db engine

SQL server 2008 Express and AHLERS is installed on win server 2008 standard

Trying to get users to be able to access the new ahlers sql version. I have opened relevant ports (per several articles ) on the local machine.

I have created shortcut that references the network path. I have ventured into Management Studio to give permissions to the user. I have ventured into Configuration Manager to ensure all services are running.

I feel like I have to do some kind of installation on the local machine that says connect to the SQL Service of the win server 2008, like a MSDE or something along those lines.

I know it is not as simple as connecting to the mapped drive because the application is installed completely on the server, so , the local machine would still need some files installed similar to the AHLER installation on the server and / or an installation that allows the local machine to connect to SQL service on the win 2008 server.

okay , i know I wrote a lot here , but I think you get the idea.

Please give me any guidance you can offer. Thanks !

Terrell

PS , sorry this is not the right forum. if you have a link where i can repost it , I will be happy to do so.

Re: Continuous reboots while installing SQL Server Mgt Studio Express

richma — Thu, 16 Jul 2009 16:33:20 GMT

Hi techman2000

I dont enough information about your application and possible this may be the incorrect forum for this since this is dedicated to the WebPi installations but I'll try.

If your trying to launch an Windows exe application from a mapped drive such as (v:\) then the issue may be due to the fact that mapped drives are per user. If using mapped drives with IIS see this article: http://support.microsoft.com/kb/257174

If none of this applies can you tell me what exactly is the type of applicaiton you are trying to execute . How you are trying to start it. Exactly what is the error.

thanks Richard

Re: Continuous reboots while installing SQL Server Mgt Studio Express

techman2000 — Thu, 16 Jul 2009 13:42:47 GMT

Hi Richma ! I need your advice. We have installed the software that would use the SQL server 2008 Express services in the background to help make things happen. I can make the program run from the server on which it is installed (no surprise there !) but I cannot launch the application from a mapped location on any given local user workstation. On this particular workstation , the error says access denied. My thinking is that perhaps there is a Win XP firewall setting on the local machine that needs to be addressed. If so , what are the necessary ports that should be open?

Thanks again for your help.

Re: Continuous reboots while installing SQL Server Mgt Studio Express

techman2000 — Wed, 15 Jul 2009 19:54:38 GMT

O K A Y ! !

INSTALLATION SUCCESSFUL ! MANY THANKS TO RICHMA ! !

Here is what we discovered. We followed your three step instructions (2 messages below), deleted the entire registry key . . .

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager Name: PendingFileRenameOperations Type:

REG_MULTI_SZ Data: \??\C:\<< PATH TO ANY FILE HERE>>

AND IMMEDIATELY installed SQL Server 2008 Express with Advanced Services without restarting the server and we did not close the registry window (closing and then reopening the registry window will cause the erroneous entry to be re-entered!)

SUCCESSFUL !

click here for a screen shot . . . https://docs.google.com/a/delawarehealth.org/Edit?docid=dcnbwn9r_29cz52ffcf

Re: Continuous reboots while installing SQL Server Mgt Studio Express

richma — Wed, 15 Jul 2009 19:12:59 GMT

Assuming you found an entry in the PendingFileRenameOperations key then this should be a path to a file. So then you want to first rename the file so that what ever program is trying to use this may not find this. This was something suggested by another customer so I cant say it applies always but its a good idea still.

Then using Regedit you can deny permissions to the Key by selecting EDIT > Permissions and Deny access to all users.

Here are the steps to BACKUP your regsitry if this something you are unfamiliar with.

http://technet.microsoft.com/en-us/library/cc771945.aspx

If you have not found that the PendingFileRenameOperations then this is when you would use ProcessMonitor. Its pretty straight forward and by default will log all regsitry access. When trying this you might want to try a reboot then start ProcesssMontitor and keep it logging while starting the SQL installation. When prompted to reboot then stop logging ( CTRL-E toggles the logging ) . Then use Edit Find to look for PendingFileRenameOperations .

Re: Continuous reboots while installing SQL Server Mgt Studio Express

techman2000 — Wed, 15 Jul 2009 18:44:43 GMT

Thanks RICHMA , you have been a big help. how do we perform number three ?

Re: Continuous reboots while installing SQL Server Mgt Studio Express

richma — Wed, 15 Jul 2009 16:00:13 GMT

Based on the log you posted the reason for your faillure is not a missing prerequisite but that a pending reboot is detected. The services mentioned are only the ones we have seen with this.

You need to follow the steps I posted to see what is in this registry key.

Re: Continuous reboots while installing SQL Server Mgt Studio Express

InformaticsGal — Wed, 15 Jul 2009 15:51:00 GMT

Thank you for your response. We are fresh and new to Windows Server 2008. Could we have missed enabling one of the services required to install SQL Server Express 2008 or any other installations?

We have tried to download and run SQL several times with pre-reqs installed. The only pre-req that does not install is MSI 4.5 as it states that it is not required for our system, as our version is 4.6.

I responsse to your resolution suggestion: We do not have Logitech ( Process Monitor Service) and HP (HP WMI Interface Service) under our server services. So what do we do next?

Any help is appreciated.

Re: Continuous reboots while installing SQL Server Mgt Studio Express

richma — Wed, 15 Jul 2009 15:31:49 GMT

This occurs because of an entry in this registry key which points to a pending file rename operation and indicates to the installer there is an installation in progress needing reboot.

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager Name: PendingFileRenameOperations Type:

REG_MULTI_SZ Data: \??\C:\<< PATH TO ANY FILE HERE>>

Possible Resolutions

1. Reboot the server and see if this key is removed. In normal circumstances this should be removed after reboot but we are seeing some services re add this everytime they start. The ones we have identified are Logitech ( Process Monitor Service) and HP (HP WMI Interface Service) . If these are present then either they need to be stopped or removed to avoid the behavior.

2. Backup the registry. Then Delete or Rename the PendingFileRenameOperations key and test the installation.

3. Rename the File listed in the key and Deny Access to the registry key so no new entries can be added..

Addtional Troubleshooting:

Process Monitor could be used to monitor registry access to identify what process is writing to this key http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

Re: Continuous reboots while installing SQL Server Mgt Studio Express

techman2000 — Wed, 15 Jul 2009 15:14:08 GMT

We have the same issue of continuous reboots while installing SQL Server Express 2008. We are having a problem loading MSI 4.5 which we were told is a pre-requisite for the SQL Server Express 2008.

Here is a screenshot of the installation failure. We have installed Powershell 1.0 and .Net Framework 3.5 SP1. It does not allow us to install the MSI 4.5 [error message = "updates do not apply to your system"]

We are trying to load the SQL Server Express 2008 on Windows Server 2008 standard SP2.

Please help us. Thanks.

Rule Name		Rule Description	Result	Message/Corrective Action
GlobalRules: SQL Server 2008 Setup configuration checks for rules group 'GlobalRules'
	RebootRequiredCheck	Checks if a pending computer restart is required. A pending restart can cause Setup to fail.	Failed	A computer restart is required. You must restart this computer before installing SQL Server.
	AclPermissionsFacet	Checks if the SQL Server registry keys are consistent.	Passed	SQL Server registry keys are consistent and can support SQL Server installation or upgrade.
	MediaPathLength	Checks whether the SQL Server installation media is too long.	Passed	The SQL Server installation media is not too long.
	OsVersionCheck	Checks whether the computer meets minimum operating system version requirements.	Passed	The operating system version meets the minimum requirements for this product.
	ThreadHasAdminPrivilegeCheck	Checks whether the account running SQL Server Setup has administrator rights on the computer.	Passed	The account running SQL Server Setup has administator rights on the computer.
	WmiServiceStateCheck	Checks whether the WMI service is started and running on the computer.	Passed	The Windows Management Instrumentation (WMI) service is running.

--
Thank You.