Deploy SSRS Login Window Dialog box asking UserName and Password when deploying SSRS reports - Solution

Today when I was deploying one of the report I had created for DBA Monitoring encountered this error. When I change mode to Production for Report and click go, Immediately I got prompt windows Reporting Services Login asking for User Name and Password, then I remembered the same mistake which I was doing earlier.



Posting solutions for this issue so that it may help you!

1. Make sure you are deploying to http://localhost/ReportServer and NOT http://localhost/Reports ($Instance for named instance)

2. Modify the Log On in SQL Server Reporting Services (via control panel, services) to be the Local System account.

3. Add your login as "Execution Account" (this step will not be setup automatcially when Reporting Services is installed) and it will have a yellow triangle when you open Reporting Server Configuration Wizard.

4. Make sure you run IIS in default port (80) else you need to change portnumber. Ex: If IIS is running in 82 then your RS URL will be http://localhost:82/reportserver

5. Open Management Studio and select "Reporting Services" from drop down menu and connect to Reporting Services instance. Select HOME --> Properties and make sure that you have rights to this folder since reports are deployed here only!

6. Go to IE -> Tools -> Internet options -> Security -> click local intranet icon, then clicked the sites button which brings up a box showing Auto detection of intranet network. If you then click Advanced button at the bottom, you will get a screen to add sites. Add http://localhost here if it's not added.



7. Go to Reporting Services Configuration Manager -> Database setup --> Check the Server Name property -> Make sure that default setup set to "(local)/{Instance Name}"



8. Restart Reporting Services and try again... If issue still persists contact MS!