Email: Password:       Forgot Password 
    .netCodeSG
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
 
TECHNOLOGIES:
Access SQL Server on Azure VM via SQL Server Management Studio From Local?
  Comment
 
 
Following Below steps:

  • Add a TCP endpoint for that VM on port 1433 - public & private (you can change the public port if you will).
  • Configure the SQL Server Instance to listen to TCP.
  • Enable the incoming TCP port 1433 in the local Firewall rules of the VM.
  • Enable mixed mode authentication on the SQL Server
  • Make sure your ISP does not block outgoing port 1433 (a common practice for most of ISVs since 2003' SQL Slammer) - this is over overridable with custom Public port for your TCP endpoint.
  • Than you will be able to connect to the SQL Server in the Azure VM using your local SSMS.
On  18/09/2020 09:04:14
MOST VIEWED QUESTION:
 
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us