SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Silent Install Of 2 SSRS Instances With Same Service Account


Silent Install Of 2 SSRS Instances With Same Service Account

Author
Message
dave_matthews6
dave_matthews6
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 40
Hello All

I am working on doing an automated silent install of SSRS and SQL Server. The silent install is meant to be generic so it can be quickly deployed so I use built in Accounts. So for Report Server I used RSSVCACCOUNT="NT Service\ReportServer" and for AGTSVCACCOUNT="NT Service\SQLSERVERAGENT". I know its not best practice but the goal is to get it installed automatically.

In my testing I am using silent install using Config File. For the initial install it installs fine. When I try to do a second install(instance 2) it doesn't work. For the 2nd install the only thing I am changing is INSTANCE NAME and INSTANCE ID. I am seeing errors related to invalid accounts even though they are the same accounts that work for the first install. One error for example I see is:

"The credentials you provided for the Reporting Services service are invalid. To continue, provide a valid account and password for the Reporting Services Service"

My question is I guess can you use the same service accounts for multiple instances? Any other ideas why this would fail when you use the same config file but change only the instance details? Any help would be greatly appreciated.

Thanks in Advance
Tom Hamilton
Tom Hamilton
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3264 Visits: 781
I'd like to do the same thing, but have not had any luck either, I'll follow this thread along to see if anyone has an answer to this - good luck

Tom in Sacramento
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
dave_matthews6
dave_matthews6
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 40
The funny thing is If I do an install via SQL Install wizard I can add the 2nd instance no problem. The only thing I am changing is the instance name. I changed to instance name sql2 for silent and no luck but via wizard I use sql3 for instance name and it works fine. Seems it has something to with when the instance name is appended to the service account. I see the below in the logs for non working silent install. Im not sure why its asking for a password for 'NT Service\ReportServer'

(01) 2013-10-09 20:25:03 Slp: Sco: Attempting to format the virtual account name from service name 'ReportServer$SQL2'

(01) 2013-10-09 20:25:03 Slp: Sco: Attempting to validate credentials for user account 'NT Service\ReportServer' and service name 'ReportServer$SQL2'

(01) 2013-10-09 20:25:03 Slp: Sco: Attempting to determine if the account 'NT Service\ReportServer' is Virtual Account

(01) 2013-10-09 20:25:03 RS: The credentials you provided for the Reporting Services service are invalid. To continue, provide a valid account and password for the Reporting Services service.

(01) 2013-10-09 20:25:03 RS: Microsoft.SqlServer.Configuration.Sco.InvalidVAException: Virtual Account 'NT Service\ReportServer' provided for 'ReportServer$SQL2' is either not a valid account or cannot be used for this service.

at Microsoft.SqlServer.Configuration.RSExtension.SQLRSConfigurationPublic.IsValidServiceAccount(ServiceContainer context, String userName, SqlSecureString password)

(01) 2013-10-09 20:25:03 Slp: Validation for setting 'AGTSVCACCOUNT' failed. Error message: Virtual Account 'NT Service\SQLSERVERAGENT' provided for 'SQLAgent$SQL2' is either not a valid account or cannot be used for this service.

(01) 2013-10-09 20:25:03 Slp: Validation for setting 'SQLSVCACCOUNT' failed. Error message: The SQL Server service account login or password is not valid. Use SQL Server Configuration Manager to update the service account.

(01) 2013-10-09 20:25:03 Slp: Validation for setting 'RSSVCAccount' failed. Error message: The credentials you provided for the Reporting Services service are invalid. To continue, provide a valid account and password for the Reporting Services service.

(01) 2013-10-09 20:25:03 Slp: Error: Action "Microsoft.SqlServer.Configuration.SetupExtension.ValidateFeatureSettingsAction" threw an exception during execution.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search