Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







How To Patch A 2005 Cluster?


According to SP1 documentation patching the Active node in a cluster will automatically apply the SP1 patch to the Passive nodes. However, I found a MS document that says if you have management tools installed on the passive node, you must patch this node separately. Is this correct?

Also, since Integration Services is not cluster-aware and therefore must be installed separately to the passive node(s), does SP1 need to be applied directly to the passive node(s) to patch Integration Services or is it automatically patched when I patch the Active node?

Thanks, Dave


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Latest Sql Server 2005 Patch
 

Please advice me, now we are using service pack1, what is the latest service pack i can upgrade and has all the issues been recitified.
 
Thanks

View Replies !   View Related
How To Upgrade SQL Server 2000 Cluster To SQL Server 2005 Cluster(Database)
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 Replies !   View Related
Upgrading SQL Server 2000 Cluster To SQL Server 2005 Cluster
 

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 Replies !   View Related
Upgrading A SQL Server 2000 Cluster To A SQL Server 2005 Cluster
 

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 Replies !   View Related
Step By Step For Upgrading SQL Server 2000 Cluster To SQL Server 2005 Cluster
 

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 Replies !   View Related
Why Tis Patch ?!
 Whats the goal of this patch ? i really dont find any solution except download SP4

View Replies !   View Related
Need Knowledge About Patch
Hello, everyone:

Are ther any basic information about patch on SQL Server? How to develop patch, and run it? Thanks a lot

ZYT

View Replies !   View Related
??'s About Security Patch
I plan to apply the new security patch on my SQL 7.0 sp3 servers and get my SQL 2000 servers up to SP2 (which apparently already includes this)

But I was reading the Mitigating Factors in the announcement of this vulnerability and one reads as below:

"The effect of exploiting the first vulnerability would depend on how the SQL Server service was configured. SQL Server can be configured to run in a security context of the administrator’s choosing. (By default, it runs as a domain user). If best practices are followed, and the service is configured to run with the least privileges necessary, it would limit the worst-case damage an attacker could achieve. "

So my question is: What is the best practice for the SQL Server service and Agent service? Also are there resources for Best Practices?

Thanks!!

View Replies !   View Related
Q323875_SQL2000_SP2_en Patch
I am trying to apply this patch to a Developers Edition of SQL 2000. According to the instructions, I am to replace ssnetlib.pdb, located int the binndll folder. well, this file does not exist in this or any other folder on the server. I have installed SP2 and all previous patches. Anyone have any idea why this is and how to resolve it?

Thanks,
Mitchel

View Replies !   View Related
New Patch For SQL Server
Anyone DL and install the new patch on a production server? any issues? notice any drastic changes? was a reboot nessiccary?

Thanks for the help.

Late
Matt

View Replies !   View Related
Do I Need To Reinstall Or Patch Something??
Hi,

I have discovered something wrong with my SSIS package and I thought it best to post a new thread since the problem is not what I thought it was initially.

With relation to my post of 'directory variable problem' I have now discovered by opening my project this morning that apparently my project had gone corrupt, according to the dev environment since the message reads:

"There were errors while the package was being loaded.The package might be corrupted.See the Error List for details."

The Error List:
"Error 13 Error loading MyTestSSISPackage.dtsx: The connection "(local).MyTestDB.sa" is not found. This error is thrown by Connections collection when the specific connection element is not found."
This is a buggy ADO.net connection that I deleted yesterday since, even though it connects successfully, doesn't want to work! It keeps on telling me log in failed for user <MyTestUser> even after I test it and it connects fine with the username and password during the UDL screen of the connection.. It's like it forgets the bloody password.
I created another connection, this time an OLE connection and it seems to work fine.

*EDITED*
I stand corrected..no bloody connection manager is working now. They all fail stating that they cannot connect to the db due to some or another 'unsupported' value in the connection string...the connectionstring was set up by the environment's udl????? how is this possible. I am beginning to get annoyed with SSIS

Now finally my question...WHY is it that every time I change something its like the dev environment doesn't cascade the change throughout the project or package? The problem I have been having with my variables not getting picked up with the correct values which I gave them during design time is probably also related to this. How or where can I remove the reference to this old ADO.Net connection since I cannot find it anywhere in the <package>.dtsx file?

Anyone ever experienced this?

Regards
Mike

View Replies !   View Related
Patch Null Value?
following is my sql:


