Error when viewing a report in SQL2005 -- sql server reporting services

jetski
2/2/2006 3:03:12 PM

We have published a report to SQL2005 and when we try to view it through XP
SP2 PC's it comes out with the following error.

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'NZDF2000'.
(rsErrorOpeningConnection)
For more information about this error navigate to the report server on the
local server machine, or enable remote errors

but when you view it on the desktop of the server itself it's fine, what
would be the cause please.

Thanks
Layth

SteveIrwin
2/3/2006 12:45:35 PM

Sounds like an authentication problem. What authentication are you using in
the data source? e.g. hard coded username/password, Windows Authentication,
etc.

[quoted text, click to view]

smisich
2/7/2006 2:13:27 AM

Hi,
To intoduce myself, I am a colleague of "jetski".
and to answer your question we are using windows integrated security.
I have tried using the other methods and hard coding my windows id &
password and it works fine. Its only when I set it to windows integrated
security does it fail.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Error when viewing a report in SQL2005