RE: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-22 Thread Melvin Backus
Gee, an outdated doc? J That could still be a published requirement but I’m not sure what functional difference there would be. Our SQL 2014 cluster is running on Std. I didn’t set it up but I know we had to use Enterprise on our Exchange servers running 2008r2, and that was one of the

Re: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-18 Thread Michael Leone
On Thu, Aug 17, 2017 at 2:12 PM, Mayo, Bill wrote: > I haven't done it since Windows 2008 R2, but Microsoft clustering does work > in a vSphere environment if you have the shared storage (sounds like you do). I had MS clustering working on SQL 2008 R2 running on 2

Re: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-17 Thread Kurt Buff
Wouldn't never! Musta been someone else... Kurt On Thu, Aug 17, 2017 at 1:27 PM, Webster wrote: > You talking about me? [image: ] > > > > Thanks > > > > > > Carl Webster > > Citrix Technology Professional | iGel Tech Community Insider | Parallels > VIPP > >

Re: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-17 Thread Kurt Buff
Someone ought to hire whoever wrote that article - it's very nice. Kurt On Thu, Aug 17, 2017 at 1:27 PM, Webster wrote: > http://carlwebster.com/implementing-microsoft-sql- > server-2016-standard-basic-availability-groups-use- > citrix-xenapp-xendesktop-7-9/ > > > >

RE: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-17 Thread Webster
You talking about me?  Thanks Carl Webster Citrix Technology Professional | iGel Tech Community Insider | Parallels VIPP

RE: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-17 Thread Webster
http://carlwebster.com/implementing-microsoft-sql-server-2016-standard-basic-availability-groups-use-citrix-xenapp-xendesktop-7-9/ Someone wrote on article on that very topic. Thanks Carl Webster Citrix Technology Professional | iGel Tech Community Insider | Parallels VIPP

Re: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-17 Thread Kurt Buff
The link you provided is helpful - thanks. According to our EA summary, I have an effective quantity of 4 x SQL Server Standard Core 2016 licenses, with an unresolved quantity of 20 and an SA quantity of 16, though I'm not entirely sure what all that means. Kurt On Thu, Aug 17, 2017 at 11:17

Re: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-17 Thread Kurt Buff
Thank you. That's very helpful. Kurt On Thu, Aug 17, 2017 at 10:52 AM, Michael B. Smith wrote: > Yes, it will work. > > I cannot say anything whatsoever about VMware. I'm a Hyper-V guy. > > -Original Message- > From: listsad...@lists.myitforum.com

Re: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-17 Thread Kurt Buff
Who was just on a list asking for help with VMware configuration? H? 樂 Kurt On Thu, Aug 17, 2017 at 10:59 AM, Webster wrote: > Everyone has their faults.  > > > Webster > > -Original Message- > From: listsad...@lists.myitforum.com

Re: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-17 Thread Nathan Shelby
"Server Standard does NOT support Always On Availability Groups" Sort of? As of SQL 2016, It supports Basic Availability Groups which are AGs with limitations, they are managed the same way as a standard AG. They don't scale particularly well but they avoid the pitfalls of a WSFC SQL

RE: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-17 Thread Mayo, Bill
I haven't done it since Windows 2008 R2, but Microsoft clustering does work in a vSphere environment if you have the shared storage (sounds like you do). -Original Message- From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Michael B. Smith Sent:

RE: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-17 Thread Webster
Everyone has their faults.  Webster -Original Message- From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Michael B. Smith Sent: Thursday, August 17, 2017 12:52 PM To: ntsysadm@lists.myitforum.com Subject: RE: [NTSysADM] A new task for me -

Re: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-17 Thread Kurt Buff
Right. Server Datacenter. Knew that. Habit to type Enterprise. The rest is stuff I'm trying to figure out, since I haven't played around much with real SQL Server since the 2000 edition, and not even much with Express since then. We are planning a 2-node cluster, so it sounds like Windows Server

RE: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-17 Thread Sean Chapman
Server Enterprise has not existed since 2012 came out. Standard and Datacenter both are licensed for Failover Clustering with the only difference being virtualization rights. From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of D R Sent: Thursday, August

RE: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-17 Thread Michael B. Smith
I think y’all are confusing yourselves. Words mean things. For the purposes of this discussion, there is no such thing as “Windows Server Enterprise”. The editions are Windows Server Standard and Windows Server Datacenter. Since Windows Server 2012, both Standard and Datacenter include Windows

Re: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-17 Thread D R
According to the Techs and Sales people in my org, it seems that they did. They are telling me that every SQL Clustering needs Enterprise on 2016, or it's a 'no go'. Daniel On Thu, Aug 17, 2017 at 9:22 AM, Micheal Espinola Jr < michealespin...@gmail.com> wrote: > As best as I can recall, it

RE: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-17 Thread Micheal Espinola Jr
As best as I can recall, it was listed as a requirement in the last SQL clustering requirements doc I read on Microsoft's website. I thought it was up-to-date, but perhaps I am mistaken? On Aug 17, 2017 6:55 AM, "Melvin Backus" wrote: Windows clustering doesn’t

RE: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-17 Thread Melvin Backus
Windows clustering doesn’t require Enterprise any more. It moved to std with 2012. We run both LB and FO clusters on 2012 std. Please don’t tell me they went back with 2016. L -- There are 10 kinds of people in the world... those who understand binary and those who don't. From:

Re: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-16 Thread Kurt Buff
Got it. I can do that - we have an EA. Thanks. Kurt On Wed, Aug 16, 2017 at 6:24 PM, Micheal Espinola Jr wrote: > The minimum requirement would be Windows. > > -- > Espi > > > On Wed, Aug 16, 2017 at 6:07 PM, Kurt Buff wrote: >> >> Windows or

Re: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-16 Thread Micheal Espinola Jr
The minimum requirement would be Windows. -- Espi On Wed, Aug 16, 2017 at 6:07 PM, Kurt Buff wrote: > Windows or SQL or both? > > On Wed, Aug 16, 2017 at 5:27 PM, D R wrote: > > Well, for 1, I think you're going to need Enterprise Edition for your >

Re: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-16 Thread Kurt Buff
Windows or SQL or both? On Wed, Aug 16, 2017 at 5:27 PM, D R wrote: > Well, for 1, I think you're going to need Enterprise Edition for your server > clustering. > > > On Wed, Aug 16, 2017 at 6:04 PM, Kurt Buff wrote: >> >> Does anyone have a good

Re: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-16 Thread D R
Well, for 1, I think you're going to need Enterprise Edition for your server clustering. On Wed, Aug 16, 2017 at 6:04 PM, Kurt Buff wrote: > Does anyone have a good reference on setting up a 2-node cluster like this? > > I'll be putting up SQL Server 2016 on Server 2016

Re: [NTSysADM] A new task for me - setting up a SQL Server cluster on vSphere 6.0

2017-08-16 Thread Kurt Buff
Hate doing this, but I forgot to put in what is probably a fairly significant datum We don't have DRS - we only have vSphere Standard. Kurt On Wed, Aug 16, 2017 at 4:04 PM, Kurt Buff wrote: > Does anyone have a good reference on setting up a 2-node cluster like this? > >