Create a new Azure TCP/IP endpoint
Start by accessing the Azure portal and navigating to your new VM.
Drill into your VM, navigate to the ENDPOINTS tab, and click ADD to create a new endpoint.
A wizard will appear. Select ADD A STAND-ALONE ENDPOINT and click the right-arrow.
Use the drop-down box to select MSSQL and edit the ports, if you choose.
Click the check mark to complete and then wait for the Azure portal to tell you that the endpoint has been created.
Remote desktop into your VM
Once our endpoint is created we will need to do some work with Windows and SQL Server. Navigate to your Azure VM Dashboard and download your customized .rdp file with the CONNECT button.
Connect to your VM via the downloaded .rdp file.
Verify TCP/IP is enabled for SQL Server
Open up SQL Server Configuration Manager and enable the TCP/IP protocol, if it is not already. In the VM image that I provisioned for SQL Server 2016 CTP 3.0 the TCP/IP protocol was enabled but it is always good to verify.
Configure SQL Server for Mixed Mode authentication
Open SQL Server Management Studio, right-click on your instance in the object explorer and select Properties. On the Security page, select the SQL Server and Windows Authentication mode radio button and hit OK. Finish up by restarting your SQL Server instance for the setting to take effect.
Open your SQL Server connection port
Finally we have to open up the SQL Server connection port in the Windows Firewall with Advanced Security by creating a new inbound rule.
When the wizard opens, select the rule type Port and click Next.
Specify your port and click Next.
Allow the connection and then click Next.
Another Next…
…followed by a name for your rule and click Finish.
