![\"\"](\"http:\/\/www.sqlhammer.com\/blog\/wp-content\/uploads\/2015\/11\/azure-tcp-endpoint-1.png\")
<\/a><\/p>\nDrill into your VM, navigate to the ENDPOINTS tab, and click ADD to create a new endpoint.<\/p>\n
A wizard will appear. Select ADD A STAND-ALONE ENDPOINT and click the right-arrow.<\/p>\n Use the drop-down box to select MSSQL and edit the ports, if you choose.<\/p>\n Click the check mark to complete and then wait for the Azure portal to tell you that the endpoint has been created.<\/p>\n 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.<\/p>\n Connect to your VM via the downloaded .rdp file.<\/p>\n Open up SQL Server Configuration Manager and enable the TCP\/IP protocol, if it is not already.\u00a0In 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.<\/p>\n Open SQL Server Management Studio, right-click on your instance in the object explorer and select Properties. On\u00a0the Security page, select\u00a0the 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.<\/p>\n Finally we have to open up the SQL Server connection port in the Windows Firewall with Advanced Security by creating a new inbound rule.<\/p>\n When the wizard opens, select the rule type Port and click Next.<\/p>\n Specify your port and click Next.<\/p>\n Allow the connection and then click Next.<\/p>\n Another Next\u2026<\/p>\n \u2026followed by a name for your rule and click Finish.<\/p>\n Now it is time to test. Disconnect from your remote desktop session and launch SSMS on your work station. Connect using your Azure DNS name\u2026<\/p>\n \u2026SUCCESS!<\/strong><\/p>\n Derik is a data professional focusing on Microsoft SQL Server. His passion focuses around high-availability<\/a>, disaster recovery<\/a>, continuous integration, and automated maintenance. his experience has spanned long-term database administration, consulting, and\u00a0entrepreneurial ventures.<\/p>\n Derik gives the SQL community credit for plugging the gaps in his knowledge when he was a junior DBA and, now that his skills have matured, started SQLHammer.com<\/a> as one small way to give back and continue the cycle of shared learning.<\/p>\n Derik is the owner and lead author of SQL Hammer, a Microsoft SQL Server resource<\/a>.<\/p>\n For more information, visit http:\/\/www.sqlhammer.com<\/a>. Follow Derik on Twitter<\/a> for SQL tips and chat<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" After you provision a Microsoft Azure VM with SQL Server there are a few more steps that you need to take to make remote connections. The procedure below starts with a fresh Azure VM provisioned and walks through the process of establishing a connection via SQL Server Management Studio, installed on an on-premises work station. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-136","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/comments?post=136"}],"version-history":[{"count":1,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/136\/revisions"}],"predecessor-version":[{"id":398,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/136\/revisions\/398"}],"wp:attachment":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/media?parent=136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/categories?post=136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/tags?post=136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<\/a><\/p>\n<\/a><\/p>\n<\/p>\n<\/a><\/p>\nRemote desktop into your VM<\/h2>\n
<\/a><\/p>\n<\/a><\/p>\nVerify TCP\/IP is enabled for SQL Server<\/h2>\n
<\/a><\/p>\nConfigure SQL Server for Mixed Mode authentication<\/h2>\n
<\/a><\/p>\nOpen your SQL Server connection port<\/h2>\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\nConnect<\/h2>\n
<\/a><\/p>\n<\/a><\/p>\n
\nWritten by Derik Hammer of SQL Hammer<\/a><\/strong><\/p>\n