After virtual machine is created, there are various ways to access it.
A)You can click created virtual machine using portal and click connect for downloading rdp file.
B)You can connect to MSSQL in virtual machine with SQL Management Studio:
Make sure you installed MSSQL with known username and password
1)Using portal, add the endpoint to your virtual machine:
2)Add inbound rule via Control Panel>Windows Firewall>Inbound Rules:
Allow connection from port 1433
C)You can directly call published virtual applications or SSRS Web services:
1)Using portal, Add the endpoint to your virtual machine:
Public and Private Port:80