Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

setup scale out reporting service 1

Status
Not open for further replies.

maswien

Technical User
Sep 24, 2003
1,286
CA
Hi,

We want install 2 reporting service on a 2 node sql clustering. I read some articles and awared of the scale out need use Enterprise Edition of SQL Server. the problem is we already have the standard edition of sql clustering setup, can we install the SSRS using enterprise edition? Is it working fine with standard edition of report database?


 
If you want to scale out the SSRS installation you will need to install the SSRS service under Enterprise edition. This will also require that you purchase Enterprise licenses for both nodes as both nodes will now be active.

You should be able to install SSRS Enterprise edition and leave the SQL Server as standard edition.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog
 

Long time no see :)

thanks a lot denny!
 


We configure the clustering as following:

IIS group

IP address: vitual IP fot IIS Service to failover
IIS network name resource
IIS script resource

since SSRS is not cluster aware we install 2 standalone reporting service on 2 nodes, connect to the same database, the user view report through browser using the URL containing the network name of the IIS group.

When the user view the report, they are always prompted with login window, is there any way to supress it?


 
Yeah, it's been a while. I was silent for a while, the whole work thing. Pesky day job.

It'd setup IIS with load balancing not MSCS. That way you can farm the work between the two machines.

Make sure that anonymous access is enabled on both machines (or if using integrated, etc just make sure that they match).

I set my IIS for my SSRS servers to anonymous access as we control the access via the application and the SSRS servers aren't exposed to the Internet.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog
 
Thanks a lot denny!

I turned on the anonymous access and specified a windows account being used by the anonymous user, grant this account the access to all the databases that can be used as datasource. It works!

You reminded me license issue, this sounds a Microsoft trick. If we use the scale out solution, means the SSRS is in active/active mode, we need buy 2 enterprise edition on the 2 server, it seems very expensive solution, is this true?






 
Yep, that would be correct, you would need two licenses.

You could probably get away with a single license if you tried connection to the IP for the SQL virtual world as that way you can only connect to one machine on another.

I'm not sure if this would be 100% legit, but you could probably explain it during an audit and get away with it.

In the new environment that I'm building I needed a redundant SSRS setup, so I had to purchase two Enterprise CPU licenses (1 CPU per SSRS server). Each SSRS server is a virtual machine.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top