We will keep your servers stable, secure, and fast at all times for one fixed price.

Error 1053 SQL server – How we solve it

by Gayathri R Nayak | Jan 22, 2021

Error 1053 SQL server occurs when attempting to pause or stop the SQL Server service in the Windows Services Console.

Here at Bobcares, we have seen several such SQL related issues as part of our Server Management Services for web hosts and online service providers.

Today we’ll take a look at the cause for this error and how to fix it.

What causes error 1053 SQL server to occur

The Microsoft Windows Service Control Manager controls the start, stop, and pause state of all installed Windows services. If the system times out before the stop or pause has completed then this error occurs.

By default, the Service Control Manager waits for 30 seconds until a service responds. However, certain configurations, technical restrictions, or performance issues may delay the service to respond and may take longer than 30 seconds.

By editing or creating the ServicesPipeTimeout DWORD value, the Service Control Manager timeout period can be overridden, thereby giving the service more time to start up and report ready to the Service.

For instance, the error appears as below.

How we fix error 1053 SQL server

Here are a couple of steps that our Support Engineers provide to our customers to resolve this error.

1. Process monitor usage

  • Run process monitor and then run SQL service from the command line (copy path and syntax from services properties) Find the file location in process monitor running as the service attempted to run C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4053_x-ww_e69679\MSVCP80.dll
  • Open that directory and check whether file size and date for MSVCP80.dll is different than the one in SQL setup and install directory. Replace it.

2. Ending the process that is causing the error is the best solution to get rid of this error. Here are the steps to end the process.

  • Initially, open the Windows Task Manager and go to the Processes tab
  • Then select sqlservr.exe and click End Process
  • When prompted to confirm that you wish to end the process, click End process

3. Restarting the computer is the easiest way to fix this error. After restarting attempt to stop the service again to test

4. The SQLServerAgent service startup account may not have the correct folder permissions that contain SQLAgent.out files. In such cases, make sure that the SQLServerAgent service account has full control permissions to the folder in which the SQLAgent.out , SQLAgent.1 , SQLAgent.2 , and other SQL Server files are located. These files are typically stored in the LOG folder, which is in the SQL Server installation path.

5. Few executable .dll files may be corrupted or damaged.

In this case, try to start SQL Server Agent from the command prompt by running the following command:

For Default Instance

For Named Instance

If you receive the following error message

execution can’t continue as the language resource file sqlagent.rll could not be loaded

Then replace the SQLAgent.dll and SQLAgent.rll files with different copies of these files ( SQLAgent.dll and SQLAgent.rll ).

[Need any further assistance in fixing SQL errors? – We’re available 24*7 ]

In short, this error occurs when attempting to pause or stop the SQL Server service in the Windows Services Console. Today, we saw the resolution to this SQL error.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

Submit a Comment Cancel reply

Your email address will not be published. Required fields are marked *

Submit Comment

Spend time on your business, not on your servers.

Or click here to learn more.

Bobcares uses cookies.

Privacy Preference Center

Consent management.

Privacy Policy

When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.

Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. The website cannot function properly without these cookies. PHPSESSID - Preserves user session state across page requests. gdpr[consent_types] - Used to store user consents. gdpr[allowed_cookies] - Used to store user allowed cookies.

Cookies Used

livechat.bobcares.com

my.bobcares.com

Statistic cookies help website owners to understand how visitors interact with websites by collecting and reporting information anonymously. _ga - Preserves user session state across page requests. _gat - Used by Google Analytics to throttle request rate _gid - Registers a unique ID that is used to generate statistical data on how you use the website. smartlookCookie - Used to collect user device and location information of the site visitors to improve the websites User Experience.

manager.smartlook.com

clarity.microsoft.com

Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and engaging for the individual user and thereby more valuable for publishers and third party advertisers. IDE - Used by Google DoubleClick to register and report the website user's actions after viewing or clicking one of the advertiser's ads with the purpose of measuring the efficacy of an ad and to present targeted ads to the user. test_cookie - Used to check if the user's browser supports cookies. 1P_JAR - Google cookie. These cookies are used to collect website statistics and track conversion rates. NID - Registers a unique ID that identifies a returning user's device. The ID is used for serving ads that are most relevant to the user. DV - Google ad personalisation

doubleclick.net

google.co.in

These are essential site cookies, used by the google reCAPTCHA. These cookies use an unique identifier to verify if a visitor is human or a bot.

Lane's Tech Blog

Thursday, February 20, 2014

Sql server reporting services service start timeout.

sql server reporting services 1053

43 comments:

Wow. This was exactly solved our SSRS production Issue. Fix was just Awesome.

sql server reporting services 1053

I'm really pleased it helped. It took us awhile to recognize the problem before we nailed it down, so I hope it'll short-circuit some troubleshooting for some.

