Hello,
We have cloned our production environment for a V11 test environment. When I tried to install the SSRS reports with TIM I get the following error:
BUILD FAILED - 0 non-fatal error(s), 2 warning(s)
C:\Users\adminjeb\AppData\Local\TessituraTemp\TessituraReportsInstaller\Installer.build(23,3):External Program Failed: C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\RS.exe (return code was 1)
TN recommended that I uninstall and reinstall reporting services in SQL2008 R2 which I did. I reinstalled but received the same error. When I try to resolve the url I get the following error:
The report server installation is not initialized. (rsReportServerNotActivated)
Woo boy – I did a bunch of stuff with the namespace and things like that (which is where my upgrade/uninstall issues showed themselves) but I don’t think any of that made a difference for me. It was really just finding the right path to the RS.exe and once I did that it worked. I wish I had kept a list of all the fiddles and tweaks I tried, but I was pretty much ending at the ‘hope and a prayer’ method of troubleshooting by the end. *grin*
I do remember this blog post started me down some of the namespace stuff, but that might be a rabbit hole for you.
http://petethevan.blogspot.com/2010/10/sql-server-2008-reporting-services.html
From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of John BrandtSent: Wednesday, March 21, 2012 4:01 PMTo: Heather Laidlaw KraftSubject: RE: [Tessitura Next Generation Forum] V11 Reporting Services error
Yup same issue here. I created a test ReportServer db and called it ReportServer_a and created the standard url. Worked like a charm. We essentially did the same thing. UP from 2005 to 2008. I uninstalled the RS 2008 and reinstalled to no avail. Any other ideas?
From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Heather KraftSent: Wednesday, March 21, 2012 4:56 PMTo: Joe GiambalvoSubject: RE: [Tessitura Next Generation Forum] V11 Reporting Services error
My path has to be set to:
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\RS.exe
In my case it is a problem with my box being upgraded from an old 2005 RS installation and it not completely uninstalling that old install (a known MS issue apparently).
Heather Laidlaw Kraft | 206-443-2202 x1044SEATTLE REPERTORY THEATRE
Seattle Rep is closed on MondaysPlease consider the environment before printing this e-mail
From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of John BrandtSent: Wednesday, March 21, 2012 3:46 PMTo: Heather Laidlaw KraftSubject: RE: [Tessitura Next Generation Forum] V11 Reporting Services error
Thanks I did open a ticket and we tried that. Where was your static path located? I created a test db of reportserver and it works ok.
From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Heather KraftSent: Wednesday, March 21, 2012 4:36 PMTo: John BrandtSubject: RE: [Tessitura Next Generation Forum] V11 Reporting Services error
Ohh.. I might have hit this error. I’d open a ticket with support, but if it is like mine it was basically looking for the RS.exe in the wrong place. I had to go into the text of TIM and change the path of the RS.exe from a dynamic one to the static one that was on my server.
Again, I’d open a ticket – because your scenario might not be mine at all!
Heather
From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of John BrandtSent: Wednesday, March 21, 2012 3:06 PMTo: Heather Laidlaw KraftSubject: Re: [Tessitura Next Generation Forum] V11 Reporting Services error
Sorry hit enter without finishing.
Microsoft suggests modifying the registry which I did and still no resolution. Has anyone encountered this error? Is it related to encryption keys? Is it related to cloning a virtual production machine and using it for test?
From: John Brandt <bounce-johnbrandt4183@tessituranetwork.com>Sent: 3/21/2012 4:58:50 PM
You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!