IIS 7/ SSRS prompting for login

Former Member
Former Member $organization

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

Parents
  • 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.

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of James Fairfield
    Sent: Monday, September 19, 2011 2:53 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] IIS 7/ SSRS prompting for login

     

    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




    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!

  • Former Member
    Former Member $organization in reply to Ryan Creps (Past Staff Member)

    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

Reply
  • Former Member
    Former Member $organization in reply to Ryan Creps (Past Staff Member)

    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

Children
No Data