Hello, all.
I have an issue with a report I am trying to create in SQL Server Business Intelligence Development Studio. For some reason, the permissions are not working properly. Here is a more detailed description of what is happening:
Issue:
I can run the report just fine on my local machine but when I build and deploy to the Report Manager I am then unable to run the report. I checked SQL server logs and it is showing me trying to log in as: NT AUTHORITY\ANONY MOUS LOGON instead of my network logon.
Error:
“An error has occurred during report processing. Cannot create a connection to data source 'Aware'. For more information about this error navigate to the report server on the local server machine, or enable remote errors “
Thoughts:
It just seems that the report manager for some odd reason is not passing on my permissions correctly or I do not have permissions setup on the SQL server setup correctly.
Has anyone run into this and do you know of any steps I could take to correct this? Any assistance would be greatly appreciated.
I have an issue with a report I am trying to create in SQL Server Business Intelligence Development Studio. For some reason, the permissions are not working properly. Here is a more detailed description of what is happening:
Issue:
I can run the report just fine on my local machine but when I build and deploy to the Report Manager I am then unable to run the report. I checked SQL server logs and it is showing me trying to log in as: NT AUTHORITY\ANONY MOUS LOGON instead of my network logon.
Error:
“An error has occurred during report processing. Cannot create a connection to data source 'Aware'. For more information about this error navigate to the report server on the local server machine, or enable remote errors “
Thoughts:
It just seems that the report manager for some odd reason is not passing on my permissions correctly or I do not have permissions setup on the SQL server setup correctly.
Has anyone run into this and do you know of any steps I could take to correct this? Any assistance would be greatly appreciated.
Comment