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!!

Cheers
Windows Server 2008Microsoft SQL Server 2008

Avatar of undefined
Last Comment
mschneikert

8/22/2022 - Mon
x-men

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
ASKER CERTIFIED SOLUTION
mschneikert

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
x-men

"No resolution found" ? I read: "i gave up on this"
ASKER
mschneikert

No resolution found
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy