Search

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

Active

1
Sign in to vote
0
Sign in to vote
Sign in
 to vote
Type: Bug
ID: 355293
Opened: 7/7/2008 5:07:23 PM
Access Restriction: Public
2
Workaround(s)
2
User(s) can reproduce this bug
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"
Details (expand)
Product Language
English

Version

SQL Server 2008 Release Candidate 0

Category

Setup

Operating System

Win2003 Enterprise Server (SP2)
Operating System Language
English
Steps to Reproduce
1. Run SQL 2008 setup from the command prompt with the following command line (passwords scrubbed):

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

Actual Results
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.
Expected Results
Success
Platform
32
File Attachments
1 attachments
LogSet_SA2K3SQL2KR02_20080707_162846.cab
Sign in to post a comment.
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
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 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
© 2010 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement