1

This is just a really simple question before I steam roller ahead and wreck everything.

I have ordered a server that will have Windows Server 2016 installed however I have now realized that the tools we will be using only support SQL Server 2012.

I'm not sure but I think Windows Server and SQL Server are completely separate entities so would it still be OK for me to install SQL Server 2012 on a Windows Server 2016 machine?

Improve this question

1 Answer 1

Reset to default
2

Yes, OS (Windows Server) and database (SQL Server) are separate entities. So the only question is compatibility between those two products. I'm guessing it was tested and should be ok, but at this moment SQL Server 2012 doesn't have Windows Server 2016 listed (and won't have, at least not till September):

https://msdn.microsoft.com/en-us/library/ms143506%28v=sql.110%29.aspx

Best thing You can do is download latest Technical Preview and test it with SQL Server 2012 in Your environment:

https://www.microsoft.com/en-us/evalcenter/evaluate-windows-server-technical-preview

Improve this answer
4
  • Thank you this was really helpful, I will download Oracle Virtual Box and try to install the Windows Server 2016 first
    – TheLovelySausage
    Commented Aug 10, 2016 at 7:36
  • 1
    Just to confirm SQL Server 2012 works fine with W/S 2016 in general terms. I'm currently running a lot dev machines on this configuration as a test.
    – Molenpad
    Commented Aug 10, 2016 at 9:29
  • @Molenpad I would still put it through some testing process, just to check if there are any specific local issues, either hardware related or caused by 3rd party software.
    – Marcin S.
    Commented Aug 10, 2016 at 11:54
  • 1
    Yep, that's why I said 'in general terms'
    – Molenpad
    Commented Aug 10, 2016 at 13:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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