select a.dcode, b.district from table1 a, table2 b
where
a.id = b.id

and return following result:

 

dcode       district
123             south
321             north
456             east
789             west
123
789


so for those records that district are null, how can i fill them up as i know they have the same dcode as the other records?

View Replies !   View Related
SQL 2005 Cluster
SQL Cluster 2005 on Windows 2003 Service Pack 1

View Replies !   View Related
Cluster 2005 Need Help Please
quick overview

2 nodes-cluster setup from node 1

I setup a cluster, created 4 groups

1.cluster 2.msdtc 3.sqlinstance1 4.sqlinstance2

I want to create an activepassive on both nodes.  (onenode will be the active node for on sql install while the other is passive.

I want to repeat this fo rthe second node, the second node being active and node 1 passive.

I logged into node 1 and I installed sql 2005 in failover cluster into sqlinstance 1., everyhting was fine, failover etc.

Now I logged into node 2 and ran sql 2005 setup to create a failover cluster.

I chose to install into sql instance 2.

Database unable to install with error "failed to set registry settings for server network libraries.  acition is setdefaults.error 11001, no such host is known.

If I am not setting this up correclty please let me know

 

thanks 

everything was fine.  I logged onto node 2, was going to

View Replies !   View Related
Sql 2005 Cluster
we want to have an activepassive and active passive cluster.

node a install sql instance 1 failover over to node b

node b install sql instance 2 failover to node a

do I have to setup 2 cluster ?  ie. quorum, msdtc etc..

or just one cluster(quorum, ip and name), one msdtc group( as per MS msdtc doc) and 2 san disks (one for node a and one for node b.

 

is this correct?  I have looked and looked for a step by step on setting this up, no where can I find what i need.  I downloaded  the failover cluster doc from microsoft, book online etc..

 

thanks

View Replies !   View Related
SQL 2005 SP1 On 64-bit Cluster
When I run sp1 on the active node of a 64-bit cluster the setup just hangs when it gets to the Database services part.  It does not return any errors as mentioned by others in this forum.  I also do not have SqlSupport.msi in the add/remove programs (one suggestion on this forum was to uninstall it reinstall).  I have let it run for up to 12 hours with no result.

There is no SQL9_Hotfix_KB913090_sqlrun_sql.msp.log file only SQL9_Hotfix_KB913090.log

this is the content

05/09/2006 12:41:12.274 ================================================================================
05/09/2006 12:41:12.274 Hotfix package launched
05/09/2006 12:41:15.634 Product discovery successfully completed during the install process for DEV01
05/09/2006 12:41:15.634 SP Level check successfully completed during the install process for DEV01
05/09/2006 12:41:15.634 Product language check successfully completed during the install process for DEV01
05/09/2006 12:41:15.634 Product version check successfully completed during the install process for DEV01
05/09/2006 12:41:15.681 Product discovery successfully completed during the install process for DEV02
05/09/2006 12:41:15.681 SP Level check successfully completed during the install process for DEV02
05/09/2006 12:41:15.681 Product language check successfully completed during the install process for DEV02
05/09/2006 12:41:15.681 Product version check successfully completed during the install process for DEV02
05/09/2006 12:41:15.743 Product discovery successfully completed during the install process for DEV03
05/09/2006 12:41:15.743 SP Level check successfully completed during the install process for DEV03
05/09/2006 12:41:15.743 Product language check successfully completed during the install process for DEV03
05/09/2006 12:41:15.743 Product version check successfully completed during the install process for DEV03
05/09/2006 12:41:15.790 Product discovery successfully completed during the install process for DEV04
05/09/2006 12:41:15.790 SP Level check successfully completed during the install process for DEV04
05/09/2006 12:41:15.790 Product language check successfully completed during the install process for DEV04
05/09/2006 12:41:15.790 Product version check successfully completed during the install process for DEV04
05/09/2006 12:41:15.790 Command-line instance name check completed during the install process
05/09/2006 12:41:15.868 Baseline build check completed during the install process
05/09/2006 12:44:25.795 Attempting to install instance: DEV02
05/09/2006 12:44:25.795 Enumerating passive cluster nodes
05/09/2006 12:44:25.873 Patching available passive node: TTCSQL62A
05/09/2006 12:44:25.873 Waiting for first successfully completed passive node
05/09/2006 12:44:25.873 Attempting to patch running passive node: TTCSQL62A

View Replies !   View Related
SQL 2005 Cluster DR
I'm having trouble finding the recommended process for doing a full Disaster Recovery on a two node active/passive sql 2005 cluster.  I've been able to locate the procedure for rebuilding a failed node on the msdn site but no procedure for recovering the entire system.  Any assistance or points in the right direction are appreciated.

Thanks

View Replies !   View Related
SQL 2005 Std Cluster
Anyone know before I invest in the hardware if it is possible to have Two Clusters on the same hardware both in Active/Passive Clustering where Cluster1 and Cluster2 both use the Default SQL Server 2005 Instance (No Named Instances)?
 
This would be a Virtual Cluster with Two separate 2 node Clusters on the Same Hardware sharing the same OS and SQL.
 
Thanks in Advance,
 
Best,
 
JD

View Replies !   View Related
SQL 2005 Cluster
Hi guys

I have just recently inherited a sql server 2005 cluster (2 nodes) we have a situation coming up where i need to power down the whole cluster for several hours as a result of some power mains work.

I just need to confirm with someone the correct way to power down the whole cluster and power it back up once the power is restored the company. I appreciate this may not be the best place to have posted this but i am desperate and couldn't find another location.

 

many thanks for any help

 

SB

View Replies !   View Related
Patch Apply Question
I got 4 sql2k5 servers with service patch version as following:

Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86) Feb 9 2007 17:30:38
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)