Mucha gracias . Me ayudo en el problema

i've done what was explained here. no luck i really need this problem to be fixed. what else can i give you so you can help me out if you have time. dead line with the new report, and can't test what i've developed in the extensions because my local RS stopped working. what a bummer. thanks in advance

Hi, Buga, what kind of symptoms are you seeing? Is RS just not starting at all? If that's the case, it's certainly a different problem than described above. The Windows event log ought to have some hints as to what's up, if that's the case (check the application event log for errors). There's also the RS logs, which by default are at \Program Files\Microsoft SQL Server\MSRSxx.MSSQLSERVER\Reporting Services\LogFiles where the "xx" is a version of SQL (11 for SQL 2012, 12 for SQL 2014, etc.) If you haven't already worked out the problem, let us know, and maybe we can help.

Awesome Lane...It worked like charm. Thanks Buddy.

Thank you very much Lane..!!! it helps me A lot :)

Hi - I am having the same error (1053) after some Windows updates were applied over the weekend. I added the to the config file like indicated but still not working. I also set the ServicesPipeTimeout to 60000 and then to 120000 and nothing. Any ideas? Thank you!!

Hi, Core, Is this a consistent problem, as in SSRS won't start manually, ever? Or is it something where SSRS won't start in a timely manner after a reboot? Are you seeing any errors or timeouts in the SSRS log files (\program files\microsoft sql server\MSRSxx.mssqlserver\reporting services\logfiles)? Those probably will help us figure out what's happening.

Thank you so much!!!!! Your solution nailed it!

Nice. I'm pleased it worked; thanks for leaving a note!

super its worked for me too

It worked for me too!!!! Thank you :)

Thanx hey, it worked forme!

Thanks! it worked.

Thanks a lot, Lane! It worked for me too.

Thanks. That was driving me around the bend.

Worked like a charm!! thanks for sharing :)

Awesome! Thanks so much - Saved the day in production

Worked like a charm!!! Thanks Lane!!

Had the same problem and after trying your workaround, RS started successfully. The issue is now in accessing the report server using web URL (http://servername/Reports)...it comes back with the error "HTTP error 503 Services Unavailable"....any idea what might be causing this. FYI : I am running the browser as administrator.

Great! Worked like a charm. Thanks

Another person right here who was just blessed by this solution post. Thanks!!!

Tnx alot....it works as a charm

Thanks for this, saved me a production server reboot!

Lane, Thanks for explaining this. I've dealt with that issue many times in the past using the ServicesPipeTimeout workaround (https://support.microsoft.com/en-us/kb/922918, or Method 4 in https://support.microsoft.com/en-us/kb/2745448), but never knew why it had to be done. It is still a mystery why all of the sudden SSRS would timeout to start. Recently we had this issue after a Windows Update to SQL Server 2008R2 (KB3020370) along with a security update (KB3045312). Perhaps one of them triggered it. Any insight? Thanks again, Aldo Gonzalez

Hey, Aldo, I haven't seen anything about the latest round of patches to suggest they'd be affecting RS service startup times, or changing the way RS does its CRL check at startup. However, I *do* know there have been a variety of security recommendations lately (particularly from PCI) that have affected which web encryption technologies are considered secure and whatnot; this has led to some significant changes in the way vendors (and perhaps MS?) have started dealing with SSL certs and encryption protocols (SSLV3, TLS1.0, etc.). So: it's possible that something has changed in the way a particular cert is read or supported, and this, I suppose, could result in something similar. Does disabling CRL in RS clear up the error? That'd help narrow things down.

I've just hit this issue as well - will see if the updates you see are the same as what was just recently installed. thanks

I have checked the updates on my affected server and only only the first update you mention is installed. In my case it was installed in May so I can rule that one out. Perhaps some non SQL related update is affecting it?

That's certainly possible: there have been a lot of updates (and SQL updates, specifically) from Microsoft recently. Another thing to check is firewall and networking changes in your environment: if something is affecting outbound internet access from your server, that'd cause this 100% of the time. Does disabling CRL checking make a difference?

disabling CRL just made the timeout error appear heaps faster as the OP mentioned. I have applied the pipes timeout reg key and just need a window to restart the server. Apparently there was an patch that killed SSRS KB2990214 - this was installed in April, but it is possible that one of the newer patches plus this one could have undone the fix.

Thanks for taking the time to share this. Most helpful.

This worked for me: http://blogs.msdn.com/b/mariae/archive/2012/11/12/reporting-services-service-doesn-t-start-after-the-installation-of-ms12-070-security-patch.aspx

Awesome! Thank you :)

