Unattended install failing with "The credentials you provided for the SQL Server Agent service are invalid." - by shoeboy

Status : 

 


2
0
Sign in
to vote
ID 355293 Comments
Status Active Workarounds
Type Bug Repros 2
Opened 7/7/2008 5:07:23 PM
Access Restriction Public

Description

Attempting to install RC0 on a win2k3 sp2 machine, using a domain account and password for SQL Server, SQL Agent, AS and RS results in the following:

The following error occurred:
The credentials you provided for the
SQL Server Agent service are invalid.
To continue, provide a valid account
and password for the SQL Server Agent
service.
Error result: -2068578304
Result facility code: 1204
Result error code: 0
Please review the summary.txt log for
further details
---------------------------------------
-------------------------------
Error result: -2068578304
Result facility code: 1204
Result error code: 0
Microsoft (R) SQL Server 2008 Setup
10.00.1442.32
Copyright (c) Microsoft Corporation.
All rights reserved.

User name and password were typed correctly.  I was able to upgrade a sql 2005 instance running under the same credentials.

Install command was:

\\samsnengfsa10\msnplat\BRONZE\SQL2008SP0\SQLBITS\SQL\Enterprise\X86\setup.exe /INSTANCEID="TEST0" /QUIET /ERRORREPORTING="False" /SQMREPORTING="False" /INSTANCENAME="TEST0" /PID="MQWT2-9MKBY-K8PXQ-6K4BW-TY4BD" /INDICATEPROGRESS  /ACTION="Install" /FEATURES="SQLENGINE,REPLICATION,FULLTEXT,CONN,BC,SSMS,ADV_SSMS,OCS,AS,RS,IS,BOL,BIDS" /INSTALLSHAREDDIR="D:\MSSQL10" /INSTANCEDIR="D:\MSSQL10.TEST0" /AGTSVCACCOUNT="phx\_bcptstsvc" /AGTSVCPASSWORD="********" /AGTSVCSTARTUPTYPE="Automatic" /FILESTREAMLEVEL="3" /FILESTREAMSHARENAME="TEST0" /SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS" /SQLSVCACCOUNT="phx\_bcptstsvc" /SQLSVCPASSWORD="********" /SQLSYSADMINACCOUNTS="BuiltIn\Administrators" /SQLSVCSTARTUPTYPE="Automatic" /TCPENABLED="1" /NPENABLED="1" /SAPWD="***********" /SQLBACKUPDIR="H:\MSSQL10.TEST0\MSSQL\Bak" /SQLTEMPDBDIR="T:\MSSQL10.TEST0\MSSQL\Data" /SQLTEMPDBLOGDIR="T:\MSSQL10.TEST0\MSSQL\Data" /SQLUSERDBDIR="H:\MSSQL10.TEST0\MSSQL\Data" /SQLUSERDBLOGDIR="O:\MSSQL10.TEST0\MSSQL\Data" /BROWSERSVCSTARTUPTYPE="Automatic" /FTSVCACCOUNT="NT AUTHORITY\LOCAL SERVICE" /ISSVCSTARTUPTYPE="Automatic" /ISSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /ASSVCSTARTUPTYPE="Automatic" /ASSVCACCOUNT="phx\_bcptstsvc" /ASSVCPASSWORD="********" /ASCOLLATION="SQL_Latin1_General_CP1_CI_AS" /ASDATADIR="H:\MSAS10.TEST0\OLAP\Data" /ASLOGDIR="O:\MSAS10.TEST0\OLAP\Log" /ASBACKUPDIR="H:\MSAS10.TEST0\OLAP\Backup" /ASTEMPDIR="T:\MSAS10.TEST0\OLAP\Temp" /ASCONFIGDIR="H:\MSAS10.TEST0\OLAP\Config" /ASPROVIDERMSOLAP="1" /ASSYSADMINACCOUNTS="BuiltIn\Administrators" /RSSVCSTARTUPTYPE="Automatic" /RSSVCACCOUNT="phx\_bcptstsvc" /RSSVCPASSWORD="********" /RSINSTALLMODE="DefaultNativeMode"
Sign in to post a comment.
Posted by Ed Vassie on 9/22/2008 at 5:29 AM
The /AGTSVCPASSWORD parameter requires that the password is supplied without surrounding quotes. All the other /...PASSWORD parameters are happy to accept quotes around the password
Posted by XNMB on 8/8/2008 at 1:49 PM
Manual install of the x86 RTM gives me the same error. Couldn't get past the Service Accounts configuration. Help!
Posted by Microsoft on 7/8/2008 at 7:49 AM
Hi,

As we confirmed, the account used for this does not have logon interactive permission. This is an issue that is fixed after RC0. You need to use the escrow build for the fix for this issue. As such, I am closign this as a duplicate. Please reactivate if you think the escrow build does not resolve this issue.

Thanks,

Max Verun
SQL Server