Can anyone please advise me what is the easiest way to upgrade them to the
most updated patch version? i.e. update path.

Meanwhile, what is the best practice to apply patches? Do you go to
microsoft website and check it out daily and apply it or other tricks?
Please advise. Thanks.

View Replies !   View Related
Security Patch ,who Can Install It ?
Hi,

We have several sql servers and company policy
1. all sql servers should be updated with latest MS Security Patches
2.Updates should be done by domain admistrators team.
3.Domain admins not sa of sql servers

Early we removed BulitinAdmin group from all sql servers

When one of domain admin(domainJoeBlow ) started updates for Windows and SQL securiy patch, update failed

I give domainJoeBlow rights
to be server admin on sql ,update went half way and fail again.

When I gave domainJoeBlow sa right ,update completed with success

If we don't want domain admins to be sa on sql server, what rights should they given to install Security patches?

Thank you

Alex

View Replies !   View Related
Patch Apply Question
 I got 4 sql2k5 servers with service patch version as following:

Microsoft SQL Server 2005 - 9.00.2221.00 (Intel X86)   Feb  9 2007 17:30:38
Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.2153.00 (Intel X86) May 8 2006 22:41:28
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)

Can anyone please advise me what is the easiest way to upgrade them to the
most updated patch version? i.e. update path.

Meanwhile, what is the best practice to apply patches? Do you go to
microsoft website and check it out daily and apply it or other tricks?
Please advise. Thanks.

View Replies !   View Related
SQL 2005 SP1 Install In A/A Cluster
Okay, it's a good thing no one from M$ is in the immediate (physical) vicinity...

I'm doing some preliminary testing on SQL 2005 in an Active/Active Cluster. I'm using Windows 2003 Enterprise, on a 2-node cluster using SCSI storage.

I installed a default instance and patched it to SP1. Then I installed a second (named) instance and attempted to patch it. That's where the fun began.

