Wednesday, March 25, 2015

SQL Server Reporting Services (SSRS) and MVC application with reports controller on same server

I ran into this problem recently and it took me a bunch of time to figure this out.

Problem
Getting prompted for a windows userid and password when accessing an MVC Controller action named http:\\mywebsite\reports.

Environment
Windows server 2012
SQL Server 2014 with SSRS
All of these items are on the same server as this was a development server.


Fix
I renamed my SSRS report manager URL to something other than reports.


Explanation
My MVC url http:\\mywebsite\reports was going to the reporting server, not my controller.  By renaming my SSRS report manager URL the names were now different and my problem was solved.


No comments:

Post a Comment