January 11, 2008 at 9:27 am
Hi Experts,
i used SSRS to build a report model, data is there for sure 🙂 and uploaded it into a Reporting Server. However, when i bring it in to build my ad hoc reports, it's acting really mean to me: first, it doesn't show data in drop-down box when i want to set up a filter for let's say, customer_status column. then, when i finally hard-code it and run my report, it gives me really un-friendly error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
----------------------------
Cannot create a connection to data source 'dataSource1'.
----------------------------
An error has occurred during report processing.
so, it allows me to deploy my data model, but not view data? any ideas, please? it works like a charm at my own machine at home where of course, i have integrated security all over the map, but doesn't work here. any leads, thoughts will be appreciated even though it may not work.
thank you so, so much!
Maya
January 11, 2008 at 9:44 am
Are the report server database server and IIS server the same machine? If not you need enable kerberos within the domain in order to use a trusted connection. The easiest way to fix it is to have a sql account you use for connecting to the DB.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 11, 2008 at 10:02 am
Thank you, Jack 🙂
actually, sql server and report server are on 2 different machines. and i think i figured it out: my data connection is configured to use integrated security which is using win integ security on IIS.
when i configured to use the credentials stored in the report server, it worked like a charm :-). thanks again!
Maya
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply