Recovery :: Combining Clustering And Availability Groups Listener

Jun 22, 2015

We are trying to build HA and DR environment, combining AG and FCI. So we have 3 servers added to a cluster, 2 of them sharing the same storage and working as ACTIVE-PASSIVE cluster instance. The other server has a stand alone instance with its local storage, with the same drivers letters as the cluster instance.

Between the Active FCI and the Stand Alone, we set up an Availability Group. They are running fine, except by the listener. When the stand alone instance owns the Primary Replica, I am able to access the SQL Server instance by the listener, but when the Primary Replica is owned by the FCI, I can't reach the database by the listener (name or IP).

I've opened the same ports in both servers, it hasn't worked though.

View 14 Replies


ADVERTISEMENT

SQL Server Admin 2014 :: Availability Groups - Adding One More Listener

Sep 1, 2015

We have a server A and a server B setup with SQL2014 High Availability - working fine.

I need to add an additional listener to our new DR site.

What is the best way to do this without impacting production - can I just add the additional replica from nodea as a secondary replica?

View 1 Replies View Related

Recovery :: Availability Group Listener Connection Without Port

May 27, 2015

In our(my company) current design we want to switch from failover clustering to Always On as high availibility solution.

I am currently testing the availiblity Group Listener function and have two questions regarding this.

First of all, is it possible to connect to a a listener by just using its "name" instead of "name,port", it is for our users very inconvenient to start using ports. If this is possible, where can I find information on how to configure this?

Second, is it possible to use the Availiblity Group Listener as loadbalancer or in combination with a loadbalancer to split the users over two or more nodes?*note we don't use azure.

View 4 Replies View Related

Recovery :: Always On Availability Listener With Multiple IP Addresses For SharePoint 2013

Apr 14, 2014

I think theres something I'm missing about AG listeners. My test config is 1 SharePoint WFE & 2 SQL servers configured in an AAG.WFE, SQL1 & SQL2 servers are all on the same subnet.On the WFE, I configured an alias called SP15 to be used for the SQL  servers. If I failover from SQL1 to SQL2 I just need to change where the alias is pointing on the WFE. So why do I need a listener? This works fine, albeit manually.I have read on some posts that an automatic failover process is possible. How can I add a 2nd IP address to the listener when both SQL servers are on the same subnet? The GUI doesn't seem to allow this.

View 5 Replies View Related

Recovery :: Fail To Create Availability Group Listener With Multiple Subnets

Oct 28, 2015

I am setting up a new pair of SQL 2014 enterprise servers in HA using Availability Groups. One of the servers is located here in our local datacenter (10.0.1.x) and the other SQL server is in our remote datacenter(172.16.1.x). I was able to setup the Windows Failover Custer without much issue. I setup the AG but when I try to setup the listener. I get the following error. I have setup an IP for both networks on the listener. I have confirmed that there is not any DNS records created for AG listener name. But I still get this error.

View 6 Replies View Related

Recovery :: Unable To Connect To Availability Group Listener From Remote Server Without Using FQDN

Jul 21, 2015

Environment: SQL Server 2014 on Windows Server 2012 R2.

We have our availability group configured and working.  However, when we try to connect to the AG listener from a remote server, we have to use the fully qualified domain name (FQDN) to connect.  We'd like to be able to connect just using the host name.  Interestingly, ping actually resolves the IP correctly for either.

View 3 Replies View Related

Recovery :: Cannot Create Listener For High Availability Group Of AlwaysOn On Cluster Environment

May 27, 2015

I have getting issues when i am creating listener for always On . Error shown as below

Can not bring  the Windows server fail over cluster (WSFC) resources online. (Error Code 5942). The WSFC service may not be running or may not be accessible in its currents states, or the WSFC resources may not be in a state that could accept the request.

For information about this error code see "system error code" in windows development documentation 

The attempt to create network name and IP address for the listener is failed. The WSFC service may not be running or may not be accessible in its currents states or the value provide for the network name and IP address may be incorrect. Check the state of the WSFC cluster and validate network name and IP address with network administrator. (Microsoft SQL Server error 41066) ...

View 2 Replies View Related

Recovery :: Set Up AlwaysOn Availability Groups?

Sep 16, 2015

Can we set up always on availability groups in  server 2012 standard edition.

View 3 Replies View Related

Recovery :: AlwaysOn Availability Groups - Download Hotfixes

Oct 19, 2015

