MS SQL Server :: 11009 No Passive Nodes Were Successfully Patched

SQL Server 2005 SP1 Error--No Passive Nodes Were Successfully

Oct 16, 2007

Hello All,

I have a database cluster which I am trying to upgrade to SP1+hotfixes. I was able to successfully upgrade to SP1, however when I try to apply the hotfix "sql2005-kb918222-x86-enu.exe". The install fails and generates the following error log; Can anyone please help? Thanks a lot.

10/16/2007 09:35:50.058 ================================================================================
10/16/2007 09:35:50.058 Hotfix package launched
10/16/2007 09:35:52.495 Product discovery successfully completed during the install process for MSSQLSERVER
10/16/2007 09:35:52.495 SP Level check successfully completed during the install process for MSSQLSERVER
10/16/2007 09:35:52.527 Product language check successfully completed during the install process for MSSQLSERVER
10/16/2007 09:35:52.542 Product version check successfully completed during the install process for MSSQLSERVER
10/16/2007 09:35:52.558 Command-line instance name check completed during the install process
10/16/2007 09:35:52.573 Baseline build check completed during the install process
10/16/2007 09:36:15.028 Attempting to install instance: MSSQLSERVER
10/16/2007 09:36:15.059 Enumerating passive cluster nodes
10/16/2007 09:36:15.090 Patching available passive node: SNTCCASGDB006
10/16/2007 09:36:15.106 Waiting for first successfully completed passive node
10/16/2007 09:36:15.121 Attempting to patch running passive node: SNTCCASGDB006
10/16/2007 09:36:15.200 Successfully created remote folder for product instance target \SNTCCASGDB006
10/16/2007 09:36:15.809 Successfully transferred payload to remote product instance target \SNTCCASGDB006
10/16/2007 09:36:15.825 Successfully transferred payload to remote product instance target \SNTCCASGDB006
10/16/2007 09:36:16.981 Successfully created new scheduled task for product instance target \SNTCCASGDB006
10/16/2007 09:36:17.840 Successfully saved new scheduled task for product instance target \SNTCCASGDB006
10/16/2007 09:36:17.872 Successfully created scheduled task for product instance target \SNTCCASGDB006
10/16/2007 09:36:17.887 Successfully started scheduled task for product instance target \SNTCCASGDB006
10/16/2007 09:36:17.903 Successfully started scheduled task for product instance target \SNTCCASGDB006
10/16/2007 09:36:20.934 Scheduled task for product instance target has completed
10/16/2007 09:36:20.950 Waiting for exit code from scheduled task for product instance target \SNTCCASGDB006
10/16/2007 09:36:25.966 Received exit code 11201 from scheduled task for product instance target \SNTCCASGDB006
10/16/2007 09:36:25.981 Result code for scheduled task for product instance target has been received
10/16/2007 09:36:25.997 Removed scheduled task for product instance target \SNTCCASGDB006
10/16/2007 09:36:26.169 Successfully removed remote folder for product instance target \SNTCCASGDB006
10/16/2007 09:36:26.185 Remote process completed for product instance target
10/16/2007 09:36:26.200 Exit code for passive node: SNTCCASGDB006 = 11201
10/16/2007 09:36:30.122 The following exception occurred: No passive nodes were successfully patched Date: 10/16/2007 09:36:30.122 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllinstance.cpp Line: 2583
10/16/2007 09:36:30.169
10/16/2007 09:36:30.200 Product Status Summary:
10/16/2007 09:36:30.232 Product: SQL Server Database Services 2005
10/16/2007 09:36:30.263 MSSQLSERVER - Failure
10/16/2007 09:36:30.310 Details: No passive nodes were successfully patched
10/16/2007 09:36:30.341

View 11 Replies View Related

SQL Server 2000 - What Is Fully Patched And How Do You Get It Fully Patched Sp4+

May 14, 2008

Having read the following :

How to identify your SQL Server version and edition
http://support.microsoft.com/kb/321185/

How to obtain the latest SQL Server 2000 service pack
http://support.microsoft.com/?kbid=290211

Service Pack 4 for Microsoft SQL Server 2000
http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32desksp4.htm#_1461463_hardware_and_software_requiremen_fzpy

Cumulative list of the hotfixes that are available for SQL Server 2000 SP4
http://support.microsoft.com/?kbid=894905

A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187
http://support.microsoft.com/?kbid=916287

