In this post, let us see step by step instructions on how to create SQL Server Virtual machine and connect to SQL Server.
Login into azure portal and goto VIRTUAL MACHINES
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3Cm6e0e3CXatdN3gWdYdmL8GbwmMW9n21oWhSVMryTVba2LwkkKIrPAZ6A_-Y9yKwpRDREbBhINd2CnrSxJwpceDK_YMORMNNDUNHgYcgOz3KaG4_fkv2B1U5SPl1PJbxgFOD-3kw5Vui/s640/A0.JPG)
Now select FROM GALLERY
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMjzSD35pcpe2V1go2iDDnN2gK6ykIonSiIyXTX7ndi4GieOasvcNgTFSh2PFnz_vA-DQotc-ZpGniMlWtt1G9k2zncDB9zqfd8jXhsKeJE8pEiXvypqS9-mL6Lj2bOvnVLPjFNk6qlOju/s640/A2.JPG)
I went with latest version available SQL Server 2016 CTP 3.2 Evaluation.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgG84R7CCy3GNzWewez5pcyx819TUEgfnOfodHpjlVgHx9wmBdaVGk3JlkOKg6F7uLaY-TX6ZeFd5OYOJAEjh_mgKHCEpi2H_cFbE5-swYXqw_vc0ehnzmcUBxJ0gCk-JQIaPzmWSOhFBob/s640/Az2.JPG)
Provide VIRTUAL MACHINE NAME, NEW USER NAME & PASSWORD:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEighTz6Q5EpYd4udy3-H7Pwq9VKvKGoT1igdqchrrt2X8KuvWBdZMh8HWLK_DIYBqUblRVflYIONHAHcRyKtVO4x4mLGa6Lu3Yg8dxLX82Jdo747g4ZEwlCT2mygIJDJUH4qvhxmCXnlUNo/s640/Az3.JPG)
Provide CLOUD SERVICE DNS NAME & STORAGE ACCOUNT
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdGRLKX2VFOyEaklh0MOdqQwsCUBCQGwRXWlTPN1YSyIWrR0ChBZ3SovjscFUEPJ3fY7Px1qG1m_0Gbxld2OqmgbhQxdAB2Y2C6QzlUwSsvKRfaypHmHLUxDJc96TKXqenN1t4oTEAfx6q/s640/Az4.JPG)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYKfA9fR24tMzBgHLdVQxu-xRCA28K5L9xdo2RJ7F6V38OuFfmD8eEHubx9rr013AK2o4cqcbomM28LeDitGgCQ6UHC2ZO_LcBsI6Ea2PbQFklacxW0k9iILrY9zq0IPutfu6QcI1nXR7v/s640/Az5.JPG)
Note: You will have to wait few minutes for your VM to be created.
Goto VIRTUAL MACHINES in the bottom you will notice Connect option -> click on that
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWYjwrQuq8ubbGJM8USSwBUvUJpawI51cUnFtr40F84zzIjgxOrxOpz5pv1vE93O7PE_r8jUPXbYPOMttG_xrQMjZ9BPYT-Kz18QTsFGCbksYbfRXzlGp9Lq6e5i_D_nrrX-NxOLx9PJpA/s640/Az6.2.JPG)
Provide VM name &User name & Password that was mentioned while configuring VM.
Once connected goto Search -> type SSMS and Connect to SQL Server as shown below:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHN7iBbeNyLHEx_vNBz2rFUTmugRbEwLEtarTh6dN0hKiKD7RttYAuLpQH3Nuu2L8fJ_l8H6XodQrriRLlAlrJK0xj6ST1D35V48Y_BJtB4cpzGc7gfqck4nF3tjSfggJzvcrMluGNoAJQ/s640/Az7.1.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifzr8X_aSOiaEINMeAzANfTHqtI69b3-9oLzYJiYevOgYkyq7zN6Vl27yS0SFnNr43O9lmKSao_EfCgj40XYy1u8c3vbyqwwmT89mO5Uw8be1Hxmbzegbkd7a42-T9THtSyVj6jh0pJsg4/s640/Az8.png)
Steps to create SQL Server VM:
Login into azure portal and goto VIRTUAL MACHINES
Now select FROM GALLERY
I went with latest version available SQL Server 2016 CTP 3.2 Evaluation.
Provide VIRTUAL MACHINE NAME, NEW USER NAME & PASSWORD:
Provide CLOUD SERVICE DNS NAME & STORAGE ACCOUNT
Note: You will have to wait few minutes for your VM to be created.
Steps to connect VM & SQL Server:
Goto VIRTUAL MACHINES in the bottom you will notice Connect option -> click on that
You will be prompted to open .rdp file, click Open and Connect as shown in below images:
Provide VM name &User name & Password that was mentioned while configuring VM.
Once connected goto Search -> type SSMS and Connect to SQL Server as shown below:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHN7iBbeNyLHEx_vNBz2rFUTmugRbEwLEtarTh6dN0hKiKD7RttYAuLpQH3Nuu2L8fJ_l8H6XodQrriRLlAlrJK0xj6ST1D35V48Y_BJtB4cpzGc7gfqck4nF3tjSfggJzvcrMluGNoAJQ/s640/Az7.1.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifzr8X_aSOiaEINMeAzANfTHqtI69b3-9oLzYJiYevOgYkyq7zN6Vl27yS0SFnNr43O9lmKSao_EfCgj40XYy1u8c3vbyqwwmT89mO5Uw8be1Hxmbzegbkd7a42-T9THtSyVj6jh0pJsg4/s640/Az8.png)
No comments:
Post a Comment