Link to home
Start Free TrialLog in
Avatar of mschneikert
mschneikertFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Reporting Services Setup - SQL 2008 Cluster

Dear Experts

We've had SQL 2008 running on two nodes with shared storage for the past few years. It's worked very well by failing over to the other node when we need to fix things on each server.

However we now need to setup SQL reporting services for the SQL Instance, as a new web application is dependant on it.

We appear to have the reporting services available as we can navigate to programs > Microsoft SQL Server 2008 R2 > Configuration Tools > Reporting Services Configuration Manager.

I've tried entering in the clustername in the Server name field but it finds nothing. I'm hoping this is a simple oversight and maybe someone can show me the light!!

Avatar of x-men
Flag of Portugal image

on the SQL server run the query: SELECT @@servername

the result is what you should place on the SSRS config. make sure the user has sufficient rights
Avatar of mschneikert
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"No resolution found" ? I read: "i gave up on this"
Avatar of mschneikert


No resolution found