Date Archives June 8, 2018

Reporting Services | Unable to Establish Connection to the Database Engine

So we were trying to create a data source configured on Reporting Services 2016.

On entering the credentials we found that we kept getting the error below.

On doing a trace using SQL Profiler, we discovered the authentication attempt was not getting to the database engine. It so happened that we need to add the desired principal as a privileged user on the OS of the server hosting reporting services.