Try these. Worked for me. http://sqldbworld.blogspot.com/2015/11/sql-server-reporting-services-fails-to.html

Your solution is the best! Thank you for sharing with public! You are great!

Thankls a lot. You saved my day !!!

Unlike so many published fixes, yours worked easily and simply. I had tried other published ideas and they failed. Yours worked. Thanks so much.

sql server reporting services 1053

Vowww !!! That's superb. You saved my Sunday sir !! It worked like a charm for me.

Worked for me, thank you

Worked for us - thanks for the post

sql server reporting services 1053

my oh my. What a great article and well explained. Helped to get the service backup. I still haven't figured the downside of disabling the CRL check :-) There is a drawback or not? Anyways, Appreciate the article

Excellent post! Thanks a lot!!

Thanks for leaving a comment!

KBase

Reporting Server Error 1053: The service did not respond to the start or control request in a timely fashion

Open a registry editor and go to

Edit or Create the following entry (This value represents the time in milliseconds before a service times out.)

Restart the computer

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/b57ee42d-42ef-44a4-9670-be9088dbf9d4/reporting-server-error-1053-the-service-did-not-respond-to-the-start-or-control-request-in-a-timely?forum=sqlreportingservices

Was this post helpful?

' src=

→ KBase

Related Posts

Install sql server silently, error code 0x84b20001 when installing update for sql server 2008 r2.

SQL Server Reporting Services (MSSQLSERVER)

When protecting SQL Server 2008 R2 services, the "SQL Server Reporting Services (MSSQLSERVER)" may be selected as an optional protected service. However, if the time required to start this service exceeds the default Windows service timeout, you may get Error 1053, the service may fail to start and the SIOS Protection Suite resource in-service operation will fail.

This problem may be related to system performance and configuration issues. The recommended action is to not protect this service.  However, if it must be protected, the following registry setting will extend the time available for services to start. In the " HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control " Registry key, add a " ServicesPipeTimeout " value as a DWORD , and set the value to 60000 (decimal, = 60 secs.).

© 2017 SIOS Technology Corp., the industry's leading provider of business continuity solutions, data replication for continuous data protection.

Open topic with navigation

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Install SQL Server Reporting Services

  • 13 contributors

SQL Server Reporting Services installation involves server components for storing report items, rendering reports, and processing of subscription and other report services.

Download SQL Server 2022 Reporting Services from the Microsoft Download Center.

Download SQL Server 2019 Reporting Services from the Microsoft Download Center.

Download SQL Server 2017 Reporting Services from the Microsoft Download Center.

Looking for Power BI Report Server? See Install Power BI Report Server .

Upgrading or migrating from a SQL Server 2016 or earlier version of Reporting Services? See Upgrade and Migrate Reporting Services .

Before you begin

Before you install Reporting Services, review the Hardware and software requirements for installing SQL Server .

Install your report server

Installing a report server is straightforward. There are only a few steps to install the files.

You don't need a SQL Server Database Engine server available at the time of install. You do need one to configure Reporting Services after install.

Find the location of SQLServerReportingServices.exe and launch the installer.

Select Install Reporting Services .

Choose an edition to install and then select Next .

For a free edition, choose either Evaluation or Developer from the drop-down.

Evaluation or developer editions

Otherwise, enter a product key. Find the product key for SQL Server Reporting Services .

Read and agree to the license terms and conditions and then select Next .

You need to have a Database Engine available to store the report server database. Select Next to install the report server only.

Specify the install location for the report server. Select Install to continue.

The default path is C:\Program Files\Microsoft SQL Server Reporting Services.

After a successful setup, select Configure Report Server to launch the Report Server Configuration Manager.

Configure your report server

After you select Configure Report Server in the setup, you're' presented with Report Server Configuration Manager . For more information, see Report Server Configuration Manager .

You need to create a report server database to complete the initial configuration of Reporting Services. A SQL Server Database server is required to complete this step.

Creating a database on a different server

If you're creating the report server database on a database server on a different machine, you need to change the service account for the report server to a credential that is recognized on the database server.

By default, the report server uses the virtual service account. If you try to create a database on a different server, you may receive the following error on the Applying connection rights step.

System.Data.SqlClient.SqlException (0x80131904): Windows NT user or group '(null)' not found. Check the name again.

To work around the error, you can change the service account to either Network Service or a domain account. Changing the service account to Network Service applies rights in the context of the machine account for the report server.

For more information, see Configure the report server service account .

Windows Service

A Windows service is created as part of the installation. It's displayed as SQL Server Reporting Services . The service name is SQLServerReportingServices .

Default URL reservations

URL reservations are composed of a prefix, host name, port, and virtual directory:

An example of the complete URL string might be as follows:

https://+:80/reportserver , provides access to the report server.

