SQL server 2000 reporting services error message!

  • Hi!

    I am trying to get started with the reporting services but its not working for me. At this point i am just trying to generate any random report to get started, but when i get to the "Preview" tab, it gives me the error message, "An error has occurred during report processing. Cannot create a connection to data source ‘******’. Login failed for user ‘*****".

    I have already tried connecting to Query Analyzer, and it doe connect me without any problem. I have checked the password several times as well, but the porblem persists.

    Any help would be great as I am doing this for the first time.

    Thanks.

  • Which Preview tab? The one in the website Report Manager or in the Visual Studio developement environment?

    If the web sounds like you don't have your data source defined or incorrect based on the server it is running from. Click on the Properties tab then the datasource and verify it is set.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply