Can't Install SP2

Question

I'm trying to install SP2 (on XP SP2) and for some reason I'm getting an error on the authentication dialog.

The error is: "Your account information could not be verified. Press Ok to return to Authentication Mode screen to determine the reason for failure."  For setup to verify your credentials the services must be startable, connectable and you must be a SQL Server administrator."  In the dialog under status the value reads "Login Failed: ".

I've tried integrated security (I'm a local admin on this machine) and the sa account but no luck either way.  I've tried starting every service that starts with "SQL" and still no luck.

Thoughts or ideas?

Thanks,
Mike

Answer 1

Have you been able to solve this.  I'm running into the same problem.

 

thanks

Answer 2

Yes, I changed my reg key for the default location of Program Files and that was my issue.

The installer must not have been looking at the current location for SQL but assuming it was under ProgramFilesDir.

Mike

Answer 3

If you are using Backup Exec to back up your databases, you need to add permissions to any files with "$4dir" at the end that reside in your DATA folder.

You can then install SP2 normally.   This problem cropped up with SP1 as well and it took me days to figure this one out.

Answer 4

How did you can the reg key for the defauly location of program files?

Answer 5

The registry key is at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion, update the ProgramFilesDir value to C:\Program Files, then restart your machine.

Answer 6

Hi, i have the same problem, but i have a spanish operative system i went to the path of the registry and it saids "c:\Program Files"  I update this to spanish "c:\Archivos de programa", and also tried reparing the sql native client..('cause changing the key didn't work )  restar and still the error... may u please help me please  ?

Answer 7

where the executables are and what the registry key says?  .   explain in detail please

I have the same problem when I am installing SP3

Answer 8

SQL server Resource is in C\program file and master and log files are in D drive. due to above change installtion of service pack 3  failed