https://+:80/reports , provides access to the web portal.

If you're accessing the report server from a remote machine, you want to make sure you've configured any firewall rules if there's a firewall present.

You need to open up the TCP port that you've configured for your Web Service URL and Web Portal URL. By default, these are configured on TCP port 80.

Additional configuration

To configure integration with the Power BI service so you can pin report items to a Power BI dashboard, see Integrate with the Power BI service .

To configure email for subscriptions processing, see E-Mail settings and E-Mail delivery in a report server .

To configure the web portal so you can access it on a remote computer to view and manage reports, see Configure a firewall for report server access and Configure a report server for remote administration .

Related information

For information on how to install SQL Server Reporting Services native mode, see Install Reporting Services native mode report server .

For information on how to install SQL Server 2016 Reporting Services (and earlier) in SharePoint integration mode, see Install the first Report Server in SharePoint mode .

With your report server installed, begin to create reports and deploy those to your report server. For information on how to start with Report Builder, see Install Report Builder .

To create reports using SQL Server Data Tools, download SQL Server Data Tools .

More questions? Try asking the Reporting Services forum

Was this page helpful?

Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback .

Submit and view feedback for

Additional resources

SQL SSRS suddenly stopped working.

About 10 days ago our SQL Server Reporting Services stopped working.  When trying to start the service manually, I get this error message: "windows could not start sql server reporting services error 1053"

I have tried extending the time out period as suggested but that did not help.

Whether I uninstall, reinstall, or repair I get an error message at the end telling me to check my setup log files, though I an unable to find an indicator as to what the problem may be.

We own SQL 2019 Standard and it does let me use that key when installing SSRS it after a uninstall but everything results in an a error.  It will not take the key if I try and "upgrade" the version already installed.

I have only been at this job a couple of months and it is possible the last guy installed an evaluation version but I am unable to confirm that.

I noticed that it never creates the  C:\Program Files\Microsoft SQL Server Reporting Services folder during install.

Here is the install error:

Image: post content

I also attached the last log file.

Thanks for your time and help,

User: Steve Lawrence

Popular Topics in Microsoft SQL Server

Author Brian Swales

I believe there is something wrong with the MSI/installation files or the Windows Installer itself. As you say, it doesn't even try to install the software.

This looks like some garbage. I could be wrong, but my experience says it isn't correct.

Hopefully, you are using virtual machines. The quickest solution is to build a new server with the correct SQL Server version and SSRS, then migrate your databases, SQL Agent jobs and application to the new server. You might get it working at some point without a rebuild, but I wouldn't trust that machine after this.

We don't even know what exact versions of Windows or SQL Server you are on - or trying to update with SSRS. You might be using SQL Server 2019, but what patch level is the machine at.

Author Steve Lawrence

 Thanks for the reply.  Once I started poking around looking for the SQL log files I realized that SSRS was not installed in the default directory, it is on the D:\ drive.  I uninstalled the app (ending with that same error as above), renamed the SSRS install folder and reinstalled SSRS using our SQL 2019 key and everything went smooth.

 SSRS is backup and running, I just need to get things setup but I still have the old install folder.

 Thanks again for your help!

This topic has been locked by an administrator and is no longer open for commenting.

To continue this discussion, please ask a new question .

Read these next...

Curated Snap! -- Mars Simulation, Crash Blossoms, Reddit AI Deal, Seeing Around Corners

Snap! -- Mars Simulation, Crash Blossoms, Reddit AI Deal, Seeing Around Corners

Your daily dose of tech news, in brief. Welcome to the Snap! Flashback: February 20, 1947: Alan Turing Suggests Testing Artificial Intelligence with the Game of Chess (Read more HERE.) Security News: • 13,000 Wyze Users Got Brief Peek ...

Curated Spark! Pro Series - 20 February 2024

Spark! Pro Series - 20 February 2024

Today in History: 20 February 1280 – Japanese Imperial Court orders all temples and shrines to pray for victory in the impending second Mongol invasion 1547 – King Edward VI of England crowned following the ...

Curated In-Person, Classroom IT Training Available Anywhere?

In-Person, Classroom IT Training Available Anywhere?

Before Covid if I noticed a hole in my knowledge-base to better the company I work at I would request some training.  At that time there was a choice between streamed or in-person classroom training and I'd choose in-person.  Now when I search for classro...

Curated Gaming PC Cafe Software

Gaming PC Cafe Software

Hello everyone,I'm looking to build an Esports / Gaming PC Cafe room into my business. My main concern is the lock down of the computers.Is there a specific program out there for PC Cafes that make this more streamlined? I have tried to do some research b...

Curated Happy Sweet Sixteen, Spiceworks Community!

Happy Sweet Sixteen, Spiceworks Community!

