SQL Server with Mr. Denny

Aug 6 2012   10:00AM GMT

Vendor Apps and AlwaysOn Availability Groups



Posted by: Denny Cherry
Tags:
AlwaysOn
Availability Groups
Database
Microsoft Cluster Service
MSCS
SQL Server
SQL Server 2012
SSMS

By now hopefully everyone knows about AlwaysOn Availability Groups in SQL Server 2012 and the high availability options that they provide to databases.  One problem with AlwaysOn Availability Groups when combined with third party applications is that the third party application may configure the connection string and not allow you to change it.  When you want to install one of these third party applications within a SQL Server 2012 availability group this can give you some problems as typically you would typically create the database then add the database to the availability group.  However this requires that you change the connection string which in this case we are trying to avoid.

There however is some good news to this little problem.  The good news in this case is that you can create a SQL Server availability group, which has an availability group listener, without putting any databases in it.  This is done by creating the availability group without using wizard that is available within SQL Server Management Studio.  Instead of starting the wizard select the “New Availability Group…” option from the Availability Group context menu as shown below.

This will allow you to create an Availability Group without any availability groups and with only a single replica.  Once the availability group is created, the listener can be created for the availability group.  The 3rd party application can then use the listener to connect to the database engine and create the database.  The database once created can be added to the availability group as can the additional replicas.

While using this technique is a lot harder than going through the wizard as it requires that the database backups and restores be done manually and the configurations be all done by hand instead of the handy wizard it’ll meet the requirements of the application which is to not change the connection string.

Denny

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: