SQL server 2000 reporting services error message!

  • 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.

  • Ur password is not saved in DS.

    from

    Killer

  • check with datasource .and be sure that when you click Test connection' when you open the datasource by right clicking o nthe data source. this message "Test connection succeded"should appear, then only you can be sure that there is no problem with dataconnection

    Regards

    Raj Deep.A

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

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