This is an off product SQL connection question unrelated to HeidiSQL but I think it can be answered here because it deals with database connection issues.
I am doing some test driven development on my first SSRS report I am doing some work, then I test to see if it throws an error. The code works in Visual Studio when I preview it But it threw an error
Here is the error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
The whole error is: An error occurred during client rendering. An error has occurred during report processing. Cannot create a connection to data source 'RulesDataSource'. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Please advise.