SQL Server Performance

Invalid object name 'mgr_server'

Discussion in 'SQL Server Reporting Services' started by ykchakri, Nov 4, 2004.

  1. ykchakri New Member

    Hi,

    I'm getting the following error while trying to run the SQLH2 reports from Report Manager.

    Query execution failed for data set 'serverID'. (rsErrorExecutingCommand)
    Invalid object name 'mgr_server'.

    But, the table mgr_server does exist in the database.

    Can anyone tell me what could be the reason for this error ?
  2. Luis Martin Moderator

    Not my, I had a lot of problems with SQLH2 so I give up.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  3. ykchakri New Member

    I've finally figured it out. Thought this would be helpful to someone.

    I had to setup the following in the Connection string of the data source:
    Initial Catalog=SQLH2Repository

Share This Page