Which appears to indicate
8.00.760 = sp3/sp3a
8.00.2039 = sp4
8.00.2187 = Cumulative rollup
8.00.2249 Final patch build number

I still have the following question which i would very much appreciate help in answering:
If support is required from Microsft what is the acceptable level of SQL Server patching before Microsoft will agree to look at a SQL Server problem. ?
SP4 Build 2039 + Build 2040 (awe fix)
SP4 Build 2187 cumulative rollup
SP4 Build 2249 fully patched as per KB894905
Do I need to apply builds 2187 to 2249 ?
If so where/how can I obtain the down loads from ( 8.00.2187 - 8.00.2249) ?

Have logged a call with microsoft support but as yet no responce.

View 8 Replies View Related

Add A New Passive Node To Set Up Active/Active/Passive Cluster

Mar 18, 2008

We have a SQL cluster server running with SQL 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition.
Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So after I have done it, the cluster will be a Active/Active/Passive cluster.

Because the cluster is a production server, I need to know exactly how I add a new node onto the current cluster without breaking anything. Also this is my first time to install a passive node, so it is difficult for me to understand how to install and configure it.

I have already added the physical node onto the cluster group so I can see the new node ��paused�� from the Cluster Administrator. Now I need to install the SQL but I am too nervous to run the installation program.

My questions are:

1. Do I need to run the SQL install program from one of other active nodes in order to install the SQL on to the new node? Or is it ok to run the SQL install program from CD?
2. Do I need to create a new virtual name, a new SQL named instance and a virtual IP address for the new passive node?

Physical node name Virtual name SQL Server Instance Name IP address
Node1 (active) SQL1 SQL1 xxx.xxx.xxx.100
Node2 (active) SQL2 SQL2SQL2 xxx.xxx.xxx.110
Node3 (passive) SQL3??? SQL3SQL3????????? xxx.xxx.xxx.120????

3. Is there a risk to delete or change the current active nodes? If so, will you let me know as I will be super-careful not to do it.

I highly appreciate your help!

View 5 Replies View Related

Cannot Save Maintenance Plans (SQL Server 2005 X64, SP2, Patched To KB934458)

Nov 18, 2007

I have a SQL Server 2005 x64 bit with SP2 applied and patched to KB934458-x64-ENU (9.0.3054)
I am unable to create a maintenance plan via Management Studio or save a plan in Management Studio using the wizard.

If I just try and create a new maintenance plan, then I get the following problem:
"An OLE DB error 0x80004005 (Login timeout expired) occurred while enumerating packages. A SQL statement was issued and failed."

If I try and create any maintenance plan via the wizard, I get the following problem:
"The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed."

I've doen a bit of digging on this and had initially thought it was related to the fact that I have two instances installed on 1 server. I've since updated the MsDtsSrvr.ini.xml file to point at both instances, as I thought that might have been causing the problem. That hasn't helped at all. Edited example of xml file is below:

<?xml version="1.0" encoding="utf-8"?><DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown> <TopLevelFolders> <Folder xsi:type="SqlServerFolder"> <Name>MSDB SQL Server Instance 1</Name> <ServerName>ServerNameInstanceName1</ServerName> </Folder> <Name>MSDB Server Instance 2</Name> <ServerName>ServerNameInstanceName2</ServerName> </Folder> <Folder xsi:type="FileSystemFolder"> <Name>File System</Name> <StorePath>..Packages</StorePath> </Folder> </TopLevelFolders> </DtsServiceConfiguration>

Any suggestions would be most welcome!

View 4 Replies View Related

Active/Passive

Oct 17, 2000

What is the different between Active/Active and Active/Passive cluster configuration.

I am new, that's why.

Help please

View 1 Replies View Related

Active/passive Clustering

Jul 18, 2001

(1) During installation of second node in active /passive mode do we have to assign new virtual sql sever name and IP address or can we join existing first node Virtual SQL server ?

(2) Do we have to carry full instllations in 2 nd node or only clint instllations ?what about location binary and data in 2 nd node ?

View 1 Replies View Related

New Instance Of A Active/Passive Cluster

Jun 20, 2008

Hi all,
Newbi to sql clustering.

I have a sql server 2005 standard edition with Active/Passive Cluster in production.

I have a new requirement where i need to create a new instance on this active/passive cluster that can be used by our sharepoint servers. Can somebody please let me know what are the steps that i need to follow like

