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.