When mapping a SQL Server 2012 datasource in the Admin Console and selecting
'Users can authenticate with this default key'
and checking 'Use Windows integrated security'
The following error is displayed
"Error mapping data source "test" for Intelligence Central server "root@localhost:3566"
Server error 4206: Invalid data source definition: Login failed for 'domain\username'.; Invalid connection string attribute."
Windows Authentication for SQL Server can only support the user the process is running under i.e.
For Local Intelligence central it's the logged in user
For the server it's the user the service runs under
Use SQL Server authentication