Can''t install sp2 to Express?

Today, I attempted to install sp2 to my SQL 2005 Express instance and the install dialog would not allow me to check the box next to database services. At the bottom of the dialog it says this edition of SQL Server does not qualify for the update. It allowed other parts of the product to be updated, just not the engine.

This is on a Windows XP, SP2 box.

Shouldn't I be allowed to install the update for the database engine?

Thanks,

Del

Are you sure you've downloaded the SP meant for SQL Express? I got mine here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=31711d5d-725c-4afa-9d65-e4465cdff1e7&displaylang=en#Requirements
|||Thanks, Mark. In the past the sp's pretty much applied to all editions. In this case, I did not realize there was a separate download.

Del

Can't Install SP2

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

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

thanks

|||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|||

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.

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

Can't Install SP2

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

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

thanks

|||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
|||

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.

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