Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error with Trusted Connection

Status
Not open for further replies.

ablackwe

Programmer
May 14, 2004
57
GB
I have received the following error after deploying my report.

An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'ADEPT'. (rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I have deployed a previous version of the same report and managed to run it fine. Since making a very slight amendment to the layout, I now get this. Anyone any ideas what it means?
 
Are you storing the login credentials in the report server? If so, you might check the data source properties on the report server. I've had several instances where reports just seem to have lost their login credentials. I fix it either by redeploying the report, or adding the login id and password to the data source properties on the report server.
 
Thanks for the reply Andrea. I have now sorted it by closing down my Report Manager and reopening it again.
Thanks
Adam
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top