Problems With SQL 2005 SP1 (x64)

Problems With SQL 2005 SP1 (x64)

• Rijckewaert

  Hi

  I had the same problem and found the solution in KB 918695

  "The problem occurs because the master database file is not in the same location as the Resource database file for the instance of SQL Server 2005 on which you install SQL Server 2005 SP1. You may have previously moved the master database from its originally installed location. When you move the master database, you must make sure that the master and Resource database files are located in the same folder. If you only move the master database files, you experience this problem when you install SQL Server 2005 SP1. This problem occurs because the location of the master and Resource database files is inconsistent."

  
  

• Swami

  Yes, and yes :)
  
  

• Andretti Fan

  We are having the same problem with Integration Services timing out after installing SP1, but we are running the 32-bit standard version.

  I had to uninstall SQL 2005. I'm installing it again now. Should be done in about 6 hours.

  
  

• Theodore C

  I haven't had a problem across a suite of x64 installs here at the bank. Disk space can be an issue as the SP install seems to require a lot. You can also run into problems if you have removed the security groups that SQL installs - there's another thread on this on this forum.
  

• Bryan Hinton

  This is the third forum message I've seen with this message, so hopefully we can solve it quickly.

  After you get the 'dm_exec_query_resource_semaphores' error and the installer cancels out, can you try to apply SP1 a second time Does that attempt also fail with the same message

  Thanks,
  Samuel Lester (MSFT)

  
  
  

• RONE162622

  Hello all...

  Just to add my experience; in the process of setting up several servers, I encountered the same, however on one system, it was a clean installation and on the other, SQL had been installed/removed and re-installed (to support .NET 3.0).

  Since I had the time and option and knew that the Master Database had not been moved, the corrective action is to:

  a) Click Cancel on the database update locked message (the process will continue) - this lock message will occur on both the Database and again on Analysis Services

  b) Let the entire process complete

  c) Do not reboot - open Administrative Tools > Services and perform a Restart on the Microsoft SQL Server service

  d) Rerun SP1

  Regards,

  David Sterling - Sterling International Consulting Group
  www.sterling-consulting.com

  
  
  

• AntiRules

  Just managed to pull this out of a log file:
  
  

• Mohamed Harris

  Thanks for the reply. The file permissions haven't been touched, and disk space certainly isnt an issue (doesn't even come close to filling any partition).
  
  I've dropped some more information into the bottom of this thread (guy seemed to be having the same problem as me)
  
  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=318632&SiteID=1
  
  
  

• pkellner

  Darren

  Can you upload the first setup log file that failed with this error

  Thanks

  Vishal

  
  
• Problems With SQL 2005 SP1 (x64)