Your .NET and Microsoft technologies specialist in Western Switzerland RSS 2.0
# Tuesday, June 12, 2007

I am just posting something that may be interested to someone else struggling with the install of Reporting Services on multiple servers.

Imagine the following scenario : You install your database server, then you install a first instance of Reporting Services on the second server, and then, finally, you install a second instance of Reporting Services on yet another server.

If you do it like this, you are on the wrong way. There are lot of chances that you receive, when you will access the http://servername/rsreportmanager site, a RSReportServerNotActivated error on one of the two server. The problem is that report servers are paired with the database server in order to avoid, for example, other report servers accessing the same database and getting data they should not see.

For this purpose, a symmetrical key must be exchanged between the database and all the report servers in the farm. But, if you read the documentation, you will see that the only thing you have to do is to activate the report server. So, let's do it using the rsactivate command. But, bad luck, you receive an error saying the "Local NT Service account is not enabled". What you want to do then ? Looking for the activation of such account ? Changing the account with which the report server service is running ? Not at all. Rather than following the error message, delete the key and the association for this server by using the rskeymgmt -d command. Then, you have to configure the server using the rsconfig command and finally the rsactivate one.

Finally ?

Hum, well, not sure :-) Now, try to access the local report server website. It will work. Great ! But, try to access the report server website for one of the other server. You will certainly receive a "Bad data" error. If you have some experiences with .NET, "Bad Data" should give you a bit of information, leading you to some cryptographic error...Right ?

The final word of this story is the following : When you want to activate servers in a farm, first activate the local one, then activate the others remotely. As said in this documentation, you must execute the rsactivate command from the same server.

This took me a bit of time to understand this, but at the end it is pretty meaningfull why you have to do it this way and I hope I saved time to others

Currently Reading :
I will be at :
I was a speaker at :
United Nations (UN) SharePoint Event 2011
I was a speaker at :
I was there !
I was there !
I was there !
I was there !
Archive
<February 2012>
SunMonTueWedThuFriSat
2930311234
567891011
12131415161718
19202122232425
26272829123
45678910
Listed On :
Blogroll
[Feed] Weblogger.ch
[Feed] David Chappell :: Weblog
[Feed] RockyH - Security First!
[Feed] The Project Management Podcast™
[Feed] Lunch over IP
[Feed] Intellectual Hedonism
[Feed] Upgrade to Biztalk 2006
[Feed] BizTalk Server Team Blog
[Feed] Eric Cote
[Feed] Mario Cardinal
[Feed] BizTalk Server Performance
[Feed] Julia Lerman Blog - Don't Be Iffy...
[Feed] Dotnet Fox
[Feed] Joel on Software
[Feed] Kevin Lam's WebLog
[Feed] BizTalk 101 - Back to Basics
[Feed] Peter Himschoot's blog
[Feed] Guy Barrette
[Feed] Mark Harrison
[Feed] Chanian, Raj
[Feed] A BizTalk Enthusiast
[Feed] Kevin B Smith's WebLog
[Feed] JABLOG
[Feed] BizTalk Core Engine's WebLog
[Feed] Robert Rijsdijk's BizTalk Server Weblogs
[Feed] Bryant Likes's Blog
[Feed] {CaptainK} - a.k.a Suresh Kumar
[Feed] CaPo's .NET and Enterprise Servers adventures - by Carlo Poli
[Feed] Charles Young
[Feed] Christoph .NET
[Feed] ComputerZen.com - Scott Hanselman's Weblog
[Feed] Console.WriteLine("Hello World");
[Feed] Darrell Norton's Blog
[Feed] Darren Jefford
[Feed] Dot Net Dunk
[Feed] Gilles' WebLog
[Feed] Jan Tielens' Bloggings
[Feed] Lamont Harrington's Blog
[Feed] Lamont Harrington's Blog
[Feed] Luke Hutteman's Weblog
[Feed] Matt Meleski's .Net Blog - The ABC's of .NET
[Feed] Michael Platt's WebLog
[Feed] Mike Holdorf's Blog
[Feed] Mike Taulty's Weblog
[Feed] Neopoleon.com
[Feed] Owen Allen
[Feed] Scott Woodgate's E-Business Outbursts
[Feed] Stephen W. Thomas
[Feed] The Arch Hacker's BizTalk Blog
[Feed] The BizTalk Visionary - BizTalk 2004, SOA and on
[Feed] Trace of Thought (Scott Colestock)
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2012
Yves Peneveyre
Sign In
Statistics
Total Posts: 241
This Year: 0
This Month: 0
This Week: 0
Comments: 17
Themes
Pick a theme:
All Content © 2012, Yves Peneveyre
DasBlog theme 'Business' created by Christoph De Baene (delarou)