none
The request failed or the service did not respond in a timely fashion. Consult the event log or other application error logs for details.

    Question

  • Hi,

               Actually i have installed SQL Server 2008 R2 on XP Pro SP3 it works fine after instaling first time but when i restarted my pc SQL Server Service didn't restarted and so i tried to restart that manuly by clicking start in Sql Server Configuration Manager at that it gave this error "The request failed or the service did not respond in a timely fashion. Consult the event log or other application error logs for details."

     

    I tried to repair it again but it doesent resolved .So i Uninstalled it SQL Server 2008 R2 and all its shared tools and installed it again but nothing changed it again gave me the same problem as in 1st instalation after restating maching.

          Any idea! Where i am going wrong?.

    i got this thing in Event log of Application

    Event 1

    "FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\transport.mdf'. Diagnose and correct the operating system error, and retry the operation."

    Event 2

    "FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\tempdb.mdf'. Diagnose and correct the operating system error, and retry the operation."

    Event 3

    "FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\tempdb.mdf'. Diagnose and correct the operating system error, and retry the operation."

    Event 4

    "FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\ReportServerTempDB.mdf'. Diagnose and correct the operating system error, and retry the operation."

    Event 5

    FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\ReportServer.mdf'. Diagnose and correct the operating system error, and retry the operation.

    Event 6

    FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf'. Diagnose and correct the operating system error, and retry the operation.

     

    Thank you So much for replying

    Monday, August 23, 2010 6:43 AM

Answers

  • Hi Magnum,

    Based on the error message, the main reason might be the SQL Server Database startup process failed.

    States of this issue:

    Before any SQL Server database can be used, the database needs to be started. The database startup process involves initializing various data structures that represent the database and the database files, opening all the files that belong to the database, and finally performing recovery on the database.

    Here are some suggestions:

    1.    About Error 17826, make sure that you have disabled the VIA protocol.

    2.    About Error 17207, check the database path. Make sure that you have specified the correct path and didn’t locate the database such as tempdb.mdf that involved in the error message into other location from the folder 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA’

    If this didn’t helpful, please see http://support.microsoft.com/kb/2015754 for more details about this issue.

    If there are any results, please feel free to let me know.

    Thanks,

    WeiLin Qiao

     

     

     

    Tuesday, August 24, 2010 7:40 AM
    Moderator

All replies

  • Hi,

               Actually i have installed SQL Server 2008 R2 on XP Pro SP3 it works fine after instaling first time but when i restarted my pc SQL Server Service didn't restarted and so i tried to restart that manuly by clicking start in Sql Server Configuration Manager at that it gave this error "The request failed or the service did not respond in a timely fashion. Consult the event log or other application error logs for details."

     

    I tried to repair it again but it doesent resolved .So i Uninstalled it SQL Server 2008 R2 and all its shared tools and installed it again but nothing changed it again gave me the same problem as in 1st instalation after restating maching.

          Any idea! Where i am going wrong?.

    i got this thing in Event log of Application

    Event 1

    "FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\transport.mdf'. Diagnose and correct the operating system error, and retry the operation."

    Event 2

    "FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\tempdb.mdf'. Diagnose and correct the operating system error, and retry the operation."

    Event 3

    "FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\tempdb.mdf'. Diagnose and correct the operating system error, and retry the operation."

    Event 4

     

    "FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\ReportServerTempDB.mdf'. Diagnose and correct the operating system error, and retry the operation."

    Event 5

    FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\ReportServer.mdf'. Diagnose and correct the operating system error, and retry the operation.

    Event 6

    FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf'. Diagnose and correct the operating system error, and retry the operation.

     

    Thank you So much for replying


    Hi for more clearity i am posting error log of SQL Server as below;

     

    "2010-08-23 12:22:37.39 Server      Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
     Jul  9 2008 14:43:34
     Copyright (c) 1988-2008 Microsoft Corporation
     Enterprise Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

    2010-08-23 12:22:37.39 Server      (c) 2005 Microsoft Corporation.
    2010-08-23 12:22:37.39 Server      All rights reserved.
    2010-08-23 12:22:37.39 Server      Server process ID is 676.
    2010-08-23 12:22:37.39 Server      Authentication mode is MIXED.
    2010-08-23 12:22:37.39 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
    2010-08-23 12:22:37.39 Server      This instance of SQL Server last reported using a process ID of 1440 at 8/23/2010 12:21:44 PM (local) 8/23/2010 6:51:44 AM (UTC). This is an informational message only; no user action is required.
    2010-08-23 12:22:37.39 Server      Registry startup parameters:
      -d C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf
      -e C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG
      -l C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
    2010-08-23 12:22:37.45 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2010-08-23 12:22:37.45 Server      Detected 2 CPUs. This is an informational message; no user action is required.
    2010-08-23 12:22:38.39 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
    2010-08-23 12:22:38.48 Server      Node configuration: node 0: CPU mask: 0x00000003 Active CPU mask: 0x00000003. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2010-08-23 12:22:38.53 spid7s      Starting up database 'master'.
    2010-08-23 12:22:38.54 spid7s      Error: 17207, Severity: 16, State: 1.
    2010-08-23 12:22:38.54 spid7s      FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error 6(The handle is invalid.) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf'. Diagnose and correct the operating system error, and retry the operation.
    2010-08-23 12:22:38.68 spid7s      Resource governor reconfiguration succeeded.
    2010-08-23 12:22:38.68 spid7s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.
    2010-08-23 12:22:38.68 spid7s      SQL Server Audit has started the audits. This is an informational message. No user action is required.
    2010-08-23 12:22:38.70 spid7s      FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
    2010-08-23 12:22:38.73 spid7s      SQL Trace ID 1 was started by login "sa".
    2010-08-23 12:22:38.73 spid7s      Starting up database 'mssqlsystemresource'.
    2010-08-23 12:22:38.76 spid7s      The resource database build version is 10.00.1600. This is an informational message only. No user action is required.
    2010-08-23 12:22:38.96 spid10s     Starting up database 'model'.
    2010-08-23 12:22:38.98 spid7s      Server name is 'MUKESH'. This is an informational message only. No user action is required.
    2010-08-23 12:22:39.00 spid10s     Error: 17207, Severity: 16, State: 1.
    2010-08-23 12:22:39.00 spid10s     FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\model.mdf'. Diagnose and correct the operating system error, and retry the operation.
    2010-08-23 12:22:39.18 spid10s     Clearing tempdb database.
    2010-08-23 12:22:39.42 Server      A self-generated certificate was successfully loaded for encryption.
    2010-08-23 12:22:39.45 Server      Error: 26024, Severity: 16, State: 1.
    2010-08-23 12:22:39.45 Server      Server failed to listen on 'any' <ipv4> 1433. Error: 0x2726. To proceed, notify your system administrator.
    2010-08-23 12:22:39.45 Server      Error: 17182, Severity: 16, State: 1.
    2010-08-23 12:22:39.45 Server      TDSSNIClient initialization failed with error 0x2726, status code 0xa. Reason: Unable to initialize the TCP/IP listener. An invalid argument was supplied.

    2010-08-23 12:22:39.45 Server      Error: 17182, Severity: 16, State: 1.
    2010-08-23 12:22:39.45 Server      TDSSNIClient initialization failed with error 0x2726, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. An invalid argument was supplied.

    2010-08-23 12:22:39.45 Server      Error: 17826, Severity: 18, State: 3.
    2010-08-23 12:22:39.45 Server      Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
    2010-08-23 12:22:39.45 Server      Error: 17120, Severity: 16, State: 1.
    2010-08-23 12:22:39.45 Server      SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
    2010-08-23 12:22:39.57 spid13s     A new instance of the full-text filter daemon host process has been successfully started.
    2010-08-23 12:22:39.60 spid10s     Error: 17207, Severity: 16, State: 1.
    2010-08-23 12:22:39.60 spid10s     FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\tempdb.mdf'. Diagnose and correct the operating system error, and retry the operation.
    "

    Monday, August 23, 2010 6:56 AM
  • Monday, August 23, 2010 7:52 AM
    Answerer
  • Hi, first off all thanks for replying.

    Actually the link mentioned is not useful for me as every time when i install new Setup it'll come back according to me it would be problem of my Operating System

    Thanks,

    Magnum

    Monday, August 23, 2010 9:16 AM
  • Please contact CSS to help you troubleshoot this issue.

    Reference:

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;970878


    This posting is provided "AS IS" with no warranties, and confers no rights.
    My Blog: http://troubleshootingsql.wordpress.com
    Twitter: @banerjeeamit
    SQL Server FAQ Blog on MSDN: http://blogs.msdn.com/sqlserverfaq
    Monday, August 23, 2010 12:14 PM
  • Hi Magnum,

    Based on the error message, the main reason might be the SQL Server Database startup process failed.

    States of this issue:

    Before any SQL Server database can be used, the database needs to be started. The database startup process involves initializing various data structures that represent the database and the database files, opening all the files that belong to the database, and finally performing recovery on the database.

    Here are some suggestions:

    1.    About Error 17826, make sure that you have disabled the VIA protocol.

    2.    About Error 17207, check the database path. Make sure that you have specified the correct path and didn’t locate the database such as tempdb.mdf that involved in the error message into other location from the folder 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA’

    If this didn’t helpful, please see http://support.microsoft.com/kb/2015754 for more details about this issue.

    If there are any results, please feel free to let me know.

    Thanks,

    WeiLin Qiao

     

     

     

    Tuesday, August 24, 2010 7:40 AM
    Moderator
  • Hey thanks for Reply.

    Thanks,

    Magnum

    Tuesday, August 24, 2010 12:01 PM
  • Hi Thanks for your suggestions i'll try these all and revert you back.

     

    Thanks,

    Magnum

    Tuesday, August 24, 2010 12:03 PM
  • Thanks, it worked.
    .Net Developer
    Monday, September 20, 2010 9:42 AM
  • Hello, I have tried everything but I am still facing the issue. Please help me out.
    Monday, May 02, 2011 6:23 AM
  • Got the same "The request failed or the service did not respond in a timely fashion" problem once I tried to restart. Got resolved by disabling VIA protocol going through SERVER CONFIGURATION MANAGER--->SQL SERVER NETWORK CONFIGURATION-->PROTOCOLS FOR MSSQLSERVER-->VIA--> DISABLED

    Thanks!

    Monday, May 16, 2011 10:02 AM
  • Got the same "The request failed or the service did not respond in a timely fashion" problem once I tried to restart. Got resolved by disabling VIA protocol going through SERVER CONFIGURATION MANAGER--->SQL SERVER NETWORK CONFIGURATION-->PROTOCOLS FOR MSSQLSERVER-->VIA--> DISABLED

    Thanks!

    This is the solution

     

    Thanks

    • Proposed as answer by Brics Thursday, November 03, 2011 2:19 AM
    Sunday, June 12, 2011 9:34 PM
  • If Following Service Start to used this Solution

     

     

    SQL Server (MSSQLSERVER) 

                    Go To run

    1)      Type services.msc

    2)      Right Click On Service:- SQL Server (MSSQLSERVER)

    3)      Properties : -Click Log On Tab  

    4)      Click on Radio button :- Local System account  & start this services it work  fine 

     

    SQL Server Agent (MSSQLSERVER)

                    Go To run

    1)      Type services.msc

    2)      Right Click On Service:- SQL Server Agent (MSSQLSERVER)

    3)      Properties : -Click Log On Tab

    4)      Click on Radio button :- Local System account  & start this services it work  fine

     

    SQL Server Analysis Services (MSSQLSERVER)

                    Go To run

    1)      Type services.msc

    2)      Right Click On Service:- SQL Server Analysis Services (MSSQLSERVER)

    3)      Properties : -Click Log On Tab

    4)      Click on Radio button :- Local System account  & start this services it work  fine


    Wednesday, September 14, 2011 4:21 AM
  • Hi guys,

    I manage to get this error after i reboot my server. But the thing that I did was:

    DISABLE VIA in SQL NETWORK PROTOCOL CONFIGURATION.

    CHow...

    • Proposed as answer by Brics Thursday, November 03, 2011 2:18 AM
    Thursday, November 03, 2011 2:18 AM
  • Thanks a ton it work for me, not sure what was the issue, but i did change the administrator password few days back(all the while it was working file for me) but today i enable a START STOP task which was in scheduler.. thanks again.
    Monday, May 07, 2012 5:48 PM
  • Properties in the logon tabe   Change SQL browser password
    • Edited by Kaleem Ali Wednesday, May 16, 2012 8:07 AM
    Wednesday, May 16, 2012 8:07 AM
  • Well, I had the same problem, but when I looked at the profile I noticed that there was another instance of SQL Server running on this and I stopped and so began my work.

    Osmair Marangne

    Wednesday, June 27, 2012 5:11 PM
  • Got the same "The request failed or the service did not respond in a timely fashion" problem once I tried to restart. Got resolved by disabling VIA protocol going through SERVER CONFIGURATION MANAGER--->SQL SERVER NETWORK CONFIGURATION-->PROTOCOLS FOR MSSQLSERVER-->VIA--> DISABLED

    Thanks!

    thanks ....!
    Saturday, October 13, 2012 10:24 PM