« Previous Next »

• 07-01-2009, 6:28 PM

  In reply to

  Carmen_Ge Joined on 04-07-2009, 1:14 AM Posts 28	Re: Continuous reboots while installing SQL Server Mgt Studio Express Reply Contact Installers like SQL installer cannot tell apart a true pending reboot request coming from an installation from the Logitech and HP erroneous ones. Carmen -- SQL Server Management Studio

• 07-14-2009, 9:21 PM

  In reply to

  msh001 Joined on 07-15-2009, 1:17 AM Posts 2

  Re: Continuous reboots while installing SQL Server Mgt Studio Express Reply Contact I am getting the same issue.  It appears that SQL Server express can only be installed now with the Web Installer. I tried to use system restore to go back before this was done but it still does the same thing - reboot required.  At this point I do not care if SQL Server Express installs.  I just want to get the reboot required to stop happening. I saw one of the replies suggested to remove the registry entry.  I am going to try that.  (I tried and the Installer still starts at reboot.  With what I am guessing will be endless reboots required.)  I renamed the PendingFileRenameOperations to ...old.  Now it is back again.  How do I stop the installer from coming up at reboot??!!

• 07-14-2009, 11:11 PM

  In reply to

  PeterSad Joined on 07-09-2009, 9:40 PM Redmond, wa Posts 28

  Re: Continuous reboots while installing SQL Server Mgt Studio Express Reply Contact I would like to help out with this issue.  Can someone point me to a place where I can install "Logitech Process Monitor". Hopefully I can install without having the device. If we can get a repro in house then we have a better chance at addressing.     Peter Saddow [Microsoft] SQL Server Product Group Sr. Program Manager

• 07-15-2009, 11:14 AM

  In reply to

  techman2000 Joined on 07-14-2009, 7:07 PM Posts 10

  Re: Continuous reboots while installing SQL Server Mgt Studio Express Reply Contact 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.

  Tags: WPIWebPIerrorwpilauncherweb platform installersql server 2008 management studio expresssql Express 2008SQL Express 2008 installWPInsatllerWeb Platform Installer 2.0 RC

• 07-15-2009, 11:31 AM

  In reply to

  richma Joined on 04-06-2009, 12:10 PM Posts 354

  Re: Continuous reboots while installing SQL Server Mgt Studio Express Reply Contact 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

• 07-15-2009, 11:51 AM

  In reply to

  InformaticsGal Joined on 07-15-2009, 3:42 PM Posts 1

  Re: Continuous reboots while installing SQL Server Mgt Studio Express Reply Contact  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.

  Tags: WPIsql server 2008 management studio expresssql Express 2008SQL Express 2008 installWPInsatller

• 07-15-2009, 12:00 PM

  In reply to

  richma Joined on 04-06-2009, 12:10 PM Posts 354	Re: Continuous reboots while installing SQL Server Mgt Studio Express Reply Contact 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.

• 07-15-2009, 2:44 PM

  In reply to

  techman2000 Joined on 07-14-2009, 7:07 PM Posts 10	Re: Continuous reboots while installing SQL Server Mgt Studio Express Reply Contact Thanks  RICHMA ,  you  have  been  a  big  help.  how  do  we  perform   number  three  ?

• 07-15-2009, 3:12 PM

  In reply to

  richma Joined on 04-06-2009, 12:10 PM Posts 354

  Re: Continuous reboots while installing SQL Server Mgt Studio Express Reply Contact 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 .

• 07-15-2009, 3:54 PM

  In reply to

  techman2000 Joined on 07-14-2009, 7:07 PM Posts 10

  Re: Continuous reboots while installing SQL Server Mgt Studio Express Reply Contact  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

  Tags: WPIWebPIwpilaunchersql server 2008 management studio expresssql Express 2008SQL Express 2008 installWPInsatllerWeb Platform Installer 2.0 RC

• 07-16-2009, 9:42 AM

  In reply to

  techman2000 Joined on 07-14-2009, 7:07 PM Posts 10

  Re: Continuous reboots while installing SQL Server Mgt Studio Express Reply Contact  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.

• 07-16-2009, 12:33 PM

  In reply to

  richma Joined on 04-06-2009, 12:10 PM Posts 354

  Re: Continuous reboots while installing SQL Server Mgt Studio Express Reply Contact 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

• 07-16-2009, 4:59 PM

  In reply to

  techman2000 Joined on 07-14-2009, 7:07 PM Posts 10

  Re: Continuous reboots while installing SQL Server Mgt Studio Express Reply Contact  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.

  Tags: sql server 2008 management studio expresssql Express 2008testingApplicationsSQL Express 2008 installFrusteration

• 07-19-2009, 8:17 PM

  In reply to

  msh001 Joined on 07-15-2009, 1:17 AM Posts 2	Re: Continuous reboots while installing SQL Server Mgt Studio Express Reply Contact 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....

• 07-19-2009, 9:00 PM

  In reply to

  PeterSad Joined on 07-09-2009, 9:40 PM Redmond, wa Posts 28	Re: Continuous reboots while installing SQL Server Mgt Studio Express Reply Contact 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.   Peter Saddow [Microsoft] SQL Server Product Group Sr. Program Manager