For those migrating soon, what’s your migration date?
We are T-minus 17 days – Sunday October 7
Gonna start working on my migration-day procedure sheet!!
Dave Vivino
Cleveland Orchestra
Did you restart your server once you applied the app_pool\tessitura_svcs?
From: Tessitura Next Generation Forum [mailto:forums-nextgeneration@tessituranetwork.com] On Behalf Of Chris Jensen Sent: Wednesday, December 12, 2012 1:29 PM To: John Brandt Subject: RE: [Tessitura Next Generation Forum] What's your Migration Date?
Beth Gilliland: The snapshot folder we are now using in v11/SSRS is setup this way: [...] 3) We shared that folder, giving specific read/write permissions to "IIS AppPool\[YourAppPoolName]" [...]
Beth Gilliland:
The snapshot folder we are now using in v11/SSRS is setup this way:
[...]
3) We shared that folder, giving specific read/write permissions to "IIS AppPool\[YourAppPoolName]"
We already had an EmailReports folder on our Services server, since I think I had worked with support on almost this very idea, i.e. EMAIL REPORT PATH on the services server, but without the crucial element above of the app pool permissions on the directory. I've just tried that here, and can report ... it worked!
I just ran a scheduled SSRS -> e-mailed PDF report, received the email with attachment, and the log contains the magic words:
2012-12-12 13:58:46138734InfoReport snapshot created successfully.
I can't declare complete victory until at least one scheduled job runs overnight, but things are looking very good indeed.
Beth, you are my hero!
From: Beth Gilliland <bounce-bethgilliland6030@tessituranetwork.com> Sent: 12/12/2012 12:11:41 PM
Actually, Chris, I believe SSRS_SNAPPATH is deprecated: http://www.tessituranetwork.com/Help_System/Content/System_Tables/Deprecated%20Defaults.htm
(In our case, I believe it is pointing to a non-existent folder - probably from v10.)
1) T_DEFAULTS >>> IMPRESARIO >>> EMAIL REPORT PATH >>> \\<YOUR_IISAPPSERVICES_SERVERNAME>\EmailReports
2) On the machine that is hosting IIS/v11 Application Services <YOUR_IISAPPSERVICES_SERVERNAME>, we created a folder (C:\ReportServer\EmailReports)
3) We shared that folder, giving specific read/write permissions to "IIS AppPool\Tessitura_Svcs"
IMPORTANT: I believe we had to type this in by hand, because we couldn't search to find the services app pool name
This page was key in helping us: http://www.bluevalleytech.com/techtalk/blog/assigning-ntfs-folder-permission-to-iis7-application-pools/
(We also shared this folder with our domain user account that runs some of the SQL services - in case that is also necessary - but I believe it was the app pool permissions that did the trick.)
This shared folder holds snapshots for both Infomaker and SSRS reports. You can also test this by changing a setting in T_DEFAULTS:
T_DEFAULTS >>> IMPRESARIO >>> EMAIL REPORT DELETE FILE >>> NO
Setting to no will allow you to see if/where the reports are getting created. (Set this back to Yes when done testing, though.)
It shouldn't require moving SSRS per se - just having a folder on the app services machine should be enough (**I think**)
See page 12 of the Report Server Setup doc - http://www.tessituranetwork.com/~/media/Documentation/Installation/Tessitura_Report_Server_Setup_and_Administration.ashx
It gets to the crux of the problem, but without a ton of details on how to actually carryout the setup.
(Also note that we use SMTP Server Relay for our email report setup in case that makes a difference - probably not. YMMV)
Beth
BETH GILLILAND UMS Tessitura System Administrator bethgill@umich.edu www.ums.org // www.umslobby.org
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!
Hi John -
Just restarted the report server application - not the server itself.
HTH,
Heather
Unknown said: Did you restart your server once you applied the app_pool\tessitura_svcs?
No, after the permissions change on the EMAIL REPORT PATH directory, I just restarted the Report Server app to make sure it re-read T_DEFAULTS, since I had changed the value of that field.