Wednesday, February 15, 2012

ConfigMgr Reports Prompts for a Password

Out of the blue my web reporting for ConfigMgr started prompting for a password and no matter what account you entered it would be rejected. If you cancelled the prompt you would receive an access denied error. My reporting site was setup properly with all of the correct prerequisites as it had been online for a couple of years. Nothing seemed to work – no recent patches had been installed, logs were clean, permissions looked correct, IISRESET didn’t nor did a system reboot. Reports would also work fine from a local session on the site server. After much digging I finally came across a post on the TechNet forums that resolved the issue. Here are the steps that helped resolve the issue:

·         Open IIS Manager and navigate to your SMS_Reporting site
·         Click on the site and select Authentication under IIS from the main screen
·         From the Action pane select Providers
·         Ensure the NTLM is listed and it is at the top of the list
·         Open a command prompt and run IISRESET
After that I could access reports locally and from a remote session. All the more reason to migrate my ConfigMgr reporting to SQL Reporting Services.