Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
Reporting Services Setup - SQL 2008 Cluster
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!!
Windows Server 2008
Microsoft SQL Server 2008
8/22/2022 - Mon
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
Log in or sign up to see answer
Become an EE member today
7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
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
"No resolution found" ? I read: "i gave up on this"
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!
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent