none
SQL Server 2008 R2 error

    Question

  • Hi,

    I have a Windows Server 2003 Enterprise 64bit (SP2) Cluster with 2 SQL Server 2005 Instances in an Active/Passive configuration.

    I have installed new instance of SQL Server 2008 R2 on same Cluster in separate service group. SQL 2008 R2 is running fine then I m going to move both 2005 instances to this node cluster services and disk come online except sql services and getting below errors :

     

    pls help me ...

     

    ERROR-1

     

    Event Type:      Error

    Event Source:   MSSQL$ECSQLV

    Event Category: (3)

    Event ID:          19019

    Date:                9/8/2011

    Time:                8:51:34 AM

    User:                N/A

    Computer:         ESQL1

    Description:

    [sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 2; message = [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

     

     

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: 4b 4a 00 40 01 00 00 00   KJ.@....

    0008: 0a 00 00 00 45 00 43 00   ....E.C.

    0010: 53 00 51 00 4c 00 56 00   S.Q.L.V.

    0018: 53 00 30 00 32 00 00 00   S.0.2...

    0020: 00 00 00 00               ....   

     

     

    ERROR-2

     

    Event Type:      Error

    Event Source:   MSSQL$ECSQLV

    Event Category: (3)

    Event ID:          19019

    Date:                9/8/2011

    Time:                8:51:34 AM

    User:                N/A

    Computer:         ESQL1

    Description:

    [sqsrvres] ODBC sqldriverconnect failed

     

     

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: 4b 4a 00 40 01 00 00 00   KJ.@....

    0008: 0a 00 00 00 45 00 43 00   ....E.C.

    0010: 53 00 51 00 4c 00 56 00   S.Q.L.V.

    0018: 53 00 30 00 32 00 00 00   S.0.2...

    0020: 00 00 00 00               ....   

     

     

     

     

    ERROR-3

     

     

    Event Type:      Error

    Event Source:   MSSQL$ECSQLV

    Event Category: (3)

    Event ID:          19019

    Date:                9/8/2011

    Time:                8:51:34 AM

    User:                N/A

    Computer:         ESQL1

    Description:

    [sqsrvres] checkODBCConnectError: sqlstate = HYT00; native error = 0; message = [Microsoft][SQL Server Native Client 10.0]Login timeout expired

     

     

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: 4b 4a 00 40 01 00 00 00   KJ.@....

    0008: 0a 00 00 00 45 00 43 00   ....E.C.

    0010: 53 00 51 00 4c 00 56 00   S.Q.L.V.

    0018: 53 00 30 00 32 00 00 00   S.0.2...

    0020: 00 00 00 00               ....   

     

     

     

    ERROR-4

     

     

    Event Type:      Error

    Event Source:   MSSQL$ECSQLV

    Event Category: (3)

    Event ID:          19019

    Date:                9/8/2011

    Time:                8:51:34 AM

    User:                N/A

    Computer:         ESQL1

    Description:

    [sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 2; message = [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2].

     

     

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: 4b 4a 00 40 01 00 00 00   KJ.@....

    0008: 0a 00 00 00 45 00 43 00   ....E.C.

    0010: 53 00 51 00 4c 00 56 00   S.Q.L.V.

    0018: 53 00 30 00 32 00 00 00   S.0.2...

    0020: 00 00 00 00               ....   

    Wednesday, November 23, 2011 1:16 PM

Answers

  • Hi Hallow1,
    It seems that your cluster service is not able to connect with Clustered Named instance of SQL Server. Please use –c parameter to check when your SQL Browser is running, the results should like below:

    SQLBrowser: starting up in console mode                                                                                                   

    SQLBrowser: starting up SSRP redirection service                                                                                        

    SQLBrowser is successfully listening on 0.0.0.0[1434]
    We found that the SsrpListener key was 0
    Path Of The Registry SsrpListener Key :
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\90\SQL Browser (x64 Machines)
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\SQL Browser (x86 Machines)
    After we changed value to 1 and restarted the browser service we were getting the response as expected.
    We stopped the browser service from the command prompt and then started it from services console and then we were able to bring the SQL Server Services online.


    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Edited by Iric WenModerator Thursday, November 24, 2011 9:06 AM
    • Marked as answer by hallow1 Thursday, November 24, 2011 2:43 PM
    Thursday, November 24, 2011 9:06 AM
    Moderator

All replies

  • Hi Hallow1,
    It seems that your cluster service is not able to connect with Clustered Named instance of SQL Server. Please use –c parameter to check when your SQL Browser is running, the results should like below:

    SQLBrowser: starting up in console mode                                                                                                   

    SQLBrowser: starting up SSRP redirection service                                                                                        

    SQLBrowser is successfully listening on 0.0.0.0[1434]
    We found that the SsrpListener key was 0
    Path Of The Registry SsrpListener Key :
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\90\SQL Browser (x64 Machines)
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\SQL Browser (x86 Machines)
    After we changed value to 1 and restarted the browser service we were getting the response as expected.
    We stopped the browser service from the command prompt and then started it from services console and then we were able to bring the SQL Server Services online.


    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Edited by Iric WenModerator Thursday, November 24, 2011 9:06 AM
    • Marked as answer by hallow1 Thursday, November 24, 2011 2:43 PM
    Thursday, November 24, 2011 9:06 AM
    Moderator
  • Iric, it works, thanks in advance!
    Thursday, November 24, 2011 2:44 PM