1.What i need to ask my network admin?
2.How i need to proceed installing?
I am planing to do this over the weekend where i have the liberty of some down time.
Any help greatly appreciated
Thanks

View 1 Replies View Related

Licensing Multiple Passive Servers

Oct 17, 2007

Hi, I was wondering what the licensing requirement would be for following scenario:

1 active sql server installation installed on a windows failover cluster.

1 passive mirror sql server (single server).

1 passive log-shipped sql server (single server).

In the microsoft white paper it says:

When doing failover support, a server is designated as the passive server. The purpose of the passive server is to absorb the data and information held in another server that fails. A passive server does not need a license, provided that the number of processors in the passive server is equal or less than those of the active server. The passive server can take the duties of the active server for 30 days. Afterward, it must be licensed accordingly.

So do I need to buy an enterprise license for each of the additional passive servers...in the above example meaning I would need 3 licenses in total?

Thanks,
Paul

View 3 Replies View Related

Applying SP4 On An Active/passive 2 Way Cluster

Aug 12, 2006

I have a 2 way cluster and I want to apply SP4 on it.

Basically, I have 2 servers. Server A runs a default instance and another instance. While the default services is disabled and the other instance is running, Server B runs the default instance and has the other instance disabled. This basically acts like a 2 way cluster (active/passive).

How can I apply SQL Server 2000 SP4 on the 2 servers and have all the nodes come up the correct way? What are the steps to achieve this?

View 1 Replies View Related

Active/passive W/o Shared Disk Array

Feb 2, 2005

can you have an active/passive without a shared disk array?

can you have an active/active without a shared disk array?

Where are the actual db files stored?

thanks

View 5 Replies View Related

Problem Installing SP2 On Active-passive X64 Cluster

Apr 4, 2007

I just tried to apply SQL 2005 Std SP2 on a cluster, and all succeeded except for the Database Services. I've looked about and can't see any specific information for this. The Summary.Txt is below. I thought I was following the appropriate steps, according to the SP2 Readme.

Thanks for any help. (I'm at the client today)

Bob Coppedge

me at RLCoppedge dot com

Time: 04/04/2007 10:55:44.249
KB Number: KB921896
Machine: SQL01
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (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:
(SQL01) C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix
(SQL02) C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.1.2047 x64
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x64 STANDARD
Notification Services ENU SP1 9.00.2047.00 x64 STANDARD
Integration Services ENU SP1 9.00.2047.00 x64 STANDARD
SQL Server Native Client ENU 9.00.2047.00 x64
Client Components ENU SP1 9.1.2047 x64 STANDARD
MSXML 6.0 Parser ENU 6.00.3890.0 x64
SQLXML4 ENU 9.00.2047.00 x64
Backward Compatibility ENU 8.05.1704 x64
Microsoft SQL Server VSS Writer ENU 9.00.2047.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): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
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
----------------------------------------------------------------------------------
Product : Notification Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixNS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 3010
Error Description :
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 3890
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 1704
Product Version (Final) : 2004
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009

View 7 Replies View Related

Job Ends Successfully Even When It's Not True

Apr 23, 2008

Hi,
we've got this problem with some particular jobs: they look as they
ran correctly, but actually they didn't made it all through their
duties.
The problem is that this job is calling a sequence of DTS, where there
is a DTS with an ActiveX control which modifies another DTS before
launching and some other tasks: the error happens there, .
Launched from the DTS we get the error, from the job no...any idea how
we could get the correct job information?
Thank you
Daniele

View 5 Replies View Related

Seeking Info On 2-node Active Passive Sql Setup

Jan 14, 2004

In desperate need of implementing a solution where the customer has purchased a CMS to replace their corporate site and wants to use MSSQL as the DB server type. I have 3 servers allocated to me to complete this and I could use some advice on the best setup.
THey're running windows 2003 standard server along with sql 2000 standard server. The intended plan is for the 2 servers to become web servers with the last server becoming the sql server. The CMS will reside soley on the sql server and the content for the web site on the seb server(s).
What I need to know is if it's possible to set up an active/passive node to accommadate this using the items mentioned above? From what I've been reading sql 2000 enterprise does clustering but I'm hoping this version of sql can be used for something.
Any responses are appreciated.

View 5 Replies View Related

SQL 2012 :: Service Accounts For Active / Passive Cluster

Aug 26, 2014

This is the 1st time we are building a active/passive cluster with 1 node each. we usually install default instance and setup domain account as service account which will have an spn delegated. Now for active/passive cluster is it ok to use same domain account as service account for both clusters with both creating as default instance again as the windows was built as SERVER1 and SERVER2.

View 4 Replies View Related

SQL 2012 :: Two Node Active / Passive Cluster Installation

May 3, 2015

Few questions on a SQL Server 2012 two node active/passive cluster installation on Win2012.

1. What are the permissions required for the user used to install SQL Server 2012 cluster. Does it need to have any rights on DC or anywhere else apart from the local nodes ?

2. Can we give ANY meaningful name to "SQL Server Network Name" during installation ? Do we need to manually configure it anywhere else before or after the installation ?

3. On what scenarios we need to check/uncheck DHCP check box ?

View 1 Replies View Related

SQL 2012 :: Node Cluster Active / Passive With 10 Instances

Jun 5, 2015

It is an active passive cluster which doesn’t allow any testing. All instances have to be failed over together, we aren’t allowed to just failover 1 even for testing purposes. Node 1 is the active node and we can failover to node 2 for 30 days free of charge but services have to then be failed back.

We need to run the cluster with node 1 as the primary node always and 2 just use for failover testing or for less than 30 day periods whilst performing cluster patch upgrades etc.

Now l am sure we could fail over 1 instances at a time for testing and diagnosing issues plus if add a new instance that's not production to get to the platform level as the rest of the instances this would avoid taking production down in the fail over process.

View 5 Replies View Related

Verifying That A Task Completed Successfully

Oct 4, 1999

How can a tell if a tak completed succesfully from a stored procedure?

I have a task which is executed from a stored procedure. The sp_runtask only returns whether the task started successfully. How can I tell if it completed successfully?

Thanks

View 3 Replies View Related

Job Doesnt Stop After Finish Successfully

Jun 18, 2008

I have a scheduled job to run daily at 4 am. the job imports data from client side from text
files and puts data in our sql table.It takes around 1 hour.
the problem is it doesnt stops after the import process completes.so after one hour
i can see the data is imported into my sql table so thats fine but the job keeps running.
I tried observing that job's spid in activity monitor in sql 2005 but after one hour i cant even see
that spid but still job runs. its weird.and after that when i stop the job manually then it stops
saying job completed succcessfully.
that step is a last step and it uses windows cmd.my understanding is the job step doesnt
understands that it got finished. what should i do in here?? any ideas r appreciated
we are running the same job for another servers and its fine.

View 5 Replies View Related

I Could Not Install SQL Successfully, Gave An Error Log

Mar 22, 2007

2007-03-22 09:36:52.39 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: )

2007-03-22 09:36:52.45 server Copyright (C) 1988-2000 Microsoft Corporation.
2007-03-22 09:36:52.45 server All rights reserved.
2007-03-22 09:36:52.45 server Server Process ID is 1516.
2007-03-22 09:36:52.45 server Logging SQL Server messages in file 'd:Program FilesMicrosoft SQL ServerMSSQLlogERRORLOG'.
2007-03-22 09:36:52.57 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2007-03-22 09:36:53.26 server SQL Server configured for thread mode processing.
2007-03-22 09:36:53.48 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2007-03-22 09:36:54.31 server Attempting to initialize Distributed Transaction Coordinator.
2007-03-22 09:36:56.46 spid3 Warning ******************
2007-03-22 09:36:56.46 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2007-03-22 09:36:56.60 spid3 Starting up database 'master'.
2007-03-22 09:36:57.26 spid3 Server name is 'PRECISE'.
2007-03-22 09:36:57.26 server Using 'SSNETLIB.DLL' version '8.0.194'.
2007-03-22 09:36:57.26 spid5 Starting up database 'model'.
2007-03-22 09:36:57.60 spid5 Clearing tempdb database.
2007-03-22 09:36:57.74 spid7 Starting up database 'msdb'.
2007-03-22 09:36:57.85 server SuperSocket Info: Bind failed on TCP port 1433.
2007-03-22 09:36:57.89 server SuperSocket Info: Bind failed on TCP port 1433.
2007-03-22 09:36:57.89 server SuperSocket Info: Bind failed on TCP port 1433.
2007-03-22 09:36:57.89 server SuperSocket Info: Bind failed on TCP port 1433.
2007-03-22 09:36:58.31 server SQL server listening on TCP, Shared Memory, Named Pipes.
2007-03-22 09:36:58.31 server SQL server listening on 195.195.195.2:1433, 127.0.0.1:1433.
2007-03-22 09:36:58.31 server SQL Server is ready for client connections
2007-03-22 09:36:58.35 spid7 Starting up database 'pubs'.
2007-03-22 09:36:58.64 spid7 Starting up database 'Northwind'.
2007-03-22 09:37:00.18 spid5 Starting up database 'tempdb'.
2007-03-22 09:37:00.32 spid3 Recovery complete.
2007-03-22 09:37:00.32 spid3 Warning: override, autoexec procedures skipped.
2007-03-22 09:37:07.95 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.

