SSRS Question

complete's profile image complete posted 6 years ago in Creating a connection Permalink

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.

ansgar's profile image ansgar posted 6 years ago Permalink

That looks as if your connection component does not get the credential you have passed (did you even?)

lukinhaspm's profile image lukinhaspm posted 6 years ago Permalink

Some permission issue in the server... Or, did you try this? https://stackoverflow.com/questions/10760162/login-failed-for-user-nt-authority-anonymous-logon

Please login to leave a reply, or register at first.