Hello:
Our organization uses 2X to connect to our Live and Test Servers through 2 terminal servers located at a datacenter on another domain (we manage it).
The problem I am having is connecting to our SSRS reports through Tessitura, and even via the terminal servers (RDP). When on the terminal servers I can connect using IE9 with the IP address (NTLM), but not with the server name (FQDN). I am prompted to login three times to view the reports, but nothing appears after the third time of logging in using the FQDN method. In addition, if I am on the test or live server, everything works as it should, but not on the other servers that are in the same domain and in the same rack.
Has anyone had this issue, and if so how did you solve it?
Additional information: two 2003 terminal servers, one 2003 live server and one 2008 test server. The test and live server names and IP addresses are listed in the trusted sites for both terminal servers.
Thanks in advance,
James
That’s more of an issue with your network layout and local DNS resolution. I’m afraid without knowledge of your network layout, I’m not going to be much help here.
+Ryan Creps
+Tessitura Network
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of James FairfieldSent: Tuesday, September 20, 2011 11:07 AMTo: Ryan CrepsSubject: RE: [Tessitura Technical Forum] IIS 7/ SSRS prompting for login
Hi Ryan:
I moved the servers/site to the local intranet zone. Now if I use the IP address I am not prompted to login, but if I use the server name I am prompted to login. Is there anything else i should check to resolve the server name mode of access? Until I fix this, Tessitura will not be able to access the SSRS reports.
Thanks, James
From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>Sent: 9/19/2011 2:47:40 PM
The servers/site need to be defined in the Local Intranet Zone as opposed to the Trusted Sites zone to utilize windows integrated authentication. By default automatic logon by windows authentication is only automatic when in the local intranet zone.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of James FairfieldSent: Monday, September 19, 2011 2:53 PMTo: Ryan CrepsSubject: [Tessitura Technical Forum] IIS 7/ SSRS prompting for login
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!
I solved the Microsoft part of this problem, it involved Kerbos and SPN (steps too numerous to mention). Now the Tessitura integration is returning and error:
Server Error in Application "DEFAULT WEB SITE/TESSITURASSRSPROXY"
Module IsapiModule
Notification ExecuteRequestHandler
Handler PageHandlerFactory-ISAPI-4.0_32bit
Error Code 0x800704ec
Requested URL http://tess-test2:80/TessituraSSRSProxy/ssrsproxy.aspx?id=232513
Physical Path C:\TessTest\Tessitura\TessituraSSRSProxy\ssrsproxy.aspx
Logon Method Negotiate
Here is the solution for the previous issue:
1.Click Start, type Inetmgr in the Start Search box, and then click Inetmgr in the Programs list.
If you are prompted for an administrator password or for confirmation, type the password, or click Continue.
2.Locate the level that you want to configure.
3.In Features view, double-click ISAPI and CGI Restrictions.
4. Right-click the restriction that restricts the requested ISAPI resource or the requested CGI resource, and then click Allow.