Upgrading SQL Server 2000 Cluster To SQL Server 2005 Cluster
May 14, 2008
Friends -
Need your help and guidence for doing upgrading SQL Server 2000 Cluster to SQL Server 2005 Cluster.
Let me explain my current environment.
1. Currently SQL Server 2000 Cluster environment is running on Windows 2000 Server we need to upgrade this to SQL Server 2005 on Windows 2003 Server. >>> Production environment.
My Plans:
1. On Testing Environment Install SQL Server 2000 cluster on Windows 2003 Server and do a restore of databases from the produciton environment.
2. Upgrade In-Place from SQL Server 2000 Cluster to SQL Server 2005 Cluster.
My doubts
1. Can i install SQL Server 2000 Cluster on Windows 2003 Server. Is it possible or not.
Please advise me and correct my steps.
Cheers
VSH
View 1 Replies
ADVERTISEMENT
Dec 28, 2007
We're upgrading a SQL Server 2000 cluster (Active/Passive) running on Windows 2000 Server to a SQL Server 2005 Cluster running on Windows Server 2003. We can't purchase new hardware and we have no spare hardware. We also need to move from Windows 2000 Server to Windows 2003 Server at the same time. We want to keep downtime to a bare minimum.
What we were thinking was the following steps... Anyone try this?
1. Break the link between the servers.
2. Install a fresh copy of windows 2003 server on one side along with SQL Server 2005. While this step is running, the active node would still be live on Windows 2000 Server and SQL Server 2000 serving our customers.
3. Restore a copy of a backup from the active production side to the node we're upgrading and at that point we would bring the active node down, switching the active node to be the newly upgraded server.
4. As a final step, the old active node would now have the link to it broken, we would install a fresh copy of windows 2003 server on it and sql server 2005. At this point we would bring it back into the cluster and the cluster would be complete again.
Thoughts?
View 2 Replies
View Related
May 15, 2008
Friends -
Could any one of you provide steps for upgrading SQL Server 2000 cluster to SQL server 2005 cluster.
My environment is Windows 2003 server.
Appreciate your support.
Cheers
VSH
View 1 Replies
View Related
May 8, 2007
Hi
We are planning to upgrade the SQL Server in our production environment from SQL Server 2000 to SQL Server 2005. This is a 4 Node cluster environment with 3 Databases on 3 Virtual instances. The main requirement is to achieve this with no/minimal downtime.
Could you please suggest or direct me to any documentation for the best practices used to upgrade such an environment?
Thanks
Priyanka
View 2 Replies
View Related
Mar 26, 2008
We have 2 SQL servers in a failover cluster environment. SQL1 and SQL2. Currently SQL1 is the primary in the cluster, and we need to upgrade from Service Pack 3 to Service Pack 4.
Our setup:
Both servers are Windows 2003 Server Enterprise Edition.
Both servers have SQL Server 2000 Service Pack 3.
My question is:
Which upgrade plan do I take? Do I:
1. Upgrade the backup (offline) server in the cluster (SQL2) first, reboot, then failover from SQL1 to SQL2? Then do the other server?
2. Upgrade the primary (online) server in the cluster (SQL1) first and see if it replicates to the backup?
Any advice or tips would be most appreciated.
Thanks.
View 6 Replies
View Related
Jun 6, 2002
We shall be taking a bunch of 7.0 instances and moving/upgrading to a SQL 2000 cluster server. I was thinking of creating new named instances on the 2000 cluster and upgrading each 7.0 server to it's respective named instance. Also thought of using the 2000 copy database wizard; I was told this didn't always work. Anyone hear of problems with this?
Thanks
View 2 Replies
View Related
Mar 30, 2004
I am currently running an active/passive cluster NT4 with SQL7 clustered. I am trying to upgrade SQL to a clustered 2000 version. I have a san disk area allocated as a Z: drive. These are the following steps I have taken:
1. Used cluster wizard to uncluster the SQL 7 instance.
2. Using the SQL 2000 Enterprise cd created a new virtual server (with the same IP address and name as the previous SQL 7 server) I have left the install as a default instance.
3. Part way through the install I am asked to browse to the data area. The data area is Z:mssql7data.
On completion of the install I now have the following data path Z:mssql7datamssqldata and all the databases are still SQL7 databases.
My questions are:
How can I get the install to update/convert the databases to SQL 2000 as it doesnt seem to recognise them?
Will the install always suffix the data path with mssqldata
Any assistance appreciated.
View 1 Replies
View Related
Oct 20, 2007
Hello SQL pro's,
I have a SQL 2005 cluster using 2 HP DL 380 32bit servers connected to an HP MSA500 disk pack via SCSI. I need to upgrade the servers to 64 bit but I am still going to use 32 bit windows server.
My question is, has any tried this before? If so, will it work and what is the best way to go about it. Should I take down the secondary SQL server, then replace it, then add it to the cluster, then fail over to it, then replace the other?
Any information is greatly appreciated.
Dan
View 1 Replies
View Related
Aug 14, 2006
I have upgraded our test server and on non cluster production machine. My next server is a cluster and I don't have a test cluster server. Do I upgrade the active node and that is all or am I going to need to fail it over and upgrade the other node.
Also the prerequesite for the upgrade advisor is .net 2.0 I am going to up that on each server one at a time but I am only going to add the upgrade advisor to one node is that ok.
I read the SP1 documentation and it clearly states only patch the active node and do not patch the inactive nodes.
View 1 Replies
View Related
Apr 20, 2006
Can multiple SQL instances (sql server 2000 and sql server 2005) be clustered in an active/active environment?
Thank you.
View 7 Replies
View Related
Sep 14, 2007
Could someone give me an ideal of what it takes to upgrade the memory in my cluster. Is it as easy has upgrading the passive node, switching the nodes, then upgrading the other server. And do I need to re-configure the windows cluster. And will both server need to be down at the same time at any point.
Or is their more to the process? Thanks for any assistance.
btw, I currently have 16mb of RAM in each node.
View 3 Replies
View Related
Feb 18, 2014
I´ve been reading that SQL Server 2012 Always On is dependent on having a Windows Failover Cluster setup. Is that correct ?
View 6 Replies
View Related
Jun 10, 2015
I am in the process of moving databases from a SQL 2005 Standard version to a 2-node 2014 cluster.All of my 2005 databases back up successfully.They all restore without issue except for one database that has a full text catalog. I get this message
Msg 7610, Level 16, State 1, Line 2
Access is denied to "fileStoragedataMSSQLSERVERFullTextCatalog", or the path is invalid.
Msg 3156, Level 16, State 50, Line 2
File 'sysft_FTCatalog' cannot be restored to 'fileStoragedataMSSQLSERVERFullTextCatalog'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 2
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
[code]....
I went as far as giving the folder full access to everyone temporarily and received the same error.
View 1 Replies
View Related
Jul 20, 2005
Hi,I need manuals, tecnical papres, instalation guide, etc abouthow to install one cluster sql server 2000 64 bits withwindows server 2003.It`s posible a need one document step by step about thisThanks,RaulGZ.
View 1 Replies
View Related
Jul 4, 2007
I have two Windows 2000 servers (Advance Edition) to form a Windows Cluster. I also install MS SQL 2000 Enterprise Edition on the cluster to form a MS SQL cluster. Now, I want to upgrade the hardware and OS (but keep on using SQL 2000), so I install Windows 2003 server Enterprise Edition on two new servers to form a new Windows Cluster. I am planing to install MS SQL 2000 Enterprise Edition on the new cluster, so the old SQL cluster and new SQL cluster are side by side. I would like to know how to setup a new SQL cluster (I know it has problem to rename SQL Cluster name, so how to fix this problem)? And how to transfer everything (such as system databases, users database, sql user account, password and maintenance plan jobs etc) from old SQL cluster to new SQL cluster? And how to switch over from old SQL cluster to new SQL cluster?
Thanks a lot !
View 8 Replies
View Related
Jan 29, 2008
Hi, could someone tell me if this configuration is possible?
Machine A: Instance 1 (ACTIVE) + Instance 2 (passive) + Instance 3 (pasive)
Machine B: Instance 1 (passive) + Instance 2 (ACTIVE) + Instance 3 (pasive)
Machine C: Instance 1 (passive) + Instance 2 (passive) + Instance 3 (ACTIVE)
I know that it is possible with 2 machines with the clasical solution of Machine1: active-passive, Machine2: passive-active, this way if one of the machines goes down the other one will take the job of both instances, but I dont know if this solution is possible in SQL server 2000 with 3 instances at the same time.
Help please? thanks
View 3 Replies
View Related
Apr 2, 2008
We're upgrading a SQL Server 2000 cluster (Active/Passive) running on Windows 2003 Server 32 - bit Standard to a SQL Server 2005 Cluster running on Windows Server 2003 64-bit Enterprise. Our existent cluster's databases are residing on SAN. We can't purchase new hardware and we have no spare hardware. We also need to move from Windows 2003 32-bit Server to Windows 2003 64-bit Enterprise Server at the same time. We want to keep downtime to a bare minimum.
What we were thinking was the following steps... Anyone try this?
1. Break the link between the servers. Or should we just evict the passive node?
2. Install a fresh copy of windows 2003 64-bit server on one side along with SQL Server 2005. While this step is running, the active node would still be live on Windows 2003 32-bit Server and SQL Server 2000 serving our customers.
3. Bring the active server down.
4. Create new cluster on the newly upgraded server and assign the same cluster name and IP as the original one.
5 Bring the luns from SAN to the newly upgraded server and initialize SQL Upgrade
6. As a final step, the old active node will be rebuilt, we would install a fresh copy of windows 2003 64 - bit server on it and sql server 2005. At this point we would bring it back into the cluster and the cluster would be complete again.
Thoughts?
View 1 Replies
View Related
Jul 17, 2000
I am trying to upgrade a SQL Server 6.5(Cluster) to SQL Serevr 7.0 (Cluster)..I already have an intsllation of 7.0(On a Cluster),so this means that 6.5 and sql 7 are on seperate cluster's ,if i try to upgrade from 6.5 Cluster to 7.0 Cluster is asks me to uncluster 6.5 and 7.0 is this correct ,assume i cannot break the cluster then what???.. what is the best way i can achieve this functinality.....
thanks in advance
Jack
View 1 Replies
View Related
Dec 10, 2006
Hi,
We have a new failover cluster (Windows 2003 SP1, Microsoft SQL 2000 SP4) with each node of the cluster hosting 7 SQL Server instances in a 2-node active-active configuration connected to a SAN. We are planning to move some SQL Server Instances(from existing stand-alone servers) into this Cluster. Any insight into the process of moving SQL Servers into the cluster would be highly appreciated.
Best Regards,
Himansu
View 4 Replies
View Related
Nov 8, 2001
Hey guys,
Lately we have come across a problem where our application is undergoing some extreme load against the SQL 2000 server database we have setup, where the server is hitting 100% CPU utilization each time. Currently the box is a 2 processor box.
Here is the question I have. I have seen under most SQL Server clusters that an active/passive setup is implemented. Where the passive server just exists as a failover mechanism. What I am looking for is some information on how to setup active/active setup where each server receives processes to handle.
Has anyone created a setup like this? Are there any standard benchmarking tools that can be used to see how this configuration increases performance? Is this setup more favorable than going to a 4 processor server as oppossed to our current 2 processor server?
BTW: We have noticed that after a web application where the user sits idle for a while the SQL Server application loses the connection with the application user...Is this the SQL Timeout causing the connection to disconnect?
Thanx for any response...
Bri
View 1 Replies
View Related
Jun 24, 2008
Friends -
Currently we are using SQL Server 2000 Cluster (Active/Active) on windows 2000 advance server.
This cluster contains two nodes.
Is it possible to add another two nodes on the existing cluster, please provide me steps or any link.
Appreciate your support
Cheers:)
satish
View 1 Replies
View Related
Sep 13, 2006
I have a production failover cluster running SQL Server 2000 at SP3that I want to upgrade to SP4. I do not have a test failover clusterto test with so I need the install on the primary server to work thefirst time. Per the information I have I just install the patch on theprimary server and it will install both on the primary and on thesecondary.However, I remember when I did the initial install and it failed. Thefirst problem traced to the fact that the install uses temporary filesunder the profile of the installing administrator and the id had neverlogged into the second server so the install failed on creating thetemporary file. The was a second problem that related to an OS featurethat had to be off for the install to work.If anyone out there has done this upgrade and remembers encountering aproblem and its fix/workaround I would appreciate a head up warning.Thank you-- Mark D Powell --
View 1 Replies
View Related
Nov 5, 2007
We have a sql2000 clustered server running on a windows 2003 cluster, today we noticed that the
SQL resources where in a Online Pending state and do not came up anymore.
I have searched the net and found some info about the sqlstate = 08001 Native error 11 , witch indicated that the SQL Network name could have been renamed , however this is not the case here , .
i also found that there might be Resolve issue but The Cluster Name and the SQL Network name can be resolved by both Cluster nodes ..
does anyone here got experience with this kind of problem ? Pls Help
Here is a part of the cluster.log with the errors :
ERR SQL Server : [sqsrvres] ODBC sqldriverconnect failed
ERR SQL Server : [sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 11; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
ERR SQL Server : [sqsrvres] ODBC sqldriverconnect failed
ERR SQL Server : [sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 2; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
ERR SQL Server : [sqsrvres] ODBC sqldriverconnect failed
ERR SQL Server : [sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 11; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
ERR SQL Server : [sqsrvres] ODBC sqldriverconnect failed
ERR SQL Server : [sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 2; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
INFO [CP] CppRegNotifyThread checkpointing key SOFTWAREMicrosoftMicrosoft SQL ServerDBHSBMSSQLSERVER to id 4 due to timer
INFO [Qfs] QfsGetTempFileName C:DOCUME~1SRVCCL~1LOCALS~1Temp, CLS, 13 => C:DOCUME~1SRVCCL~1LOCALS~1TempCLSD.tmp, status 0
According to the SQL server log the server is started and all databases are brought on-line then a stop request from Service Control Manager terminates SQL Server see log below:
2007-11-05 14:04:02.89 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: )
2007-11-05 14:04:02.89 server Copyright (C) 1988-2002 Microsoft Corporation.
2007-11-05 14:04:02.89 server All rights reserved.
2007-11-05 14:04:02.89 server Server Process ID is 3264.
2007-11-05 14:04:02.89 server Logging SQL Server messages in file 'P:mssqlMSSQL$DBHSBlogERRORLOG'.
2007-11-05 14:04:02.89 server SQL Server is starting at priority class 'high'(2 CPUs detected).
2007-11-05 14:04:03.61 server initdata: Warning: Could not set working set size to 823168 KB.
2007-11-05 14:04:03.66 server SQL Server configured for thread mode processing.
2007-11-05 14:04:03.72 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2007-11-05 14:04:03.77 server Attempting to initialize Distributed Transaction Coordinator.
2007-11-05 14:04:06.32 spid2 Starting up database 'master'.
2007-11-05 14:04:06.52 spid2 Server name is 'HSBSQL01DBHSB'.
2007-11-05 14:04:06.52 spid5 Starting up database 'msdb'.
2007-11-05 14:04:06.52 spid6 Starting up database 'model'.
2007-11-05 14:04:06.52 spid8 Starting up database 'dbHSB'.
2007-11-05 14:04:06.52 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2007-11-05 14:04:06.56 server SQL server listening on 10.122.131.103: 1433.
2007-11-05 14:04:06.62 spid8 Analysis of database 'dbHSB' (7) is 100% complete (approximately 0 more seconds)
2007-11-05 14:04:06.63 server SQL server listening on TCP, Shared Memory, Named Pipes.
2007-11-05 14:04:06.63 server SQL Server is ready for client connections
2007-11-05 14:04:06.66 spid6 Clearing tempdb database.
2007-11-05 14:04:07.10 spid6 Starting up database 'tempdb'.
2007-11-05 14:04:07.20 spid2 Recovery complete.
2007-11-05 14:04:07.20 spid2 SQL global counter collection task is created.
2007-11-05 14:04:16.41 spid1 Warning: unable to allocate 'min server memory' of 1658MB.
2007-11-05 14:10:45.18 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager.
View 2 Replies
View Related
Jul 17, 2007
I am going to be upgrading to SP2 on an active/passive cluster currently running RTM. I have read the release notes, but there isn't much cluster specific information there. At what point during the installation are connections to the database no longer available? I am trying to figure out approximately how much downtime we will have during this installations. Are there any precautions, other than a backup, that I should take to ensure the upgrade goes smoothly?
View 5 Replies
View Related
Apr 17, 2007
Hello.
Has anyone attempted and successfully installed SQL Server 2000 SP4
via remote desktop on the cluster.
The reason I am asking is that SP4 readme file has this:
"...
4.3 Systems Management Server Distributed Installation
You cannot install Database Components SP4 from a remote location.
..."
Currently SQL Server has SP3a installed.
Thank you in advance.
View 2 Replies
View Related
May 8, 2007
I have a SQL 2000 clustered environment with 4 SQL instances and i need to remove a specific instance from the cluster the resources(physical drive,virtual IP,instance name) being used by it
View 5 Replies
View Related
Jul 31, 2007
We are running SQL Server 2000 Enterprise Edition on a 2-node cluster with IIS/ASP.NET front-end hosting 150-200 active connections. There is a SVCHOST process running under LOCAL SERVICE account - hosting the Remote Registry process that is using only 4,200K but is page faulting 200-500 times per second. I realize this process is used for failover, but the page fault seems excessive. Any thoughts on this?
The servers are running Windows Server 2003 with 4 processors and 4gb RAM.
View 1 Replies
View Related
Jun 5, 2006
I
am trying to install SQL 2005 in a 2-node virtual Windows 2003 cluster. I set
the cluster up through Virtual Server 2005 with 2 virtual nodes and one
virtual domain. The nodes can connect to each other as well as the
physical machine. When I try to install a fresh copy of SQL 2005 on my
cluster, I get an error every time. The
error stops the installation while checking system configuration after
installing prerequisites. The log file entry is as follows:
*******************************************
Setup Consistency Check Report for Machine: --SERVERNAME--
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: Warning
Description:
IIS is not installed, therefore Report Server feature will be disabled
Action: Install IIS in order for Report Server feature to be enabled
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
1
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run:
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache
Source File Name: datastoreclusterinfocollector.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: ClusterInfoCollector::collectClusterVSInfo
Source Line Number: 883
----------------------------------------------------------
Failed to detect VS info due to datastore exception.
Source File Name: datastoreclustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
----------------------------------------------------------
Failed to find a cluster group that owned shared disk: J:
WinException : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastoreclustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
View 3 Replies
View Related
May 26, 2006
We wish to upgrade our hardware of two sql boxes onto a single cluster. One of our databases will not run on sql 2005 and so I wanted to know if it is possible to run an instance of sql2000 and an instance of sql 2005 on the same cluster.
This is possible or would it cause as a lot of problems?
View 3 Replies
View Related
Feb 14, 2007
We have SQL Server 2005 on windows 2003 server +SP1. In the application log I noticed the following errors during .
Event Type: Error
Event Source: MSSQL$SQL
Event Category: (3)
Event ID: 19019
Date: 2/13/2007
Time: 6:36:53 AM
User: N/A
Computer:xxx
Description:
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
Event Type: Error
Event Source: MSSQL$SQL
Event Category: (3)
Event ID: 19019
Date: 2/13/2007
Time: 6:36:53 AM
User: N/A
Computer: XXX
Description:
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
...so got the below information from the cluster log:
000009fc.00000d68::2007/02/13-12:36:53.210 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009fc.00000d68::2007/02/13-12:36:53.226 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host.
000009fc.00000d68::2007/02/13-12:36:53.226 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]Communication link failure
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] OnlineThread: QP is not online.
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
0000088c.00000af8::
Looked at the system log to see if there are any errors , but could not found any during that time....The last message in the system log was
Event Type: Warning
Event Source: Print
Event Category: None
Event ID: 3
Date: 2/13/2007
Time: 5:03:04 PM
User: NT AUTHORITYSYSTEM
Computer: xxx
Description:
Printer ITGHP8N1 on rchprt01 (from R6911497-XP) in session 1 was deleted.
before that there were messages of creating and deleting the printer...and R6911497-XP is my laptop which was not really running during that time...
From some research came to know that this might be because of network issues, but let me know for what errors I need to look for network issues...does the above error in the system log suggests network errors...
Any help is appreciated...
View 3 Replies
View Related
Feb 10, 2006
We are trying to install SQL Server on a cluster that has 4 nodes, 3 of them running SQL2k. We're getting an error in the setup after it is done with Framework:
Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache
... Source File Name: datastoremachineconfigscopeproperties.cpp
Compiler Timestamp: Wed Aug 24 13:40:04 2005
Function Name: SqlInstallConfigScope.InstanceName
....-
Error: Could not find an install of type 3 for instance SQL ##
We think it's due to a directory and item in the registry for a server instance we used to run on this server, but no longer due as it was uninstalled and the server moved to this cluster. The directory doesn't show in other nodes in the cluster, but does in the cluster it was moved from. We continue to find that 2nd instance refuses to failover to this server also. We have determined that it€™s only the SQL server which is having issues as we were able to move the disks over. When we start the SQL service it pops back to 2nd instances home server.
View 1 Replies
View Related
Mar 11, 2008
I have a two node failover cluster with SQL 2005 installed. I am running Windows Server 2003 x64 Enterprise and SQL 2005 x64 Enterprise. When I try the SP2 upgrade, I basically get an error message saying no passive nodes were succesfully patched. I have tried installing from the active node and the virtual server, same results with both. I have also tried the LMHOSTS file addition that Microsoft recommends, but that didnt solve the problem either. We do have an MSDTC Resource set up, as I have read this may cause problems, but it still doesnt work.
I dont know what to do next, any ideas?
Time: 03/11/2008 09:40:26.456
KB Number: KB921896
Machine: CAROLINA
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x64
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: Yes
Log Location on Passive Nodes:
(OAKLAND) C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix
(CAROLINA) C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.2.3042 x64
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x64 ENTERPRISE
SQL Server Native Client ENU 9.00.3042.00 x64
Client Components ENU RTM 9.00.1399.06 x64 ENTERPRISE
MSXML 6.0 Parser ENU 6.10.1200.0 x64
SQLXML4 ENU 9.00.1399.06 x64
Backward Compatibility ENU 8.05.2004 x64
Microsoft SQL Server VSS Writer ENU 9.00.3042.00 x64
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
----------------------------------------------------------------------------------
**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009
e :
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009
View 3 Replies
View Related
Jun 26, 2006
I have a Windows 2003 Enterprise x64 edition cluster setup and functioning normally. Now, I am trying to get SQL Server 2000 installed as a failover cluster but am having some difficulty. When installing, I get the message '[sqsrvres] ODBC sqldriverconnect failed' in the event log. The message happens when the installer is trying to bring the SQL Server Service resource online.
I am able to ping the name of the instance successfully. I am able to manually start the 'MSSQL$InstanceName' service. I have turned off the firewall on both machines, but this did not help. I have the DTC Service setup as a resource in the same cluster group.
I also read http://support.microsoft.com/default.aspx?scid=kb;en-us;815431 which seemed promising, but did not reolve the problem.
Any help would be much appreciated.
Andy
View 2 Replies
View Related
