September 19, 2011 at 9:08 am
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 ....
September 19, 2011 at 10:17 am
check for further info in the cluster.log
This is located in C:\Windows\Cluster or C:\Winnt\cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply