Post reply

Report Server Windows Service App Error 107

  • October 24, 2007 at 7:31 am

    #153914

    I have an occasional recurring report server error in the app log:

    Event ID:107

    Report Server Windows Serive [MSSQLSERVER] cannot connect to the report server database.

    This normally seems to relate to the SQL SERVER service not running and hence the database not being available. However here no services have stopped, failed or been restarted. Nothing I can see in the sqlserver or MS event logs seems to point to a likely cause.

    Any suggentions greatly appreciated.

    Ewan

  • October 24, 2007 at 8:22 pm

    #745193

    If SSRS and the database engine are on the same server, it's likely a timing issue. The SSRS service is starting up before the database engine is ready and the first connection attempt therefore fails.

    K. Brian Kelley
    @kbriankelley

  • October 31, 2007 at 11:45 am

    #747194

    Thanks for the response.

    Ewan

  • May 26, 2009 at 2:08 am

    #999741

    Hi...

    So how can we avoid this? Please give me a solution for this.

  • June 22, 2010 at 1:14 pm

    #1183564

    I am experiencing the same issue. It happens in the middle of the day -- after users have already been running reports. Is there anything to avoid users getting knocked out of reporting services

Viewing 5 posts - 1 through 4 (of 4 total)

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