I am attempting to upgrade a SQL Server 2005 install on a Windows XP SP2 machineÃÂ and every time I run the SQL Server 2005 Service Pack 3 Setup, I get to the page for Authentication and click next.ÃÂ Then a dialog pops up that says Authentication Verification: Please wait while your authentication is verified.ÃÂ It hangs here for a few minutes and then eventually shuts down the machine.ÃÂ Has anyone experienced this before?ÃÂ I can run the SP2 ugrade on the machine just fine and it goes through the authentication step without issue.ÃÂ I tried uninstalling sql server and reinstalling it to make sure it wasn't something with the sql server install.ÃÂ I also tried to clean up space on the machine to ensure it wasn't a memory issue.ÃÂ Then i thought it was something with permissions so I had another person with admin rights try it on the machine and the same thing happened for them.ÃÂ What could the upgrade possibly be trying to check during authentication that would cause it to freeze up and hang?ÃÂ
I checked the HotFix.log that gets generated and the bottom lines are
Registry: Opened registry key "System\CurrentControlSet\Control\Session Manager"
Registry: Cannot read registry key value "PendingFileRenameOperations", error 5
Authenticating user using Windows Authentication
SQL Service MSSQL$DB was previously running, ready for authentication<
View Complete Post