Report server requiring multiple logins before accepting

Posted on 2011-10-26
Last Modified: 2012-05-12
This morning our report server began requesting login credentials that are usually pulled automatically. The user then has to press OK three times in order for them to be accepted, without changing any of the info entered. The process then repeats with each folder and file they try to access. Any suggestions as to why this is happening and how to fix it?
Question by:Linear-IT
    LVL 4

    Expert Comment

    are your client machines on a domain which is different from the reporting server?
    if so what is happening is when you submit a user:password combo to the reporting server, the client is actually sending DOMAIN\USERNAME:password

    try logging into the reporting server using <report server name>\username:password

    Author Comment

    They're on the same server. The problem has to boil down to the fact that it's requiring the credentials three times; no more, no less. The exact same credentials; you literally click OK three times and it goes through. Until you try to access the next level down, then you have to click OK again three times.

    So I think it's pulling the logins like it's supposed to, but they're not being accepted on the first go.
    LVL 4

    Accepted Solution

    find the machine name of your report server, and try and log in using reportservername\username
    it comes down to how windows domain names are handled.

    the reason i suggest this is we discovered that after 3 months of users tripleclicking login boxes, and users that had the same report server username and domain username, but had different passwords would end up locking out their windows accounts. by default the reporting server was trying to prefix all usernames with DOMAIN\ and then authenticate agaisnt the domain server, even with all the logins being local to the reporting server. easy fix is to get everybody to start prefixing their usernames with REPORTSERVERNAME\ and then there was no more tripleclicking
    LVL 100

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
    A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now