All About SharePoint SharePoint 2010 and MOSS 2007 Resource Website

1Nov/105

Event ID 107:Report Server Windows Service cannot connect to the Report Server Database

Today 11/01/2010, when I was doing the routine event log checks for errors as a scheduled task on the first of every month. One of My SQL server had a whole bunch of Report Server Windows errors with event ID 107.

Please see the error below:

Report Server

Report Server

Event Type:        Error

Event Source:    Report Server Windows Service (MSSQLSERVER)

Event Category:                Management

Event ID:              107

Date:                     11/1/2010

Time:                     9:12:49 AM

User:                     N/A

Computer:          MOSSSQLSERVER

Description:

Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

Resolution: Go to Services. msc and  Make sure all the services for SQL Server  Database engine and Reporting Services were in the running state. Then Open the Report Services Configuration Wizard, Connect to the specified SQL Server Database Server and then I found that the connection to the Report Server Database was set to some other  database. Modified the settings doe the Database setup and connected the Report Server Database and save the settings.

Comments (5) Trackbacks (0)
  1. Hello!, Very interest article, we were talking about the same thing at work and found your site very interesting. So felt compelled to com?ment a little thank you for all your effort. Please keep up the great work your doing!

  2. hello I was fortunate to approach your Topics in baidu
    your Topics is superb
    I get much in your topic really thanks very much
    btw the theme of you site is really fabulous
    where can find it

  3. Hey thanks

  4. Hi all,

    Thanks for a good and useful guide. Solution is very clear. I needed this info.

    http://godwinsblog.cdtech.in/2010/12/sharepoint-2010-root-of-certificate.html

  5. This is very useful post for me because i need to know more about windows server. Now only i have started learning it. You have chosen a good topic and gave description very clearly.Many thanks to your team.And this is very much useful for me. I am expecting more from you about this topic. So keep posting..

    http://gloriatech.com/microsoft-windows-server-2008-setup.aspx


Leave a comment

(required)

No trackbacks yet.