February 25th marks the 16th Anniversary of the Spiceworks community, and we thought we'd have a contest to celebrate.To Enter:Comment below and tell us the ideal gift you would give to the Spiceworks community.  This will enter you (if you live in a coun...

Error 1053 when try to start MSSQLServer Service

sqlstar2011

SSCertifiable

Points: 6000

More actions

April 5, 2006 at 8:15 am

I have a two node cluster. When I try to failover from active node which is node2 to node1 I get the following errors in the event viewer/ system logs

The MSSQLSERVER service failed to start due to the following error:

The service did not respond to the start or control request in a timely fashion.

Timeout (30000 milliseconds) waiting for the MSSQLSERVER service to connect.

Cluster resource 'SQL Cluster Group Server Service' in Resource Group '006-PM2-DBASQL' failed.

SQL Server Error Logs dont show any error either execpt one which i think is unrelated to this issue:

2006-04-05 09:51:43.86 server    Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)

 May  3 2005 23:18:38

 Copyright (c) 1988-2003 Microsoft Corporation

 Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2006-04-05 09:51:43.86 server    Copyright (C) 1988-2002 Microsoft Corporation.

2006-04-05 09:51:43.86 server    All rights reserved.

2006-04-05 09:51:43.86 server    Server Process ID is 5508.

2006-04-05 09:51:43.86 server    Logging SQL Server messages in file 'S:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

2006-04-05 09:51:43.86 server    SQL Server is starting at priority class 'normal'(1 CPU detected).

2006-04-05 09:51:44.00 server    SQL Server configured for thread mode processing.

2006-04-05 09:51:44.08 server    Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.

2006-04-05 09:51:44.10 server    Attempting to initialize Distributed Transaction Coordinator.

2006-04-05 09:51:46.97 spid3     Starting up database 'master'.

2006-04-05 09:51:47.11 server    Using 'SSNETLIB.DLL' version '8.0.2039'.

2006-04-05 09:51:47.14 server    SQL server listening on 10.14.200.155: 1433.

2006-04-05 09:51:47.16 spid5     Starting up database 'model'.

2006-04-05 09:51:47.16 spid3     Server name is '006-PM2-DBASQL'.

2006-04-05 09:51:47.18 spid8     Starting up database 'msdb'.

2006-04-05 09:51:47.21 spid9     Starting up database 'pubs'.

2006-04-05 09:51:47.21 spid10    Starting up database 'Northwind'.

2006-04-05 09:51:47.21 server    SQL server listening on TCP, Shared Memory, Named Pipes.

2006-04-05 09:51:47.21 server    SQL Server is ready for client connections

2006-04-05 09:51:47.21 spid11    Starting up database 'Workflow'.

2006-04-05 09:51:47.29 spid5     Clearing tempdb database.

2006-04-05 09:51:47.30 spid9     Starting up database 'Cube'.

2006-04-05 09:51:47.35 spid10    Starting up database 'SABADev2'.

2006-04-05 09:51:47.36 spid8     Starting up database 'WorkflowTest'.

2006-04-05 09:51:47.55 spid10    Starting up database 'WSS-Config'.

2006-04-05 09:51:47.79 spid5     Starting up database 'tempdb'.

2006-04-05 09:51:53.47 spid9     Analysis of database 'Cube' (8) is 100% complete (approximately 0 more seconds)

2006-04-05 09:51:53.63 spid3     Recovery complete.

2006-04-05 09:51:53.64 spid3     SQL global counter collection task is created.

2006-04-05 09:51:53.99 spid52    Using 'xpsqlbot.dll' version '2000.80.2039' to execute extended stored procedure 'xp_qv'.

2006-04-05 09:52:00.29 spid53    Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'xp_sqlmaint'.

2006-04-05 09:52:01.25 backup    Log backed up: Database: Northwind, creation date(time): 2000/08/06(01:41:00), first LSN: 23:419:1, last LSN: 23:421:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'S:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\TransactionLogs\Northwind_tlog_200604050952.TRN'}).

2006-04-05 09:52:01.49 spid54    Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'sp_MSgetversion'.

2006-04-05 09:52:08.63 spid55    Error: 15457, Severity: 0, State: 1

2006-04-05 09:52:08.63 spid55    Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..

2006-04-05 09:52:08.74 spid55    Using 'xplog70.dll' version '2000.80.2039' to execute extended stored procedure 'xp_msver'.

2006-04-05 09:53:34.49 spid54    Error: 15457, Severity: 0, State: 1

2006-04-05 09:53:34.49 spid54    Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..

MSSQLServer and SQLServerAgent services are running under a system admin user account. What possibly could be the issue here?

Scorpion_66

Points: 7891

April 5, 2006 at 9:05 am