View 1 Replies View Related

Completed Successfully, But Not Sending And No Error.

Sep 6, 2006

hi, i have a message queue system using sql 2005 service broker.
the code and setup is the same on both dev and live database. but
soon after i restored a live backup to dev. the queue stopped
working on dev, live is ok thou. after some trouble shooting, i
found that the server is not sending the message at all, but it says
"Command(s) completed successfully" without any error messages.

setup:

-----------------------

create message type TestQueryMessage validation = none

create contract TestQueryContract (TestQueryMessage sent by initiator)

create queue TestSenderQueue

create service TestSenderService on queue TestSenderQueue

create queue TestQueueReceiver

create service TestServiceReceiver on queue TestQueueReceiver (TestQueryContract)

send message:

-------------------------

declare @conversationhandle uniqueidentifier;

begin dialog @conversationhandle

from service [TestSenderService]

to service 'TestServiceReceiver'

on contract [TestQueryContract]

with encryption = off;

send on conversation @conversationhandle

message type [TestQueryMessage] ('blah blah blah');

result:

----------------------------------

Command(s) completed successfully.

but when i do "select * from TestQueueReceiver", there's nothing. and i sure nothing else had picked up the messages.

please advise. thanks a lot.

View 1 Replies View Related

SQL 2012 :: IP Required To Setup 2 Node Active Passive Cluster?

Aug 14, 2015

let me know apart from the following what else is required

2 for private network
2 for public network ......

1 for virtual server/windows cluster ip which is used to connect application

View 1 Replies View Related

SQL Server Admin 2014 :: Active Passive Cluster With 5 Instances

Nov 4, 2015

We have a SQL 2014 active passive cluster with 5 instances. When the cluster was installed one of the nodes was a virtual machine. As we started to have problems and this is not a Microsoft supported configuration we decided to replace the virtual node with a phyiscal one. On 3 of these 5 instances we configured static ports (1433 TCP) this was required for applications and firewall implementation.

Now with the physical node joined to the cluster we have issues with these three instances. Whenever one of these instances is moved to the passive node the server authentication is changed from mixed to windows only. I'm no SQL expert at all but to me it looks like the configuration of the instances are not replicated to the passive node? I found some similar problems on the net but these are mostly under sql 2008.

View 4 Replies View Related

How Many IP(Public && Private) Required For 2 Node Active/Passive Cluster

Jul 13, 2007

Hi all,

I have some doubt about the IP Required for configuring cluster(both Window and SQL server)

Details :
----------
How Many IP(Public & Private) Required for 2 Node Active/Passive both window and SQL server Cluster ?

IP(Public & Private) Required :
---------------------------------------
1 : For Window Clustering : 2 node Active/Passive Cluster ? How many ip ?
2 : For Sql Server Clustering : 2 node Active/Passive Cluster ?how many ip ?
3 : Is there any mathematics for that ? How to analyse the IP requirement ?

Thanks

View 2 Replies View Related

Upgrade An Active Passive Sql Server 2000 Cluster To 2005

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

Upgrading Memory In A SQL 2005 2 Node Active/passive Cluster

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

Mission: Execute Package Task Successfully!!!

Oct 21, 2002

Currently, I'm developing an ETL program using Microsoft DTS on SQL Server 2000.

I've completed unit testing & component testing for all inner packages containing various types of executions - SQL task, ActiveX Script task, Error Handler, Transform Data task, Data Driven Query & Dynamic Properties task.

When unit & component tested, all inner package properties-"Limit the maximum number of tasks executed in parallel" is defaulted to 4.

However, the integration testing is failing because I've yet to successfully execute any of the Package tasks in the outer package, which runs & controls all inner packages from the outer package.

The error message encountered was:
---------------------------------------------------------------
| Error source: microsoft dts |
| Error description: execution was cancelled by another user. |
---------------------------------------------------------------

