![]() Install R Tools for Visual Studio 2015 (RTVS) (Version 0.5).Install Microsoft R Open (Version 3.3.1).Install Red Gate Azure Explorer (Version 1.1.0.43).Install Microsoft Data Management Gateway (Version .1).Install Data Warehouse Migration Utility Preview (Version 1).Install DocumentDB Data Migration Tool (Version 1.7).Install DocumentDB Studio (Version 0.71).I use a Shared Access Signature to connect to my Azure storage Install Azure Storage Explorer (Version 0.8.5). ![]() Install Microsoft Database Experimentation Assistant Technical Preview (Version 1.0).Install Microsoft Data Migration Assistant (Version 2.0).Install Power BI Desktop (October update).Install Azure Data Lake Tools for Visual Studio (Version 2.2.21).Install Visio Professional 2016 (make sure to choose 64-bit version).Install Office Professional Plus 2016 (make sure to choose 64-bit version).Install SQL Server Data Tools (SSDT) 2015 GA for VS 2015 (1.0).Install Visual Studio Enterprise 2015 with Update 3 (4.00 Update 3).Get the latest SSMS version if needed: see Download SQL Server Management Studio (SSMS).Install the latest CU if needed: see SQL Server 2016 build numbers.I then create a SQL login with sysadmin server role I then login to SSMS and for the server properties change the server authentication to “SQL Server and Windows Authentication mode”.This will show you the boot screen of the VM so you can see if it is still performing windows updates On the Azure Portal, click on the VM and under “Support + Troubleshooting” you will see “Boot diagnostics”.I then connect to the VM and check for windows updates and install them After about 5 minutes your new VM will be ready.I chose the “East US” region, picked “Standard DS3” for the virtual machine size, created a resource group called “SQLServer”, used an existing storage account I called “serrastoragessd” which is premium-LRS and located in the East US region, enabled R Services, and created one data disk (under “Storage configuration” in SQL Server settings – create more disks for faster performance – please read Storage configuration for SQL Server VMs) I kept the default Azure “Resource Manager” (ARM) deployment model. Follow the prompts to enter the info needed to build the VM.This will install SQL Server 2016 CU2 (.0) Go to the Azure Portal, choose “New”, type in “SQL Server 2016”, and choose “SQL Server 2016 RTM Enterprise on Windows Server 2016”.This is a fully-loaded VM that I use for demo’s and to build small projects: Below I will document the steps I took to build the VM along with the additional software I installed. In a matter of minutes you can be playing and learning both platforms. With Windows Server 2016 just been released, now is the perfect time to build an Azure VM with SQL Server 2016 on Windows Server 2016.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |