Windows Server 2016

Question

Windows Server 2016

David Conn

SSCertifiable

Points: 6010
More actions
September 14, 2016 at 4:18 pm

#330186

I am planning for a new SQL Server 2016 install. I have tested on Windows Server 2012 R2.
I'd like to go for Gold and install onto Windows Server 2016 when it's released later this month.
Will it work or is there likely to be a Service Pack required.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246976 More actions · Answer 1

I'd be stunned/amazed if it "didn't work", but Windows Server 2016 is not mentioned on this page and therefore I guess it's not guaranteed.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 2

I would wait until you see updated guidance from Microsoft indicating it's supported on the new OS. I know it won't work on Nano. Nano doesn't have all the required components.

K. Brian Kelley
@kbriankelley

David Conn SSCertifiable Points: 6010 More actions · Answer 3

So far so good.

I now have SQL Server 2016 ( Developer ) running on Windows Server 2016.

Alan Burstein SSC Guru Points: 61141 More actions · Answer 4

I have not ran SQL 2016 on Windows Server 2016 but Microsoft is pretty good about warning you during the install if the version is supported on the OS. I did run across this white paper a few weeks back:

SQL Server 2016 and Windows Server 2016: Better Together Technical white paper (April 2016)

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

DeWayne_McCallie Hall of Fame Points: 3617 More actions · Answer 5

Well SQL 2016 supports Tlog on NVRAM only with Windows 2016 per Microsoft; therefore, it better be supported.

Also MS stats SQL 2016 is supported on Win 2016:

https://msdn.microsoft.com/en-us/library/ms143506.aspx