Please explain what might be the cause to this problem when I'm executing the outer package?

View 1 Replies View Related

A Self-generated Certificate Was Successfully Loaded For Encryption?

May 30, 2007

Log shows (on SS2005)
��A self-generated certificate was successfully loaded for encryption�?

No encryption is used. Properties of Protocol for MSSQLSERVER shows no for Force Encryption, certificates are empty

How, why, where from and what for does it get and load self-generated certificate?

View 1 Replies View Related

Query For Returning The Last Time A Specific Job Ran Successfully

Feb 18, 2008

I have a program that is automatically ran through a job. The program gets the most recent files that have been uploaded to a server. I would like to be able to query the database to see when the last time this job was ran successfully and set this date as the date to look for files newer than the last successful run date.

Could someone point me in the right direction to what tables this data is stored in on a 2005 SQL Server Database?

View 3 Replies View Related

SSIS Pkg Run Successfully But Data Does Not Load Compelety..

Apr 18, 2007

I have this data in a flat file and I'm doing a data dump to a SQL table. I created a SSIS package which ran successfully but only exporting 2 rows out of 4 rows to the SQL table. For some reason my package ignore two other rows where "col4", "col5" and "col6" do not have any data. No conditional component was used in this package to not to load those records.

col1 col2 col3 col4 col4 col5 col6

849833 02/15/06 841 VS 791 49 7
849819 02/15/06 212 NA

949070 02/15/06 230 ABS

700010 02/15/06 820 VS 690 46 6

Any idea? Thanks.

View 8 Replies View Related

Recovery :: AlwaysOn Cluster Did Not Fail Over Successfully

Aug 14, 2015

I have had a serious issue with a production AlwaysOn cluster whereby the service did not successfully transition to the secondary node and I cannot find the root cause of the issue.

Some details: It is a 2 node cluster (same datacenter) with a shared disk quorum, Windows Server 2012, both are virtual machines running on VMWare vSphere 5.5. SQL Server version is 2012 Enterprise SP2 CU6

The failover occurred because of a network incident (a spanning tree recalculation caused a connection timeout between both nodes). Initial entries in the SQL Log look normal for this event, for example:

05/08/2015 11:18:06: A connection timeout has occurred on a previously established connection to availability replica 'FIN-IE-PA078' with id [6910F4A9-87E7-4836-BA79-0F41BE90266D]. Either a networking or a firewall issue exists or the availability replica has transitioned to the resolving role.
05/08/2015 11:18:06: AlwaysOn Availability Groups connection with secondary database terminated for primary database 'UserManagement' on the availability replica with Replica ID: {6910f4a9-87e7-4836-ba79-0f41be90266d}. This is an informational message only. No user action is required.

[code]....

My interpretation of this is that the cluster failover attempts failed, because the network condition still persisted. The network interruption lasted approximately 2 minutes, and I would have expected the cluster to come back online at this point, after the restart delay period as suggested in the last entry in the error log. However this did not happen.

View 10 Replies View Related

Best Method For Installing SSIS On Production SQL 2005 Sp1 Active/passive Cluster?

Jan 7, 2008

Greetings,

I need to install the SSIS components on the referenced database server. I believe the SSIS components are cluster aware, so I was planning on just doing add/remove and selecting the components. Rather than breaking the cluster apart to patch the components back to SP1, I was thinking of just running the SP2 install right over the top of the running cluster to bring everything up to SP2.

I'm looking for any suggestions/comments on whether this is the proper way to proceed or if I'm going to have a problem.

TIA

View 1 Replies View Related

Rolling Back Transaction After .Commit() Runs Successfully

Jun 10, 2007

I have a page that runs a transaction correctly after a button click.
I want to allow someone to click a button that rolls back the transaction, after the transaction runs on the first button click.
I can also successfully roll back within the first button click.
I'm getting a NullReference error when trying to access SqlTransaction.Rollback() outside the button click.
If SqlTransaction.Commit() completes without error can SqlTransaction.Rollback() be called after?
I tried making 'trans' a more global variable and it still gave me the error.
Button Click 1:
Dim trans As SqlTransaction
trans = connection.BeginTransaction()
try
'run SQL Statement
trans.Commit()
Catch e As Exception
trans.Rollback()
throw e
end try

Button Click 2:
trans.Rollback()

View 4 Replies View Related