Recovery :: Connect To Cluster By IP Address

Sep 9, 2015

I have inherited two separate SQL clusters. One cluster instance is called DESQLSC1INST1 and the other is MKSQLSC1INST1.

On MKSQLSC1INST1 I can connect by using MKSQLSC1INST1, MKSQLSC1 and the IP address that the cluster is running on.
On DESQLSC1INST1 I can only connect using DESQLSC1INST1.

I have checked configuration manager but it does not show me how this is set up.

Is there another way to configure this?

View 2 Replies


ADVERTISEMENT

Recovery :: Server Local High Availability Using Failover Cluster And Disaster Recovery Using AlwaysOn

Aug 17, 2015

We have a requirement to build SQL environment which will give us local high availability and disaster recovery to second site. We have two sites- Site A & Site B. We are planning to have two nodes at Site A and 2 nodes at Site B. All four nodes will be part of same Windows failover cluster. We will build two SQL Cluster, InstanceA will be clustered between the nodes at Site A Server and InstanceB will be clustered between the nodes at Site B, we will enable Always On Between the InstanceA and InstanceB and will be primary owner where data will be written on InstanceA and will be replicated to InstaceB. URL....Now we want we will have instanceC on the Site B and data will be writen from the application available on Site B, will be replicated to the instance on the Site A as replica.

View 6 Replies View Related

Recovery :: Can Join A Node In Windows Cluster Which Is Already In Different Cluster

Oct 8, 2015

can we join a node in a windows cluster which is already in a different cluster?

We have this requirement as we need to setup readable secondary ( always on AG) on the third node.

View 2 Replies View Related

Recovery :: IP Change For Cluster / Nodes And Windows Cluster?

Jul 15, 2015

We are planning to change all IPs of PRODUCTION Failover Cluster Setup. In my cluster setup ... we have 2 Physical Nodes with windows-2008, Roles are MSDTC and SQL-2008R2.

IP change for:

1. Both Nodes(Physical)
2. MSDTC
3. SQL Server 
4. windows Cluster 

So Almost... All IPs are going to change.

Im DBA here, I need to take care of SQL cluster and MSDTC. But I haven't performed this activity before.So I'm worrying about Impacts and consequences of this change. steps how should I perform this activity.

View 9 Replies View Related

Cluster IP Address Change And Delay

May 27, 2007

Hi all,I have recently changed IP addresses on my MS SQL cluster (the new IPaddresses belongs to a different network). Both physical node's IPaddresses and resource's IP addresses have been changed.Everything seems to work fine. The cluster is up and respondingnormally. The resources failover to another node when needed correctly.However, I have noticed that the time it takes for the resource tofailover to another node is much longer than in the past (before IPaddresses change). I have noticed that "Network Name" is the resourcetype that causes the delay. Could you please advise if there issomething that I overlooked and needs to be changed.updated as well, sothat groups fail over faster?Thanks,Aleu

View 5 Replies View Related

SQL Server 2008 :: Change IP Address Of Failover Cluster Instances

Mar 9, 2011

IF you need to change the IP Address of a SQL Server Failover Cluster instance, here is the steps:

1. Open up Failover Cluster manager.
2. Expand the MS Cluster Instance that your SQL Cluster instance resides on.
3. Expand Services and applications.
4. Select the SQL Server Service.
5. In the main window pane (Middle Screen), you should see your SQL Server Cluster name, expand the plus to the left of it.
6. Under your SQL Server Cluster name, you should now see an 'IP address' section, right click on it and go to properties.
7. In the properties pane, you can change your IP address by entering a static IP.....or assigning a DHCP enabled IP.

View 1 Replies View Related

Can Connect To 'ServerName' But Not To Its IP Address

Aug 4, 2006

I'm using SQL Manager from my Enterprise server to connect to my SQL Express server that will act as a witness to a db mirroring system. If I try to connect to the SQL Express server using its IP address, I get a "named pipes error 53." If I connect by browsing the network and connect to the Name of the Server "MachinenameSQLExpress", I am successful. I would like to be able to connect to the IP directly as it's not dependant upon certain services to be started or configured a certain way.

