ConfigMgr 2012 – SQL Report keep prompting for credentials

This is similar with App Catalog keep prompting for credentials post.

While accessing ConfigMgr SQL web reports at http://servername/reports web page, it keeps prompting for credentials and won’t allow me to access the reports. Access given in ConfigMgr.

Since my Internet Security settings was done, it has something to do with SQL Reporting Services.

Solution:

1. Locate rsreportserver.config file at C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer (Path and SQL server version may differ).

image

2. Open the file and search for RSWindowsNegotiate

3. Comment the RSWindowsNegotiate authentication type as shown in picture below

image

4. Restart SQL Reporting services and retry launching the reports without the prompts Smile

Advertisements
    • D Richard
    • February 27th, 2015

    Thank you! I found solutions for the same problem using SCCM 2007, but yours was the first I found addressing the problem in SCCM 2012 R2. Worked perfectly!

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: