Trouble installing Reporting Services

[PTW]

We are installing Reporting Services onto 2 SQL Servers. On the first server, we installed using a Windows Domain account name that was granted System Admin rights in SQL for the install process, and then we took away those rights. This was how the account was set up in SQL:

domain_name\windows_account_name


The second server, however, is a cluster of two servers (one plus a failover) and so we have a virtual SQL Server setup called "VSQL". We have tried a variety of ways, but we cannot seem to get through the install process. I have tried:
VSQL\windows_account_name
domain_name\windows_account_name (this format works for a local windows account set up to handle services)
IP address\VSQL\window_account_name

Can anyone tell me what the proper Windows Domain account format in a virtual SQL environment should be when setting up Reporting Services? Thank-you.

 

[JayKusch]

You will need to set up RS as if you were setting up a web farm. Here is a link to look at:

http://msdn.microsoft.com/library/d...-us/rsinstall/htm/gs_ins_overview_v1_3rky.asp

Thanks

J. Kusch

 

[Catadmin]

And don't forget to make sure your cluster has all the appropriate components for setting up RS in all the correct spots. If your servers are clustered with local hard drives (I.E., you're not using external hard drives or a SAN set up), that means you'll have to install the required software on both machines.



Catadmin - MCDBA, MCSA
Beware the error of pre-emptive poultry inventory!