Thank you,


Chad

View 3 Replies View Related

Connect To SQL Express 2005 By IP Address

Aug 31, 2007

Hi,

I am trying to connect to SQL Server Express 2005 from a remote connection through the internet using an IP address in a string like this;

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

the error I am getting is this

A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)


anyone have any suggestions or maybe another way to achieve this type of connection?

Thanks,

Razzle

View 1 Replies View Related

Disaster Recovery Of SQL 7.0 Cluster

Mar 5, 2001

Hi All
This is a Pearler !!. SQL 7 and NT 4

Site A and B are 30 miles apart

"Site A" SQL 7.0 Cluster with Drives on Shared Storage.
"Site B" SQL Server Cluster with Drives on Shared Storage
Both Configured as Active/Active (8+ databases <100GB total)

How can I get the DB's (all) from Site A and allow a DIFFERNET cluster to control them.

Basically, I want to move all DB's from "Site A" and bring them into "Site B" with all relevant data ..ie master DB etc . I have a time window of 90 Mins and I cannot lose one single piece of data.........( I need to lie down now)
Help would be apprecitated)

View 1 Replies View Related

Recovery :: HA Cluster Replicate To DR

Aug 3, 2015

We have an HA configuration with an Active-Passive Cluster / Shared Disk SAN which is working great.  I have been looking for how to replicate the information to our DR site.  We have many databases (some are more static vs. other transactional).  I had some questions:Would it make sense to configure a snapshot for the static databases?  Is that possible from a clustered environment using it as the publisher?Would it make more sense to configure the clustered environment to use transactional replication?  Is it possible from a clustered primary?Is log shipping too archaic?

View 4 Replies View Related

Cannot Connect To SQL Server Database Using Ado.net After IP Address Has Changed

May 4, 2004

Dear all,

I wasn't able to connect to my SQL server 2000 database (which reside in the network in a windows 2003 server) after the IP address of the server has changed and the server is shut down, moved and re-started.

I was able to connect to this server by using ADO using VB. I was able to register this server in my EM and was able to create ODBC connection. Just when using ADO.NET, I wasn't able to connect. Any ideas? Will there be any caching within ADO.NET still pointing to the old IP address?

Thank you for all the help in advance.

View 5 Replies View Related

BDE Admin Connecting Problem, How Do I Connect Via IP Address.

Jun 12, 2006

Hi, I am connecting from clientside with sql server 2005 installed trying to connect to a database running on a server with sql server 2000 installed. this is not a 2000 to 2005 compatibility issue.
I can connect locally fine to the server and log in using the sa account, however for BDE admin i HAVE to use the server name instead of ip address. If i try to use the ip address of the server, the connection dosnt get established. *this is all happening localy on our own network.

How to I use ip address to connect instead of the server name? I will need to connect remotely outside of our network later on, and i dont think I can use the servername. Does anyone have a solution? thanks.

View 6 Replies View Related

Cluster Recovery From Node Failure

Jul 20, 2005

Cluster services gives the high availability needed - that is great.But I have never seen any discussion about what happens when a nodefails - what do you do to get everything back to the active-passivetandem.I imagine there is not much difference in terms of recovery procedurefor either active or passive node. So I'm just going to make up ascenario that we have encountered. The system hard drive (not theshared disk) on primary node fails. Cluster fails over to the passivenode. Following are the problems I have at hand:-After installing windows, I need to install driver and configure thepermission to access the SAN. There is no way I could do it since thesecondary node has exclusive access to the disks.-Imagine I got that working, is there anyway to install SQL so SQLwould know this server used to be the primary node and attach the DBand translog automatically-Finally, there is no proper way to apply SQL 2000 service pack 3a.Originally when the cluster was fully functional, the service pack wasapplied to active node and that automatically upgrades passive node.Now we have a machine without 3a and a machine with 3a alreadyinstalled. See any problem?Consider all of the above as this one big question: What is a properprocedure to restore a cluster when one of the node goes down? Whetherit's the active or passive node.

