Side by install SSRS 2005

Question

Side by install SSRS 2005

Balance

SSCrazy

Points: 2636
More actions
April 4, 2011 at 5:09 am

#234164

I have an existing developer 2005 install on my machine and have subsequently installed 2008 developer edition - everything has been going fine until I've tried to run both reporting services at the same time - the 2008 version works fine but 2005 no longer has a site it seems and when I try to access it via management studio I get the message
Unalbe to connect to the remote server - no connection could be made because the target machine actively refused it.
So - can the two versions of reporting services work side and side and if so can you please give me some pointers to making it work as I've drawn a blank!
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Cody Konior SSCarpal Tunnel Points: 4827 More actions · Answer 1

I'm almost certain they can co-exist. But if you used the defaults they'd likely both be trying to use the same port number which likely isn't going to work.

Try changing the port of 2008 using the RS Config Manager, to something like 81, then restart both that and IIS, and access 2008 through http://localhost:81/ReportServer. They should both start working ...

David O Hall of Fame Points: 3228 More actions · Answer 2

I was having the same struggle and situation. This blog entry helped get me past the security hump:

http://mystuffisallhere.com/blog/post/2010/01/26/SQL-Server-Reporting-Services-2005-and-2008-e28093-cancelling-a-long-running-report-causes-the-next-e2809cView-reporte2809d-to-hang-the-UI-until-the-original-finishes.aspx

Additionally, I couldn't get my Sql 2008 SSSR instance running until I changed the service account to Network Service. My service account is running my Sql 2005 SSRS instance just fine. I'm going to post this situation over on the ask.sqlservercentral.com

Hope this helps

David

Balance SSCrazy Points: 2636 More actions · Answer 3

Thanks guys, this is what cracked it for me (first green answer) : http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/300add38-39e5-4053-83d8-67831b499143/

I suspect someone has altered our security settings thus breaking my IIS config.

I still don't know if the ports needed changing to distinguish between 2005 & 2008 - I suspect not because the names are different but to be honest I don't really care at this point, it now works and I'm a happy bunny.