How to troubleshoot SSRS prompting for user name/password?

Question

Keeps getting the following user name/password prompt when accessing the web portal and web service URL. I am following this thread but even with the adjustment from Configure Windows Authentication on the Report Server as shown here, this popup still shows up. I have tried a domain user name which have full access on the server as well as sql server on the local box but it's not taking it.

<Authentication>  
    <AuthenticationTypes>  
        <RSWindowsNegotiate />    
       <RSWindowsKerberos />    
       <RSWindowsNTLM/>  
    </AuthenticationTypes>  
    <RSWindowsExtendedProtectionLevel>Allow</RSWindowsExtendedProtectionLevel>  
    <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>  
</Authentication>  

Answer 1

Hi @CharlieLor ，

You may try the 3 ways to see if it will work.

1.Please add trusted sites in the web browser setting for a try.

Go to Tools - Internet Options - Security - Local Intranet - Sites.

2.Have you tried to use other browser such as Chrome for a test?

Right click and run as administrator to open the url to see if it will still ask for credentials.

3.Remove RSWindowsNegotiate from the RSReportServer.config file and verify that only RSWindowsNTLM is specified.

Restart SSRS and access the url.

Regards，
Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

What can I do if my transaction log is full?--- Hot issues November

How to convert Profiler trace into a SQL Server table -- Hot issues November

Answer 2

Zoe,

Thanks for the help. I have tried all three of your steps and still it prompts for user name and password. This happens right after I added the db22.dept1.loans.com host header.

And now this is what the Web Service URL page looks like:

And Web Portal URL.

Is there something wrong in these settings?

Answer 3

After configuring the proxy server in IE, it's no longer asking for username/password but I keep getting the following error.

Answer 4

Thanks! I got this part working. I still have an issue but I'll post on another thread since this particular issue is now resolved.

Answer 5

Hello @CharlieLor ,
Thank you for this post. I am facing the same issue and have been unable to resolve it. Can you please share what you did to resolve the continuous credential prompt?

Thank you in advance :)
Tami