SSRS 401 Unauthorized error

Hi Mike, check the following article, this may help. We had a similar situation in the past and following the steps in this artcle to resolve this issue helped:

http://msdn.microsoft.com/en-us/library/cc281253.aspx#proxyfirewallRSWindowsNegotiate

Mo

National ballet

Hi there,

We recently moved our live database to another instance of SQL server (same version). Everything seems to be fine however after moving the SSRS database across to the new SQL instance and changing Tessitura to use SSRS on that server we now get a 401 unauthorized error when we try to run any report from within the application.

I have tried creating a new SSRS DB and re-running TIM to install the SSRS reports again but we get the same error on any report.

Is this the double hop authentication problem? and am I going to have to re-install SSRS from scratch?

I really need to keep our current SSRS db and somehow migrate it to the new instance of SSRS as it contains some custom reports we need.

Any help would be greatly appreciated.

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!

Hi Mike, check the following article, this may help. We had a similar situation in the past and following the steps in this artcle to resolve this issue helped:

http://msdn.microsoft.com/en-us/library/cc281253.aspx#proxyfirewallRSWindowsNegotiate

Mo

National ballet

Hi there,

We recently moved our live database to another instance of SQL server (same version). Everything seems to be fine however after moving the SSRS database across to the new SQL instance and changing Tessitura to use SSRS on that server we now get a 401 unauthorized error when we try to run any report from within the application.

I have tried creating a new SSRS DB and re-running TIM to install the SSRS reports again but we get the same error on any report.

Is this the double hop authentication problem? and am I going to have to re-install SSRS from scratch?

I really need to keep our current SSRS db and somehow migrate it to the new instance of SSRS as it contains some custom reports we need.

Any help would be greatly appreciated.

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!