Read KB 918357 (http://support.microsoft.com/?kbid=918357).

Buried in the log files (good luck finding them) on the passive node was the error message "Unable to install Windows Installer MSP file".

You have to apply the instructions outlined in the previous KB to BOTH nodes in order to get SP1 to install. Alternatively, I suppose you could install SP1 on both instances at the same time, but if you add another instance into your cluster, you'd better watch out!

Also, another gotcha was that I had the default instance turned off during the SP1 installation. I had simply off lined the group (including the disks) instead of offlining the SQL Resource. Buried in the log files on the passive node was an error message indicating that the installer could not find the owner for the S: drive (the data drive for the default instance). Why the installer should CARE who owns the S: drive when it shouldn't be doing anything with it, I don't know.

What a total PITA!!!!

I am going to go have a beer...or two...or three......

Regards,

hmscott


BTW, the log files for the SP install are in C:WindowsHotfixSQL9. The log files for the base install are in C:Program FilesMicrosoft SQL Server90Bootstrap

View Replies !   View Related
$#@$#%! SQL 2005 Cluster Install!
I have YET to have a 100% CLEAN install of SQL 2005 in a clustered environment. SQL 2005 Std. was not so bad, I think I finally managed a 99% clean install (no script errors on patches) on the third try.

SQL 2005 EE keeps erroring off on 2153 patch install. The error logs are no help at all; they simply stop logging activity at about the point that the error occurs.

For a premier product, this installation SUCKS.


Whooo. Okay. I feel better.

Here's my situation:
4-node Cluster (Windows 2003 Enterprise Edition), SP1
SQL 2005 Enterprise Edition


Process:
Install OS
Patch OS to SP1
Cluster OS on SAN
Configure Cluster Groups (DBC01, DBC02, DBC03) with cluster disks
Configure MSDTC (network access, configure cluster resources)

Start SQL Installation
Install RTM Binaries on Node 1 for Default Instance
Install Workstation and non-cluster components on remaining nodes
Install RTM Binaries on Node 2 for Named Instance

Reboot all nodes

Install SP1 for all instances from node 1

Install SP1 for all local services/applications for all other nodes

While attempting to install the 2153 SQL patch/hotfix, the process will either:
Hang while waiting for the first passive node for the default instance; or
Crash immediately with no error messages in the logs.


This is no nearly detailed enough, I know. I'm missing error messages and more. It's snowing outside and I have to get home. I just think that the installation for this product in a clustered environment is very unstraightforward at best, and at worst is a real liability to an organization since it's practically impossible to get it clean the first time through.

Regards,

hmscott

View Replies !   View Related
SQL 2005 Ent Cluster Issue
Hello guys.

Here is my issue. We have 2 clustered sql servers SQL8 and SQL9 we moved domains a few months ago and a week ago we had a problem and lost SQL8 in are cluster. we have rebuild the server SQL8 and had it back to the cluster. On SQL9 we have done the maintain virtual server steps we do see SQL8 we have haded it but when it runs the install for SQL8 it errors out on someting like permissions about the group not having suffisent right..but we have veryfied and all these group are admin on all clusters...the registry keys keeps track of the old Domain and thats probably Y it looks at a old domain and says well you don have the correct rights.
This is where iam confused ...How do i had the SQL8 back without haviong to rebuild SQL9 ? and how do you go about when you actually move domains for SQL any help here would be greatly apreciated.

View Replies !   View Related
Sql 2005 Cluster Installation
Can anyone please send me the sql server 2005 cluster installation steps ?

Thanks in advance

View Replies !   View Related
Removing AS 2005 From A Cluster
I am trying to remove Analysis Server from a cluster. I have done the research and according to MS you can't use the regular add/remove programs dialog to remove a component. You have to use the setup.exe from the command line.
This article (http://support.microsoft.com/kb/910230) explains at the very bottom to run this command "Start /wait <DiskDrive>setup.exe /qb REMOVE=Analysis_Server INSTANCENAME=<InstanceName>". Well I do that and I get the installer up and running but when it gets to that system configuration check screen, where it runs a bunch of checks on the nodes, it just closes before it does any checks and nothing further happens. I can't find any error in the event log or find any log files on disk related to why its just closing.

Just to investigate further, I wondered what executable was running when you ran the installer though the add/remove programs dialog, so I looked in the registry. Well along with the SQL Server 2005 entry, which runs the setup bootstrap program in your default install folder, I noticed an entry that was idenified only by its GUID. Looking at the sub keys I noticed the DisplayName was Microsoft SQL Server 2005 Analysis Services. The UninstallString key was set to "MsiExec.exe /I{52B0D62A-860D-4136-9A8A-9FD877E8EE89}" so I ran that. The installer seems to work, but it doesnt run any configuration checks. I get to the screen with the big button to change components with no errors. Then it acutally shows Analysis Services installed (the disk icon is not xed out), I can then click and select entire feature will be unavailable. I haven't proceeded on this step because I am worried about the cluster.

I am assuming that this uninstaller will only remove analysis services from the node its running on. This is fine, cause I can just run this same procedure on all the nodes... and then i would assume I would have to manually clean up the cluster resource. But I have not tested this, and unfortuanlly I don't have a development cluster to try this on.

Does anyone have experience with removing Analysis Services from a failover cluster environment?


- Eric

View Replies !   View Related
SQL Server 2005 On A Cluster
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 Replies !   View Related
SQL Server 2005 SP2 Cluster
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 Replies !   View Related
Cluster Upgrade SP2 2005
Have recently performed an in-place upgrade of a 2 instance sql cluster from 2000 to 2005.  The upgrade process went relatively smoothly.  However, I am running into problems installed sp2.  The first problem that I run into is that I have resrcmon.exe locked.  I can click next, which is fine, but once I get past that point I get stuck during the installation process.  I am updating DatabaseServices and Integration Services.  It gets stuck on 'Awaiting first complete passive cluster node SQL-Test'.  Does anyone have any ideas?
Thanks,
Tim

View Replies !   View Related
SQL 2005 SP2 Cluster Install
 

When you try to re-apply SP2 for SQL 2005 on node added to cluster it continously fails?

Only way to apply SP2 is to shut down original node(with SP2 allready applied) and then apply SP2 and hotfixes on additional node!

 

I would like to see some reply from SQL support team for this 'issue'. Is this normal? This bring many issues when you have more than one sql on 2 node cluster....etc

 

any explanation is appreciated

 

rgds

Sinisa

 

View Replies !   View Related
SQL 2000 And 2005 On The Same Cluster
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 Replies !   View Related
SQL 2005 Stand Alone To Cluster
Our production server is currently running SQL 2005 on a stand alone machine. SQL Server is installed as a default instance. 

 Can we upgrade to a cluster without having to change the instance name i.e currently applications connect to this server with hostname of the server i.e SERVERA, can we install a cluster such that sql server can still be called SERVERA.

 

 

View Replies !   View Related
SQL 2005 Sp2 Cluster Install
Just to confirm I do need to run SQL 2005 SP2 on the passive node. but the passive node should be rebooted.

View Replies !   View Related
SQL Server 2005 On A/P Cluster
I have a clustered two nodes ( AP) servers which are HP ProLiant DL360 G5 2.66GHz  dual processor  with 16GB ram.

It has windows 2003 sp1 64 bit and SQL 2005 sp2 64 bit.    Everything looks good and all configurations seem set up correctly. But, the SQL server in SQL group stop and re-run every night between 10:00 and 10:30 by cluster managment. I am getting all symptoms that are posted in the above message.  What is very strange is why it always happens on a certain time of the day. Needless to say that we do not have any scheduled task on the server or SQL server.

 Your help would be greatly appreciated, since I am getting out of clue.

 

 Thanks

 

View Replies !   View Related
SQL Server 2005 On A/A Cluster
 

  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 Replies !   View Related
SQL 2005 Cluster Error
We are getting the following error messages on a regular basis. 

[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed

[sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host.

[sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]Communication link failure

[sqsrvres] OnlineThread: QP is not online.

[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed

[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure

[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed

[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure

[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed

I have windows server 2003 service pack 1 and sql server 2005 service
pack 1 - 64 bit.  Sometimes it happens in the middle of the night.  Sometimes it's in the middle of the day and sometimes it's multiple times in the same day.  Sometimes the server reboots, but does not failover.

Any help is appreciated

View Replies !   View Related
Critical Patch KB824105 And SQL Failure
On the re-boot required for critical patch KB824105 MS SQL Server failed torecgnize the log on for the account it is registered under, and all otheraccounts when manually cahnged.It seems to have completely lost all ability to recognize and logon.SQL is totally hooped - no ODBC at all at the service doesn't start. At allbecause of no recognition of any accounts.Any suggestions? I've been trying for a while.

View Replies !   View Related
Error In Install Service Patch 5a
Hi,

I have problem in install SQL Server 6.5 service patch 5a. I download the .exe
from Microsoft and try to install it, it give error:

"setup initalizarion could not be successfully completed.
isql.exe can not be executed.
see error from relevant.OUT file. "

I thought the setup file need to run name pipes prototal instead of TCP/IP, so I change, but still give me the error. I install SS service patch 5a in other mechines before. Never has any problem. This time two of my server run into this problem, any help will be appreciated.


Eugene Shi

View Replies !   View Related
Patch For SQL Server 2000 Enterprise ???
Hi All,

I am new to SQL Administration. I have installed SQL 2000 Enterprise edition for one of the process. I just want to know What is the most recomended patch that can be applied on this ?

Thanks

Vijay

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved