0

I have a 2 node WSFC cluster with SQL Server 2014 installed on each for AlwaysOn.

This is working fine. My question is can I install another instance of SQL Server 2014 on these nodes for another AlwaysOn configuration.

I have a requirement that Skype for Business (SFB) has to be on its own instance to be supported and can't be installed on the existing AlwaysOn already up and running for some other DBs.

1

Unless you can point to the direct requirement you are referring to, I do not see any requirement in Skype for Business (SFB?) that states it has to be on a dedicated instance.

I think what you may be referring to is the database needs to be in a dedicated Availability Group. If that is the case you can create another AG on the same instance and cluster to support your database for SFB. A given SQL Server instance can support multiple AGs and each one can have their own listener.

  • Yes this is Skype for business. The var doing the install is telling us about the requirement. If I create a separate availability group do I need a new listener? So can the same default sql instance have 2 listeners and ag's? – JMartinez May 29 '16 at 2:00
  • Correct, you can create multiple AGs and each one can have their on listener. – Shawn Melton May 29 '16 at 4:54
  • You may want to use a different instance as SFB install changes some system level settings that you may not want for your instance. Things like cross database ownership chaining. – Sean Gallardy May 30 '16 at 1:10
-2

Yes, I believe you can have a separate AG on the same servers but you would need to use different named instances.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.