Link to home
Start Free TrialLog in
Avatar of CalBob
CalBob

asked on

SSRS 2016 Connection/Permission Error

I'm getting a connection error when trying to render a report using SSRS 2016 Report Manager.  Here is my setup:

For testing purposes, I installed SQL Server 2016 Developer on a Windows 10 Professional laptop.  As part of the SQL Server installation I installed SSRS 2016, on the same laptop.  Then I configured SSRS 2016 and everything seems good to that point.

I created a new data source (DataSource1) and a test report in Visual Studio.  The report previews perfectly while in Visual Studio, so I deployed both the data source and the report to the Report Manager.  

I see the report and data source when I open Report Manager web page.  However, when I run the report I get the following error:

"...Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection).  A network-related or instance-specific error occurred while establishing a connection to SQL Server.  The server was not found or was not accessible..."


When I test the data source in Visual Studio it works.  When I test the data source from the Report Manager web page I get the same error as above.  

It seems simple enough but I can't figure out what the issue is.  I am using Windows authentication and I'm the admin for the laptop as well as the SQL instance.

Any help would be appreciated.  Thanks.
ASKER CERTIFIED SOLUTION
Avatar of CalBob
CalBob

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of CalBob
CalBob

ASKER

I found the problem and included a screen shot and explanation.  Thanks.