Home Dashboard Directory Help
Search

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


Status: 

Active


2
0
Sign in
to vote
Type: Bug
ID: 355293
Opened: 7/7/2008 5:07:23 PM
Access Restriction: Public
2
Workaround(s)
view
2
User(s) can reproduce this bug

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"
Details
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
Sign in to post a workaround.
Posted by Ed Vassie on 9/22/2008 at 5:31 AM
Supply the SQL Agent password as /AGTSVCPASSWORD=passwordvalue, not as /AGTSVCPASSWORD="passwordvalue"
Posted by Sami.Marzouki on 8/19/2008 at 2:30 AM
In my case, I was running the installation under the local administrator account,
and when typing the domain account and password for the SQL Server Agent Service, I had
the same error. I re-ran the setup under a Domain Administrator account and had no more
this error. I hope this would help you.

Sam
File Name Submitted By Submitted On File Size  
LogSet_SA2K3SQL2KR02_20080707_162846.cab (restricted) 7/7/2008 -