The most common cause of this in my experience has been when one of the files needed by sql server was not on a shared resource, and Sql Server, once failed to the other node, couldn't access it. Does this error occur when failing to either node, or only to one of them. In other words, if you fail it back to the origional node, does it still give this error?

If not, verify that the files being accessed can be seen by both nodes.

April 5, 2006 at 9:07 am

Ah, I had a link to a resource for this as well.......

http://support.microsoft.com/default.aspx?scid=kb;en-us;322140

April 5, 2006 at 9:19 am

can you tell me which file are you referring to?

April 5, 2006 at 9:22 am

Try one of these:

In this case, try starting SQL Server Agent from the command prompt by running the following command:

Default Instance

Named Instance

If you receive the following error message

In this case, make sure that the MSSQLSERVER startup account, the SQL Server Agent startup account, and the Microsoft Distributed Transaction Coordinator (MS DTC) startup account have full control of the following keys in the registry:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSDTC

The following keys are for the default instance:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlset\Services\SQLSERVERAGENT

The following keys are for the named instance:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQL$<INSTANCE>

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlset\Services\SQLAgent$<INSTANCE>

April 5, 2006 at 9:46 am

Issue was that one the second node domain account under which sql server service runs was not part of the local admin group.

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

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

SQL Server Monitoring and Troubleshooting Simplified for DBAs with SQL Sentry

By: Jeremy Kadlec   |   Updated: 2024-02-12   |   Comments   |   Related: More > Performance Tuning

Our organization has business-critical overnight processes that start at 4:00 AM with various feeds into a SQL Server data warehouse used extensively across our organization for every client interaction. These overnight processes have numerous variables, including data volume, erroneous data, and performance issues (IO, Memory, CPU). Our entire company depends on this data for decision-making throughout the day and expects systems to be available by 8:00 AM for smooth business operations.

Unfortunately, there are times when the overnight processes fail, resulting in two or three hours of corrections before the SQL Server data warehouse is operational. This raises concerns across the entire organization and shines a negative light on the SQL Server DBAs. How can the DBA team better understand the performance in real time to address these issues and proactively ensure smooth business operations?

This is the exact situation that Abdul Rauf experienced working for an investment bank. Abdul said, "I think I was one of those proud DBAs. I don't need a performance monitoring solution. These tools get various metrics out of the DMVs and Windows. Why would I get a tool when I can do that myself?" He thought, "I'm not good if I use these tools."

Abdul did what typical DBAs would do to troubleshoot these issues—look at wait stats, IO metrics, determine which queries are running long, etc., based on scripts he has collected over the years. However, the reality was that the data collection and analysis process to find the issues took him 2 to 3 hours - hours when the business expected the SQL Server data warehouse to be operational to meet their customer needs. Whether the problem was related to parameter sniffing, out-of-date statistics, the need to rebuild indexes, or introducing new code, the organization suffered, increasing the already mounting pressure on the SQL Server DBAs.

From Hours to Minutes

Then, after attending a SQL event and influenced by industry leaders, Abdul had a change in mindset. He was convinced that moving from DIY (Do-It-Yourself) troubleshooting to proactive troubleshooting would reflect his maturity and confidence in his skill set. Abdul said, "Getting Sentry One literally changed my job from 3 hours of troubleshooting to 2 or 3 minutes to pinpoint where the problem occurred." That time savings is critical for DBAs because uptime is an unwritten expectation from the organization.

Abdul explained how he could quickly and easily get SQL Sentry up and running, get the evidence needed to decipher the issue, i.e., "see where the spike happened" in the SQL Sentry visual interface, and begin resolving the issue to meet the daily 8:00 AM deadline. Abdul said, "SQL Sentry literally saved me several hours - several hours that affected the entire business. I have been singing its praises ever since."

It Keeps Getting Better

As a by-product of using SQL Sentry, Abdul remarked, "Over time, batches got better and better. The recommendations were spot on and problems were less and less. This [SQL Sentry] really improved the overall performance." SQL Sentry was a trusted tool for DBAs to share information and help educate the Developers to prevent future performance situations that could impact the organization.

SQL Sentry Features

We have just scratched the surface of how SQL Sentry can save precious time for SQL Server DBAs. SQL Sentry can help your organization by:

  • Seamlessly collect SQL Server, VMWare, and Windows performance monitoring data 24x7x365 with an intuitive visual interface to understand the workload norm and performance anomalies.
  • Rapidly identify performance issues in minutes, saving hours for DBAs and minimizing the impact to the organization.
  • Holistic view of SQL Server – relational engine, business intelligence suite (SQL Server Analysis Services, Reporting Services, and Synapse Pools), on-premises and cloud platforms (Azure and AWS).
  • Easily understand the environment and instance health score with changes recorded over time.
  • Proactive alerting to address a performance issue before it bubbles up and impacts the entire organization.
  • Uncover common database issues – parameter sniffing, locking, blocking, deadlocks, poor performing T-SQL code, TempDB contention, wait statistics, etc.
  • Visualize SQL Server performance, AlwaysOn status, SQL Server Agent Jobs, and more.