View 1 Replies View Related

Recovery :: Server Cluster Installation

Aug 24, 2015

I am learning SQL Server failover cluster installation. My question is regarding the options to install failover cluster instances on the Windows Failover Cluster. I have seen ead there are two options to do so.

From the installation center, installation option-> New SQL Server installation option and afterwards add node to SQL Server failover instance.From Installation Center, Advanced option-> Failover cluster preparation and then Failover cluster completion step.What is the difference between these two options and which option to use in which scenario?

View 5 Replies View Related

Recovery :: Rebuilding A Node On A Cluster

Oct 13, 2015

We have 2 clusters, 1 running SQL 2008 on Windows 2008 R2 server and 1 running SQL 2000 on Windows 2003 Server. Because of a disaster with the disks, each of the passive nodes had to be rebuilt and Ive been asked to install SQL on the nodes.

Ive not done this before. Does this mean simply adding a new node to the cluster through the wizard? Or do I need to reinstall the entire cluster?

I think SQL 2000 is too risky as its unsupported, so Im going to resist that. But how should I approach the SQL 2008 Instance?

View 4 Replies View Related

Recovery :: Disk Not Shown By Cluster

Nov 5, 2015

I am trying to cluster two sql node server on hyper-v both virtual and my situation is below : 

two hyper-v host connected to vnxe storage 
two hyper-v are mapped to 3 LUN ( SQL Data , SQL logs , Quorurm)
connectivity between hyper-v and storage direct fiber 
three LUN are mapped to the virtual SQL01 and SQL02  as VHDX and configure it on virtual machine as  IDE below is the picture 

LUNs are presented to the guest SQL01 and SQL02  and visible through disk management

When create the fail over cluster i am not getting the disk to add them to cluster 

Getting the below error when validate the storage : 

No Disks suitable for cluster disks were found, For diagnostic information about disks available run the Validate config wizard’..

Also , regarding this LUN how i can make them shared on the host side ?

View 3 Replies View Related

Recovery :: Failover Cluster Setup

May 8, 2015

I am using SQL 2012 SE with clustering on Windows server 2008 R2. Now I want migrate it to windows server 2012 with minimal down time. So I want to evict the passive node and add a new node with windows server 2012 and install sql server 2012 SE on the new passive node and perform a failover(make the node with 2012 OS as active) and then evict the new passive node and add another node with windows 2012 and then do the same thing?

View 12 Replies View Related

Recovery :: Error When Setting Up Failover Cluster

Aug 26, 2015

I'm getting the following error when I go to create a cluster in the Failover Cluster Manager in Windows Server 2008.

"The address 10.10.10.111 is not valid for its associated network"

I'm following the instruction in the book for the 70-462 exam.  There was a step that had me create a DNS A record for the address sql-cluster.contoso.com.  The IP address was mapped to 10.10.10.111.  I'm not sure if this is the culprit but its the only time I used that IP address in the setup.

Below are 2 screenshots.  The first screenshot is the error.  The second screenshot is my DNS console.

View 7 Replies View Related

Recovery :: Setup FILESTREAM On Failover Cluster

Apr 22, 2015

I saw following point on Technet article about RBS.The local FILESTREAM provider is supported only when it is used on local hard disk drives or an attached Internet Small Computer System Interface (iSCSI) device. You cannot use the local RBS FILESTREAM provider on remote storage devices such as network attached storage (NAS).It looks like that we cannot use FILESTREAM on Failover Cluster because to setup Failover Cluster we need to have NAS. But then the NAS is made available locally for Failover Cluster so FILESTREAM should work right?Found another article which talks about setting up FILESTREAM on Failover Cluster. URL...

View 2 Replies View Related

Using 32 Bit Sql Server For Disaster Recovery Of 64 Bit Prod Cluster

Feb 16, 2007



