Cannot install SQL Server 2008 Express on Vista sp1 using MSI 2.0

Question

This happens whether or not I use Windows Authentication or Mixed Mode
This is from the error log:
  Exit code (Decimal):           -2068578304
  Exit facility code:            1204
  Exit error code:               0
  Exit message:                  The credentials you provided for the SQL Server Agent service are invalid.

Help.  I am on my fifth install attempt and uninstall.  Thanks.

Answer 1

Hello,

Please, supply the SQL Agent password as /AGTSVCPASSWORD=passwordvalue, not as /AGTSVCPASSWORD="passwordvalue".

I found this in the following link:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=355293&wa=wsignin1.0

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Hi Alberto,

Thanks for taking time to respond.

I am using the Web Platform Installer v2.0 which gives me two boxes to enter the password and confirmation.  Are you thinking of another way to install.  I though the WPI was supposed to be easy, but I cannot get by this error.

Doug

Answer 3

Hello,

The password you have to provide must be a strong password, otherwise you will get the error. A strong password  is one that has a combination of letters in uppercase, lowercase, numbers and special characters. Like p@ssw0rd.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 4

Hi Alberto,

I created an account called SA with a VERY strong password.  I tried to install 2008 Express using the SA password and the install failed again with the same error.  I am not sure what to do now.  Is there another way to install this software that you know of?  Am I missing something?

Thanks,

Doug

Answer 5

Hello,

I do not have much experience with Web Platform Installer, but please take a look at the following article I found on the Web:

http://learn.iis.net/page.aspx/604/troubleshooting-problems-with-web-platform-installer-20

Hope this help,

Alberto Morillo
SQLCoffee.com