Hi:
We recently cut over our live server to a new Windows 2008 R2 Server with SQL Server 2008 R2 also. Most everything went well, however, now when I try to connect to an SSRS report using Tessitura I am prompted to login. I can open the reports in internet explorer on the server and from our terminal servers without any issues. I checked our kerberos authentication (terminal servers) and the local intranet site in security and everything is OK. I know that it is something simple that I am missing, but I cannot think of what it is. This was all working prior to restoring the live db and renaming the server and changing the IP address. Also, the report server is connecting to the correct server in configuration.
FYI: I also learned that parameters are not necessarily updated when redeploying an SSRS report, you have to delete the report and redeploy for the change to appear. (my contribution to the network)
James
You could also try recycling the application pool.
+Ryan Creps
+Tessitura Network
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of James FairfieldSent: Wednesday, November 02, 2011 6:06 PMTo: Ryan CrepsSubject: Re: [Tessitura Technical Forum] SSRS prompting to login via tessi
Hi Jennifer:
We only have Post reports. I will see if we can reboot in the wee hours of the morning. That would be awesome if a reboot fixes it.
From: Jennifer McClure <bounce-jennifermcclure1840@tessituranetwork.com>Sent: 11/2/2011 4:26:36 PM
Does it only happen on POST reports or does it happen on POST reports and URL SSRS Reports? We've found that occasionally we have seen an issue pop up where it prompts for credentials only on the POST reports and a reboot of the server where IIS is running fixes it (haven't been able to figure out what breaks it though, unfortunately), but that's something to try if you find it seems to be just POST reports.
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
We've also had this problem and it's been driving me nuts. We aren't using Post reports, but instead URL reports. We haven't tried a server reboot yet as the reports are hosted on the SQL server.
Here at ACT we are using virtualized servers and local clients and have been getting this login prompt on reports. At Meany Hall, the Tessitura client is run as a remote client on a virtual server and we don't get the login prompt on reports. I don't know if that has anything to do with it.