does anyone know of any potential issues of using a 32 bit sql server 2005 instance used for disaster recovery of a 64 bit sql 2005 cluster ?

thanks

View 2 Replies View Related

Recovery :: Add Client Software To Failover Cluster?

Jul 17, 2015

The main objective is to have a third party program operate on a failover cluster.  The OS is Windows Server 2012 Datacenter loaded on 2 nodes. A virtual node exists along with supporting disks. This client software uses a SQL Server database.  SQL Server 2012 Enterprise is installed and operating in a failover environment.  However the client software is not failing over. If the connection to node A is lost, SQL Server fails over to node B.  But the client application does not. 

What needs to occur in order to associate the client software with the failover cluster?  This software has 6 services total installed. Some are referred to as servers - looks like to communicate between remote client computers and the database. What is the process to associate the client software with the failover?

View 6 Replies View Related

Recovery :: Multiple Instances For AlwaysOn For A Cluster

Jun 19, 2015

My environment has a 4 node cluster , 2 in primary and 2 in sec dc. Storage is sperate for both.

Need to setup always on for 4 Instances there on the 2 nodes of the primary dc. Is there any restriction in setting up always on for multiple instances for a cluster.

View 3 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

Recovery :: Multiple Instances Of Server On A Cluster

Aug 18, 2015

Is it possible to have more than one instance of SQL Server on a failover Active/Passive cluster? What are the concerns/ramifications if that indeed is possible?

View 4 Replies View Related

Recovery :: Failover Cluster With Mirroring With AlwaysOn?

Jun 30, 2015

we have to build high availability SQL 2012 cluster for VDI and we have two options. One option is to build a server cluster with combination of failover and mirroring and other option is to build failover cluster with AlwaysOn.We are not sure which option to chose. We have contacted Microsoft support to provide us some documents and instructions for failovermirroring combination but they have send us instructions for AlwaysOn option.

What would be best way to build high availability cluster for VDI? Also, since first option is very complicated.

View 5 Replies View Related

Unable To Use SSMSE To Connect To SQL Express Server On Secondary IP Address

Apr 28, 2006

I am having trouble to use SSMSE to remotely connect SQL Express server using IPs other than the base IP of the machine.

Machine settings:

(1) Has multiple IP configured. Those IP are accessible remotely

(2) Firewall is not on.



SQL Express server configuration:

(1) TCP/IP and named pipe are on



Browser service state:

(1) running

(2) listening at 0.0.0.0:1434 (UDP)



SSMSE connection results:

(1) with <baseIP><instance>, connects OK

(2) with <otherIP><instance>, connection failed.

Both connections use exactly the same authentication information.



Testing results using telnet:

(1) telnet <baseIP> 1434, OK

(2) telnet <otherIP> 1434, OK



Does SSMSE actually only listen on the base IP even it shows to listen on all the IPs?

View 10 Replies View Related

Recovery :: Unable To Locate The Cluster Service Executable

Jun 12, 2015

I am having Windows 2012R2 Std with SQL2012SP2.  Trying to add SQL cluster node2 but unable to locate the instance name when I click on drop down button.Understand that SQL Server Agent is required but it is not listed as cluster resource.  Therefore, I perform the followingFrom Windows Power Shell with Administrator rights

1. Import-Module FailoverClusters
2. Add-ClusterResourceType "SQL Server Agent" c:windowssystem32SQAGTRES.DLL

Error: Add-ClusterResourceType : Unable to locate the cluster service executable on node1.The network name cannot be found.No problem to ping all cluster related names as well as fail-over to and from next available node.

View 3 Replies View Related

Recovery :: AlwaysOn Cluster Down Due To ClusDB Corrupt / Missing

Sep 5, 2012

I have a 3-nodes AlwaysOn cluster (Windows Server 2008 R2 SP1 + SQL Server 2012 RTM), Node Majority quorum, the quorum vote for each node is 1. 

Today the AlwaysOn AG was suddenly down due to the cluster service on node 1 stopped and can't be started.