Learn more about SQL Sentry features .

  • Learn more about SQL Sentry features for SQL Server DBAs and Developers.
  • Get your SQL Sentry free trial to find your biggest performance challenges.
  • Explore a public demo of the SQL Sentry Portal with SQL Server instances on-premises and in the cloud.
  • Best-of-class SQL Server Performance Monitoring and Alerting
  • Solving SQL Server Performance Issues for 18 Years and Counting
  • Get Database Insights Across Your Environment

MSSQLTips.com Case Study sponsored by SolarWinds, makers of SQL Sentry.

About the author

MSSQLTips author Jeremy Kadlec

Comments For This Article

sponsor

Fatih Acar's blog

About of Database Systems and Information Technologies

SQL Server Reporting Service Start Error 1053 The Service Did Not Respond

Reporting Server Error 1053: The service did not respond to the start or control request in a timely fashion.
1. Open regedit 2. Locate here : HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control 3. Change ServicesPipeTimeout value. If the ServicesPipeTimeout entry does not exist, you have to create it. You can follow add steps like below. Add Step 1: Below Control section Edit > New > DWORD Value. Add Step 2: Type ServicesPipeTimeout Add Step 3: Right-click ServicesPipeTimeout and click Modify . Add Step 4: Decimal 60000 , OK This value represents the time in milliseconds before a service times out. 4. Restart computer.

Email, RSS

Share this:

Leave a reply cancel reply.

Your email address will not be published. Required fields are marked *

Notify me of follow-up comments by email.

Notify me of new posts by email.

IMAGES

  1. SQL Server Agent Error 1053 (2 Solutions!!)

    sql server reporting services 1053

  2. Ashok Kumar SQL Development and DBA Adminstrations Techi Blog : Solving

    sql server reporting services 1053

  3. Sql Server Reporting Services List All Subscriptions

    sql server reporting services 1053

  4. SQL Server Reporting Services とは

    sql server reporting services 1053

  5. Grundlegendes zu den SQL Server Reporting Services

    sql server reporting services 1053

  6. SQL Server Reporting Services (SSRS) Tutorial for Beginners

    sql server reporting services 1053

VIDEO

  1. Publishing SQL Server 2008 R2 Reporting Services Reports

  2. SQLServer Reporting Services Part 2

  3. 3-SQL Server Reporting Service-SSRS

  4. Foglight

  5. Developing a Simple SQL Server 2008 Reporting Services Report

  6. Introduction To SQL Server Reporting Services (SSRS)

