Hello,

I have RS (client and server components) installed on a test machine (Win2k), with the SQL-Server database on a remote machine. I'm able to create reports, preview them with data, and deploy them with no issues. However, when I try to execute any of them from the Report Manager, I get: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection".

The connection object is set up in the Report Manager as a shared data source, with the credentials stored in the report server, the credentials I'm using have access to the database, and I have the "Use as windows credentials when connecting to the datasource" check box checked (the database uses Windows authentication).

Between all of the logins/security settings in use by IIS, the Windows Services, the database, aspnet, etc. I'm at a loss as to where the issue might lie. Any thoughts?

Thanks in advance!

Brian

I have similar problem. Did you resolved it?
Thanks
Jean
[email protected]

If you were to connect directly to the same SQL Server database & execute the report's query from Query Analyzer or Management Studio, are you able to get results using the same credentials? If not, you may need to create a login/user for the database in SQL Server.

BTW, please check your system date. I don't think your message was posted 11 months ago.



Paul Turley, MCSD, MCDBA, MCT, MSF Practitioner