Home > Report Server > Report Server Mssqlserver Cannot Connect To The Report Server Database

Report Server Mssqlserver Cannot Connect To The Report Server Database

Contents

Browse other questions tagged sql-server or ask your own question. To fix this issue set the Report Server service dependency on SQL Server service: [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ReportServer] Modify or create the DependOnService multi-word value to include MSSQLSERVER. But the solution above did worked. How do I get this error to stop? 0 Comment Question by:taylor11 Facebook Twitter LinkedIn Email https://www.experts-exchange.com/questions/22767039/Report-Server-Windows-Service-MSSQLSERVER-cannot-connect-to-the-report-server-database-ERROR.htmlcopy LVL 3 Best Solution bySirTKC Hi, I have solved my issue by going in Check This Out

If the product or version you are looking for is not listed, you can use this search box to search TechNet, the Microsoft Knowledge Base, and TechNet Blogs for more information. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Pimiento Jan 7, 2011 Brandon1802 Software Fix it Tony! There's so many different tables and data types.

Reporting Services Configuration Tool

But I do have MSSQL 2005 AND MSSQL EXPRESS 2005 installed on the same server. Even with 5 minutes per server (to check the logs and other parameters), it may take an hour to make sure that everything is ok and no "red lights" are blinking When I came in monday morning it was working again. Previously I'm almost certain that datasource errors (embarassing as it is) were displayed to the user in the report viewer window so I'm not sure why all we're getting now is

Along with 14+ years of hands on experience he holds a Masters of Science degree and a number of database certifications. I'm getting the same error... 0 LVL 3 Overall: Level 3 MS SQL Server 2005 1 Message Expert Comment by:SirTKC2009-07-10 Comment Utility Permalink(# a24824165) It would be great to mention ERROR:Event Type: Error Event Source: Report Server (SQL2K5) Event Category: Management Event ID: 107 Date: 2/13/2009 Time: 11:17:19 AM User: N/A Computer: ************ Description: Report Server (SQL2K5) cannot connect to the Event Id 107 Msexchange Search Indexer New computers are added to the network with the understanding that they will be taken care of by the admins.

Comments: EventID.Net See the link to "Report Server Windows Service (MSSQLServer) 107" for information about this event. I then checked whether I can connect to the reporting server database using the credentials specified in rsreportserver.config. Share via comments.Reference: Pinal Dave (http://blog.SQLAuthority.com) Tags: Reporting Services, SQL Error Messages, SQL Log File, SQL Server226Related Articles SQL SERVER - 2005 - SSMS Change T-SQL Batch Separator May 18, 2007Pinal this This can occur if you do not use the Reporting Services Configuration tool to set up the account or the report server database.

Can Trump undo the UN climate change agreement? Event Id 107 Task Scheduler WordPress | Web Design | Web Development Services home| search| account| evlog| eventreader| it admin tasks| tcp/ip ports| documents | contributors| about us Event ID/Source search Event ID: Event You cannot edit other topics. However, we do not have Reporting Services installed on this server.

Start The Database Engine Service

Feedback: Send comments or solutions - Notify me when updated Printer friendly Subscribe Subscribe to EventID.Net now!Already a subscriber? Why did Borden do that to his wife in The Prestige? Reporting Services Configuration Tool This thread is closed ! Report Server Windows Service (mssqlserver) Has Not Been Granted Access To The Catalog Content. Looking at the logs, there is 1 error and 1 warning which seem to correspond somewhat.

Please keep up the great work your doing! his comment is here IIS in our experience is not real good about keeping up for weeks in comparison to Apache/Tomcat/etc. –Leptonator Aug 11 '15 at 21:09 add a comment| 1 Answer 1 active oldest By creating an account, you're agreeing to our Terms of Use, Privacy Policy and to receive emails from Spiceworks. You’ll be auto redirected in 1 second. Remote Connections Are Enabled For Tcp/ip Protocol

How often should I replace windscreen wiper blades? Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We What account is used to run SSRS and Asp.net because SSRS 2005 is Asp.net dependent. this contact form GO OUT AND VOTE How do I avoid referring to all state variables when updating only a few?

Some column data needs quoted and some doesn't. The Report Server Windows Service Reportserver Is Not Running By creating an account, you're agreeing to our Terms of Use and our Privacy Policy Not a member? You cannot post replies to polls.

You cannot edit HTML code.

My immediate question was that, are there any more errors? Default website->properties ASP.net version 1.1.43222.Reports->properties ASP.net version 2.0.507273..Reportserver->properties ASP.net version 2.0.50727 Post #719296 Gift PeddieGift Peddie Posted Monday, May 18, 2009 12:13 PM Hall of Fame Group: General Forum Members Last You cannot post JavaScript. Failed To Unload App Domain Defaultdomain How can I take a powerful plot item away from players without frustrating them?

sql-server share|improve this question edited Dec 3 '14 at 16:41 sysadmin1138♦ 100k14124253 asked Dec 3 '14 at 15:30 Ankh2054 1,184818 Found the problem in the end. Get 1:1 Help Now Advertise Here Enjoyed your answer? What is the point of update independent rendering in a game loop? navigate here You cannot post EmotIcons.

When does TNG take place in relation to DS9? First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Once I enabled and changed port to 1433 and restarted all worked. I did not change anything after the upgrade.

Privacy Policy. I have checked the Local System Account radio button under Go to Solution 3 +2 5 Participants SirTKC(3 comments) LVL 3 MS SQL Server 20051 develc LVL 1 kevin12130 alannaw AlexanderAC How do I deal with my current employer not respecting my decision to leave? This can occur if you do not use the Reporting Services Configuration tool to set up the account or the report server database.User ActionStart the Database Engine service if it is

The Event Viewer on the reporting server reported the 'cannot connect to the report server database' error. Conditions under which this error occurs include the following: * SQL Server Database Engine service is not running when the Report Server service starts. * The connection to the Database Engine EDIT Tried both suggestions below several months ago to no avail. However, it was very inconsistent.

Help Desk » Inventory » Monitor » Community » SharePoint 2013 All About SharePoint. Join the community of 500,000 technology professionals and ask your questions. Covered by US Patent. I am careful not to have unnecessary services like “Reporting Services”, “Agent” etc running.

What now? Here is the link which talks about the location of SSRS logs which has helped me in finding exact error message Reporting Services Log Files and SourcesDo you know the location Join the community Back I agree Powerful tools you need, all for free. You cannot post topic replies.