COMMENTS

  1. Reporting service configuration manager unable to start currect report

    Error 1053: The service did not respond to the start or control request in a timely fashion When I'm starting from reporting service configuration manager end. I'm getting below error. System.InvalidOperationException: Cannot start service SQLServerReportingServices on computer 'Name'.

  2. You cannot start SQL Server Reporting Services

    Method 1 Validate that boundary firewalls, router access rules, or downstream proxy servers allow systems that have update 2677070 installed to contact Microsoft Update.

  3. Reporting Server Error 1053: The service did not respond to the start

    1. Click Start, click Run, type regedit, and then click OK.. 2. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control . 3. In the right pane, locate the ServicesPipeTimeout entry. Note If the ServicesPipeTimeout entry does not exist, you must create it. To do this, follow these steps:

  4. Error 1053 SQL server

    Error 1053 SQL server occurs when attempting to pause or stop the SQL Server service in the Windows Services Console. Here at Bobcares, we have seen several such SQL related issues as part of our Server Management Services for web hosts and online service providers. Today we'll take a look at the cause for this error and how to fix it.

  5. Forum FAQ: How do I resolve the Reporting Server Error 1053: The

    Symptom Sometimes after applying a Security Hotix, Reporting Services failed to start with the error message, "Error 1053 is received: The service did not respond to the start or control request in a timely fashion". Solution The problem is usually caused by an incorrect timeout setting. To work around the issue, try the following steps: 1.

  6. [6 Solutions] 'Error: 1053. Service didn't respond in a ...

    Users experience the error message 1053 which states 'The service did not respond to the start or control request in a timely fashion'. This error message is the cause of a timeout that occurs after a request was initiated to start a service but it did not respond in the time window. 'Error: 1053. Service didn't respond in a timely fashion' Fix

  7. SQL Server Agent Error 1053

    Error 1053: The service did not respond to the start or control request in a timely fashion. I followed this link ( http://support.microsoft.com/kb/322140 ). The steps are not clear to me but I tried a few. When I run by using cmd as admin I get this error: The program can't start because sqlncli10.dll is missing from your computer.

  8. Errors and events reference (Reporting Services)

    The report server detected a possible denial of service attack. For more information, see Reporting Services security and protection. 113: Error: Logging: Report Server: The report server can't create a performance counter. 114: Error: Startup/Shutdown: web portal: The web portal can't connect to the Report Server service. 115: Warning: Scheduling

  9. ERROR 1053 : THE SERVICE DID NOT RESPOND TO THE START oR CONTROL

    ERROR 1053 : THE SERVICE DID NOT RESPOND TO THE START oR CONTROL REQEQUEST TIMLY FACHION ERROR REPORTING SERVICES ARE NOT STARTING · The SQL Server Reporting Services (MSSQLSERVER) service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion. · Hi Ganesh, if you using sql server ...

  10. SQL Server Reporting Services Service Start Timeout

    Error 1053: The service did not respond to the start or control request in a timely fashion. This problem is detailed here: http://support.microsoft.com/kb/2745448, and it's a result of the SSRS service checking for certificate revocation lists (CRL).

  11. Reporting Server Error 1053: The service did not respond to the start

    Reporting Server Error 1053: The service did not respond to the start or control request in a timely fashion Open a registry editor and go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control Edit or Create the following entry (This value represents the time in milliseconds before a service times out.) Name : ServicesPipeTimeout

  12. SQL Server Reporting Services (MSSQLSERVER)

    Solution This problem may be related to system performance and configuration issues. The recommended action is to not protect this service. However, if it must be protected, the following registry setting will extend the time available for services to start.

  13. Install SQL Server Reporting Services

    Select Install Reporting Services. Choose an edition to install and then select Next. For a free edition, choose either Evaluation or Developer from the drop-down. Otherwise, enter a product key. Find the product key for SQL Server Reporting Services. Read and agree to the license terms and conditions and then select Next.

  14. SQL SSRS suddenly stopped working.

    When trying to start the service manually, I get this error message: "windows could not start sql server reporting services error 1053" I have tried extending the time out period as suggested but that did not help.

  15. SQL Server 2005 and Windows 8.1

    In this case, make sure that the specified SQLServerAgent service account has full control permissions to the folder in which the SQLAgent.out, SQLAgent.1, SQLAgent.2, and other SQL Server files are located. These files are typically stored in the LOG folder, which is in the SQL Server installation path. -

  16. Windows could not start the SQL Server (SQLEXPRESS) service on local

    Error 1053: The service did not respond to the start or control request in a timely fashion I have Googled and visited many other sites. I have tried following: changed Account permission to Local System Account and no luck. uninstalled and re-installed: no luck. checked the port in Client Protocols and it is set 1433.

  17. Error 1053 when try to start MSSQLServer Service

    #112470 I have a two node cluster. When I try to failover from active node which is node2 to node1 I get the following errors in the event viewer/ system logs The MSSQLSERVER service failed to...

  18. SQL server service start error 1053

    Error 1053: The service did not respond to the start or control request in a timely fashion." also this error in event viewer Timeout (30000 milliseconds) waiting for the SQL Server (MSSQLSERVER) service to connect. Jeff_1 Saturday, March 3, 2012 6:41 AM Sign in to vote Here is the solution

  19. Server 2012 R2

    SQL Server Developer Center. Sign in. United States (English) Brasil (Português) Česko (Čeština) Deutschland (Deutsch) España (Español) France (Français) Indonesia (Bahasa) Italia (Italiano) România (Română) Türkiye (Türkçe) Россия (Русский) ישראל (עברית) المملكة العربية ... SQL Server Reporting ...

  20. windows

    To debug the startup of your service, add the following to the top of the OnStart() method of your service:. while(!System.Diagnostics.Debugger.IsAttached) Thread.Sleep(100); This will stall the service until you manually attach the Visual Studio Debugger using Debug -> Attach to Process...

  21. SQL Server Monitoring and Troubleshooting Simplified for DBAs

    Holistic view of SQL Server - relational engine, business intelligence suite (SQL Server Analysis Services, Reporting Services, and Synapse Pools), on-premises and cloud platforms (Azure and AWS). Easily understand the environment and instance health score with changes recorded over time.

  22. SQL Server Reporting Service Start Error 1053 The Service Did Not

    Reporting Server Error 1053: The service did not respond to the start or control request in a timely fashion. Solution regedit 2. Locate here : HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control ServicesPipeTimeout value. ServicesPipeTimeout entry does not exist, you have to create it. You can follow add steps like below.