SQL Server 2008 R2 error
-
Wednesday, November 23, 2011 1:16 PM
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 ....
All Replies
-
Thursday, November 24, 2011 9:06 AMModerator
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 2:44 PMIric, it works, thanks in advance!
