After the successful installation of SQL Sever Reporting Services 2012 or 2008 R2 (read this article for an installation tutorial: SQL Server 2012 Express Installation Tutorial), you will get constantly prompted with Windows Security dialog box to enter login details. This is related to IE9 which ships with Windows 7 operating systems.

image

It is easy to fix this issue by following these steps:

1. Open Internet Explorer (IE9) and from the tools menu, choose Internet Options:

image

2. From the Security Tab, choose Local intranet and click on Sites:

image_thumb[15]

3. Click on Advanced button:

image_thumb[16]

4. Type in localhost in Add this website text field and click on Add button (Un-tick the box Require server verification (https:) for all sites in this zone):

image

 

All done. If you open your IE again and type in Reporting Services URL, you will no longer be prompted to enter login details.

However, you may see a UAC (User Access Control) authorization error message. To learn how to resolve this issue, read this article:

SQL Server 2012 UAC authorization error