SQL 2016 and SQL VM's

  • any one suggest on this...

    1) Can we install SQL 2016 evaluation version on our Office Test Server ? is it recommended by Microsoft ?

    2) We have one Virtual server in our office network for DBA testing purpose with windows 2012 R2.

    I want setup Windows cluster and SQL cluster in Hyper-V so I need to created 3 virtual servers (DC,node1 and node2).

    My Question is.. do we need licenses for windows and SQL Server for above VM's ?

    3) I have installed through CMD Hyper-V on Virtual Server (windows 2012 R2) and on which, created one VM but I unable to start the VM, getting error as "one of the Hyper-V component not installed".

    My Question is.. Can we create Hyper-V VM's on Virtual Server ?

    4) Is there any solution to create test environment for Windows/SQL cluster in Hyper-V without Physical Server ? as our client won't provide Physical Server, They provided Virtual Server only.

  • 1) Yes you can install it. Not really. I wouldn't recommend installing a CTP version of SQL Server onto any server I want to keep afterwards as you can't always install RTM releases, uninstall CTP releases and they can overwrite files or alter behavior for other instances on the server.

    2) Yes. The short answer is all Windows and SQL Servers must be licensed. If they are non-production then you can license them with developer edition or through MSDN subscriptions. You can also use free 180-day trial licenses.

    3) It depends what hyper-visor your virtual machine is running under. Hyper-v is not supported on hyper-v but you can find blogs explaining how to get it to work. I would not recommend this if there are any other virtual machines you value on the same host!

    4) Yes although it depends what you want to try out. If you want to try failover clusters without shared storage you will have to emulate shared storage which isn't that easy. If you just want to try out SQL Server 2016 features without client data volumes and performance use either an Azure standalone image (trial subscriptions are easy to setup) or the Microsoft Virtual Labs https://www.microsoft.com/en-gb/server-cloud/support/learning-center/virtual-labs.aspx. If you want to run realistic tests of client database applications on SQL Server 2016 CTP then you will probably need a Windows Server Failover Cluster built by the client on which you can install SQL Server 2016 CTP.

Viewing 2 posts - 1 through 1 (of 1 total)

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