The error in eventlog is - 

The cluster database could not be loaded. The file may be missing or corrupt. Automatic repair might be attempted.
The Cluster Service service terminated unexpectedly.  It has done this 2 time(s).  The following corrective action will be taken in 120000 milliseconds: Restart the service.

The failover cluster database could not be unloaded. If restarting the cluster service does not fix the problem, please restart the machine.

The Cluster Service service terminated with service-specific error The system cannot find the file specified..

The error log in cluster log is - 

0000156c.000008f8::2012/09/05-08:09:36.057 INFO  [DM] Key RegistryMachineCluster.restored does not appear to be loaded (status STATUS_OBJECT_NAME_NOT_FOUND(c0000034))
0000156c.000008f8::2012/09/05-08:09:36.057 WARN  [DM] Node 1: Failed to unload restored hive from the registry with error STATUS_INVALID_PARAMETER(c000000d)
0000156c.000008f8::2012/09/05-08:09:36.057 INFO  [DM] Node 1: loading local hive
0000156c.000008f8::2012/09/05-08:09:36.057 ERR   [DM] Node 1: failed to unload cluster hive, error 2.

Now the cluster service can't be started on node 1, error code 2. Looks like the clusdb in C:windowscluster is missing or corrupted. How to restore the clusdb file? And how to prevent this happen again?

All nodes were well patched, AlwaysOn and cluster related hotfixes were all installed. [URL] .... doesn't wok.

View 4 Replies View Related

Recovery :: Removing A Cluster Node With Hardware Failure?

Jul 20, 2015

In case of hardware unrecoverable issue, I have two msdn articles which states different things.

First one claims you remove the node from mscs.

[URL]

Second one claims you should remove it using sql server installation and links to the first link which says you should do it from mscs:

[URL]

Then this third article invalidates the second article. "To remove a node from an existing SQL Server failover cluster, you must run SQL Server Setup on the node that is to be removed from the SQL Server failover cluster instance." 

[URL]

It is a hardware faillure where the secondary node is inaccessible.

So what is the proper way to evict a node you cannot access due to a hardware failure?

note: I don't plan on adding back the failed nodes after removing it.  i.e. I am interested in the removing part.

View 4 Replies View Related

Recovery :: OS Memory Reservation For Two Node Cluster Having Three Instances

Nov 9, 2015

We are running with a 2 node windows cluster having three SQL instances on it. 

OS: Windows server 2008R2 SP1
SQL : SQL server 2008R2 (10.50.6529)

Currently both nodes have 256 GB or memory and we are having multiple auto failover for resources. What will be the best practice for OS memory reservation (OS+tools) so that we can set SQL max memory settings accordingly?

View 5 Replies View Related

Recovery :: How To Achieve Multi-site Cluster With 2 Node

Apr 27, 2015

We have two locations in US, I am thinking of having 2 node SQL cluster for Lync 2010, I alardy have One DB server running in one location, now we got new site where we are planning to have one more DB for redundancy.

View 5 Replies View Related

Recovery :: Service Pack Installation In Failover Cluster?

May 9, 2015

I want to install service pack 3 to my SQL Server 2012 Enterprise running on windows server 2008 R2 Enterprise fail over cluster, I read about the SP installation in technet, its mentioned that the passive node should be patched first and to do this the passive node should be removed from the cluster, I need to know whether I should completely remove the node from windows cluster or remove the node by using SQL Server installer and install the service pack and then add it back to the cluster, Can I do this by pausing the node in cluster and perform the service pack installation ?

View 3 Replies View Related

Recovery :: FCI Number Of Cluster Nodes Supported For Edition Failed

Nov 22, 2015

I have encountered issue by add a node to SQL cluster

Server 2012 R2 Datacenter version
SQL 2012 Enterprise edition

Error Status>
number of cluster nodes supported for edition - failed

I have failed to bypass with Setup /SkipRules=Cluster_VerifyForErrors /Action=AddNode

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved