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.