SQL Reporting with MOM 2005

  • Running into a problem with MOM 2005 trying to email out reports from SQL Reporting Services console.  I get the report set up correctly and can see the report fine, but would prefer to have MOM use SQL Reporting to email me the reports on a scheduled basis.

    However...when the report job runs, I get the following error from the SQL Reporting console.  "Transport failed; could not connect to server."

    Just curious where the error might be.

     

    Thanks.

     

     

  • Not sure, but are these on separate servers?

  • Yes, the SQL database for MOM is on one machine and the MOM Management server is on another.  Both servers are running Server 2003, with SQL Server 2000 (SP3a) being used for the MOM SQL database.

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

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