<div>
on the SQL server run the query: SELECT @@servername<br />
<br />
the result is what you should place on the SSRS config. make sure the user has sufficient rights
</div>


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

<div>
&quot;No resolution found&quot; ? I read: &quot;i gave up on this&quot;
</div>


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

<div>
<div class="content wysiwyg-content">
Dear Experts<br />
<br />
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.<br />
<br />
However we now need to setup SQL reporting services for the SQL Instance, as a new web application is dependant on it. <br />
<br />
We appear to have the reporting services available as we can navigate to programs &gt;&nbsp;Microsoft SQL Server 2008 R2 &gt;&nbsp;Configuration Tools &gt;&nbsp;Reporting Services Configuration Manager. <br />
<br />
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!!<br />
<br />
Cheers
</div>
</div>


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

Reporting Services Setup - SQL 2008 Cluster

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.