I'm doing a certification process using AlwaysOn, and was using the link below, and on the lower 90 hotfix, and instead of downloading one by one, and then upgrade one by one updates, is there any way to make it more faster or practical, or unfortunately have to do this one by one, so the download as the update? This rollup contains the latest version of the Windows system files that are updated after the release of SP1. URL...

View 2 Replies View Related

Recovery :: Replicate Server Database To AlwaysON Availability Groups

Dec 1, 2015

I have configured replication between Always ON Availability Groups  (Listener) (PUBLISHER), remote distributor to XYZ SUBSCRIBER...with above link ...

Now, I want to know how to replicate Data from XYZ SERVER a PUBLISHER to Always ON Availability Groups  (Listener) (SUBSCRIBER)? Distributor Database being on XYZEX:

XYZ SQL SERVER as PUBLISHER, and DISTRIBUTOR 
to 
Always ON Availability Groups  (Listener) SUBSCRIBER...

View 3 Replies View Related

Recovery :: AlwaysOn Availability Groups Server Logins Fails When Switching Between Nodes

Jul 9, 2015

I am setting up a 3 node cluster as part of an availability group.Initially I tested failover between nodes using SQL Management Studio and everything failed over successfully when I stopped a node, and I was still able to write queries. I started to test with an application which connects using an SQL user and whenever I would switch nodes, I would get login failed. I believe the cause of this issue is because the server logins SID's which are tied to the database are different than the server logins on the other nodes which resulted in login failed.how can I ensure that the server logins SID's are the same between nodes? Is there a way of copying this over or how is this supposed to be done? I read a little about contained databases where I could just set the login on the database itself vs. creating a server login but I would rather not go down that route. 

View 4 Replies View Related

SQL 2012 :: Using Availability Group Listener For UNC Connection?

Sep 10, 2014

I have set up a couple of servers in a SQL 2012 AlwaysOn Availability Group (non FCI). I have also configured a Listener which enables SQL clients to connect to the server currently servicing the database, as expected.

I would also like non SQL clients to be able to connect to the server currently hosting the database so that they can run scripts sitting in a share. I don't have a shared disk so just have a directory share on each server with the same scripts in each directory.

I am able to ping and RDP to the listener IP address/name and end up on the correct server but am unable to connect to the share ListenerNameShare. Is that actually supported? If it is, any thoughts on what I need to do to get it going. If it isn't what other options do I have?

View 0 Replies View Related

SQL 2012 :: Availability Group Listener Port

Oct 26, 2014

So I have Availability groups configured as well as the Availability Group Listener, what If I want to change the port that the listener is listening on, do I need to reboot the server or is it dynamic across the board ?

View 5 Replies View Related

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

AlwaysOn - Use Availability Group Listener Or Just Point To Cluster Name

May 6, 2014

I have MasterDataServices installed on a server and the database is in an AlwaysOn Availability Group.The MDM front end currently is set up incorrectly and is referencing NodeA (primary node) for its database.I want to fix this but im unsure if i should:

-point the MDM front end to the cluster name, so it wont matter what server the databsae is on?
-create an Availability Group Listner, which would also decoupple the database referenced from a particular server.

View 5 Replies View Related

SQL 2012 :: AlwaysOn Availability Group Listener DNS Resolving To DR Node

Jan 19, 2015

We are rolling out the use of Availability Group listeners to our SQL Server 2012 Environment which has a 2 node multi-subnet cluster. The Primary is R/W and the Secondary is a non-readable node that would be manually failed over to in a DR scenario

I have set up the AGL and asked the sysadmins to create a DNS record in both subnets with fixed IP's.

The issue I have having is that when I ask the app developers to connect to the databases using the AGL it is totally random whether the AGL resolves to the Primary or DR node - as a result that are having problems getting their apps to connect.

I was thinking of asking the sys admins to remove the DNS record in the DR subnet and then add it back in should we need to fail over - but I was thinking there must be a better way.

View 3 Replies View Related

Kerberos Ticket Encryption Type And AlwaysOn Availability Group Listener

Jul 6, 2015

I ran into a Kerberos authentication issue because of a missing AOAG SPN. Some of the tickets that granted me access to the nodes of the AOAG cluster were using the encryption type that I would expect. However, the MSSQLSvc SPNs were not using what I would expect!

klist

#XX> Client Somebody@somedomain.com
Server: RPCSS/MySQLServer@somedomain.com
KerbTicket Encryption Type: AES-256-CTS-HMAC-SHA1-96

#XX> Client Somebody@somedomain.com
Server: MSSQLSvc/MySQLServer@somedomain.com
KerbTicket Encryption Type: RSADSI RC4-HMAC(NT)

#XX> Client Somebody@somedomain.com
Server: MSSQLSvc/MyAOAGListener@somedomain.com
KerbTicket Encryption Type: RSADSI RC4-HMAC(NT)

I can't seem to figure out what the next step should be, and the infrastructure admins are stumped as well. How to proceed?

View 5 Replies View Related

SQL Server Admin 2014 :: Disconnected From Listener In Availability Group (When Primary Failed)

Jun 27, 2015

I setup an availability Group. (Only 2 servers - Primary And secondary) -- 21 , 22

I also define an listener . IP .. 23

1- In First step I connected To Listener (23) And in a while I inserted A record to a table .

While 1=1
insert into Tbl_T1(f1,f2) Values (1,2)

2- in second, I Stop the primary .

- I expected this while whitout disconnect, continue.

3- The while code stopped whit this message :

Msg 64, Level 20, State 0, Line 0 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

4- I execute again the script, And it worked in new primary.

My questions :

1- is the listener disconnected between switched primary and secondary ? OR have we data loss between switching?

2- I did some huge update on Primary that fill the Log fiel space. And in last Update I got this error :

Msg 9002, Level 17, State 2, Line 27

The transaction log for database 'Your_DB' is full due to 'LOG_BACKUP'.

Is this (Fill All space) a reason to switch primary? Or not ?

View 2 Replies View Related

Recovery :: Why Listener Has Two DNS Entries

May 30, 2015

why my listener has two dns entries? Shouldn't it only have the active node's address? I have the cluster RegisterAllProvidersIP set to 0. We have two synchronous local sql 2012 servers on windows 2012 r2 and one remote (different subnet) asynchronous node.  Is it safe to manually delete the dns record that's pointing to our remote listener?  Why did it add both of them?

View 7 Replies View Related

Recovery :: Need A Third Network / Subnet For AG Listener

May 20, 2015

I have setup two node SQL 2012 Always ON cluster with file share witness. I have configured two networks, one for heartbeat and second for public.My question is do I need a third network/ subnet for AG Listener? Which network does the SQL user databases in the AG group use to replicate between the replica servers?When I do the SQL backups, do I need to backup primary and secondary replicas or just backup the databases in the secondary replica?

View 4 Replies View Related

Recovery :: Migrating Existing Availability Group To New Datacenter Availability Group

Nov 20, 2015

need to migrate a cluster with an AG dtabases to new data center cluster with AG.

I was wondering if is possible to do mirroring on top of the AG configuration? or what other options could be to migrate a cluster that has 3 nodes and setup the ag databases to a new datacenter.

View 17 Replies View Related

Clustering For Availability And Performance

Aug 19, 2007

Hi,
I'm a businessperson, not a software engineer, so please bear with me if my questions seem simple.

We are about to migrate from MS SQL Server 2000 to 2005. In our 2000 deployment, we have a primary server, with real-time replication to a backup. If we have a hardware failure, we do a manual failover to the backup server. This has served us well for years, with decent performance and no data loss. The SQL server is accessed by a pair of IIS servers, which use network load balancing to split the load between them.

As part of the forthcoming migration to SQL 2005, we are going to a hardware platform with 2 SQL servers sharing a single storage array. We would like to get the performance benefit of utilizing both of the SQL servers to handle requests simultaneously, and not just have the second server as a backup. Ideally, the two IIS servers would dish requests to both SQL servers, either randomly or in some sort of load-balanced manner.

So here is my question: how can we have both SQL servers active and handling requests simultaneously, achieving both high perfromance and high uptime?

If it is not supported natively in SQL Server 2005, is there a third-party software solution that can achieve this?

Finally, where else should I go to do further research on this subject?

Thanks in advance for any help you can offer.

View 4 Replies View Related

Recovery :: Application Not Able To Connect To Listener Name Soon After Failover

Aug 14, 2015

After manual AG fail-over from primary to secondary the application is not able to connect the listener name for atleast for 5 - 10 mins

The telnet fails during this time from app server, the listener ip is on muti-subnet.

At the same when i try to connect it from SSMS from a remote machine it works fine.

View 2 Replies View Related

Recovery :: Adding Additional Listener To New DR Site

Sep 1, 2015

We have a server A and a server B setup with SQL2014 High Availability - working fine.

I need to add an additional listener to our new DR site (SQLNODECOLO). 

What is the best way to do this without impacting production?

Can I just go to server A and add the new listener server here (SQLNODECOLO):

View 4 Replies View Related

Recovery :: Unable To Connect Listener After Manual Failover

Jun 22, 2015

I am not able to connect listener after manual failover.

(This is test environment)

Server1,Server3 -> Both synchronous (Within Same data center)
Server 3 -> Async (At DR location) -Forced Failover

Test1:
Failover Server1 to Server2 --> Able to connect Listener
Failover Server2 to Server1--> Able to connect Listener.
Failover Server1 to Server3--> Able to connect Listener.
Failover Server3 to Server1 or 2 --> Unable to connect Listener. Unable to ping Listener.
Failover Server 1or2 to Server3--> Able to connect Listener.

I am using below sub-nets:
10.11.192.0/22      10.11.192.130
10.12.192.0/22      10.12.192.140

View 3 Replies View Related

Recovery :: Will AG Listener Create A Single Failure Point

Sep 16, 2015

Assuming all windows servers belonging to the WSFC are on the same subnet, will the AG listener become a single failure point in system if all Application servers connect to the AG through the listener? If the answer is yes, what are the options to resolve this issue?

View 3 Replies View Related

Recovery :: AlwaysOn Listener - Force Connection To Secondary For AD Group

Nov 6, 2015

I have a two node HA Always on group using a Listener.  I would like to force a certain AD group to always be forced to the secondry node as they would only ever need to run select statements. If there an easy way to do this without using logon triggers?

View 6 Replies View Related

SQL 2012 :: Database Can't Be In Two Availability Groups

Jun 30, 2014

I been trying to learn availability groups since I have not implemented it.

From my understanding you can have more than one group.

Lets pretend we have two groups in one instance:

1. Accounting
2. Engineering

From my understanding you can't make a database in two AG because it wouldn't make sense.

But lets pretending there is one database that both are used by accounting and engineering.

Would you have to make a third AG for future fail overs so that other databases in the other two group don't failover when not needed because when you fail over an AG all the databases inside it fail over.

View 3 Replies View Related

Combining Groups In Report

Jun 24, 2008

Is there a way to combine groups that you've set up in a report?

For example:

I am pulling information that is entered by a form. The 4 possibilities are (blank), Y, N, and P, which has been made into a group to uniformly sort these options with a sum of how many users have each answer:

(blank) 10
P 20
Y 35
N 100

However, (blank) and N are pretty much the same thing...so I'd like to combine those results like this:

N 110
P 20
Y 35

Any help is appreciated!

View 6 Replies View Related

SQL 2012 :: Multiple Availability Groups On One Instance

Aug 12, 2013

From what I understand, one SQL Server 2012 instance can host multiple availability groups. That should allow, for example, the following situation - one SQL Server 2012 instance containing three primary replica databases - each one part of a different availability group - and each availability group's secondary replica located on a separate SQL Server 2012 instance.

Can you have three SQL Server 2012 instances, each with one primary replica database and have all three secondary replica databases on one SQL Server 2012 instance? So instead of, as above, going from 1 primary server to 3 secondary servers, this time we're going from 3 primary servers to 1 secondary server? The one secondary server would then contain all three secondary replicas for each of the 3 separate primary replicas.

This would mean that the single server (where all three secondary replicas reside) was part of three separate Windows Server Failover Clustering clusters.

Is this scenario possible?

View 4 Replies View Related

SQL 2012 :: AlwaysON Availability Groups And Listeners

Feb 13, 2014

I have four instances and each instance have its own Availability Group with its own listener.

Would like to know if you can have one listener for multiple Availability groups?

View 2 Replies View Related

SQL 2012 :: Renaming AlwaysOn Availability Groups?

Apr 28, 2014

We had 3 Availability Groups set up in SQL 2012 last year but they were poorly named so I am just looking to rename them but there doesn't seem to be any command for it that I can find.Can they not be renamed once created? I guess I could just create new ones and move the DB's into them but just thought I would check!

View 1 Replies View Related

SQL 2012 :: Bulk Loading In Availability Groups

Aug 14, 2014

I have several 2012 availability groups running on a cluster. I have one database that is bulk loaded every 30 minutes. The DB is about 1 GB in size. To be on the availability group it has to be set to full recovery mode, but simple or even bulk would obviously be better. Is there a better way to handle the transaction log size other than to run a backup after each bulk load causing extra overhead? With mirrors you could use simple, but since those are going away . . .

View 2 Replies View Related







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