i have a issue on SQL Alwayson configuration

Category: sql server mirroring

Question

VBRS on Thu, 11 Dec 2014 00:33:56


i am trying to configure always on with 3 servers.

Server1 (domain controler)

Server2 and server 3

i have installed windows server 2008 R2 service pack 1 and install WSFC Hotfix KB2494036 for all servers.

after installation i have rebooted and restarted sql services also.

but in server1 i can't enable to always on.

please help on this issue.

thanks in advance

Vijay

Replies

Balmukund on Thu, 11 Dec 2014 01:16:05


Server1 (domain controler)

..

but in server1 i can't enable to always on.

That's expected.

It's documented restriction of AlwaysOn Availability Groups. Refer http://msdn.microsoft.com/en-us/library/ff878487.aspx. Read section "Checklist: Requirements (Windows System)"

VBRS on Wed, 17 Dec 2014 14:43:07


HI Bala,

One more question for OS configuration.

shall i configure different versions of OS like one node is windows 2008 and some other node  2008 r2 or 2012.

Alwayson works only SQL Server 2012 Enterprise? or any other versions.

thanks in advance

vijay

Balmukund on Wed, 17 Dec 2014 14:50:50


HI Bala,

Balmukund would be better :)

One more question for OS configuration.

shall i configure different versions of OS like one node is windows 2008 and some other node  2008 r2 or 2012.

I don't think Windows would allow that.

Alwayson works only SQL Server 2012 Enterprise? or any other versions.

SQL 2012 Enterprise and SQL 2014 Enterprise

thanks in advance

vijay

Thanks!

VBRS on Wed, 17 Dec 2014 18:29:40


HI Balmukund,

Sorry for misspell your name as "BALA".

thanks for your reply.

Vijay bhaskar