SQL Server 2012 Virtual Machine in the Cloud - Connectivity
In a previous post, we created in Azure a virtual machine from the gallery with a trial version of SQL Server 2012 preinstalled on it. You can connect to the machine through a remote connection and perform administrative tasks, including administering SQL Server, because it initially has all the necessary components, including SSMS. On the practical side, the most common are not purely cloudy, but hybrid scenarios, when the data is partly stored in the Cloud, and partly in the on-premise database. For their joint processing, you will need to “pair” the freshly created SQL Server in Azure with on-premise SQL Server. For starters, it would be nice to see SQL Server on a cloud virtual machine from the local SSMS.