locked
Unable to connect from remote computer RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I have configured the VM according to the steps outlined including all the ports, protocols as outlined in the help posted in the forum however I am still unable to connect to the sql instance running on my VM through SQL Management Studio from a remote computer.
    Monday, July 16, 2012 1:26 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Kphelan,

    Regarding to your description, seems related to SSMS remote connection issue. Please verify some of the common things to check when you are not able to connect to SQL on VM through SSMS:
    1) The server name correct
    2) The username + password correct
    3) SQL Azure Firewall settings, please double check your SQL Azure firewall setup as well as see if there's another firewall between you and the server.
    4) Also try telnet .database,windows.net 1433. If you are unable to establish a connection with this then I would suggest you check your firewall settings.

    Based on my research, before you connect to the default instance of SQL Server with SQL Server Management Studio (running on the virtual machine) on another computer, you must complete the following tasks as described in the sections that follow:
    • Create a TCP endpoint for the virtual machine
    • Open TCP ports in the Windows firewall
    • Configure SQL Server to listen on the TCP protocol
    • Configure SQL Server for mixed mode authentication
    • Create SQL Server authentication logins
    • Determine the DNS name of the virtual machine
    • Connect to the Database Engine from another computer

    For more information, please follow the Complete Configuration steps to connect to the virtual machine Using SQL Server Management Studio on another computer section from this Blog.

     

    Regards, Amber zhang

    • Proposed as answer by JamesYi Wednesday, July 18, 2012 2:23 AM
    • Marked as answer by JamesYi Friday, July 20, 2012 1:46 AM
    Tuesday, July 17, 2012 9:34 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi kphelan,

    Did you create the VM from one of the stock images?  If so which one?  Are you able to RDP to the VM by using the Connect >< option on the bottom of the preview page?  What does the status of the VM showing in the dashboard?

    John

    Monday, July 16, 2012 5:58 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Kphelan,

    Regarding to your description, seems related to SSMS remote connection issue. Please verify some of the common things to check when you are not able to connect to SQL on VM through SSMS:
    1) The server name correct
    2) The username + password correct
    3) SQL Azure Firewall settings, please double check your SQL Azure firewall setup as well as see if there's another firewall between you and the server.
    4) Also try telnet .database,windows.net 1433. If you are unable to establish a connection with this then I would suggest you check your firewall settings.

    Based on my research, before you connect to the default instance of SQL Server with SQL Server Management Studio (running on the virtual machine) on another computer, you must complete the following tasks as described in the sections that follow:
    • Create a TCP endpoint for the virtual machine
    • Open TCP ports in the Windows firewall
    • Configure SQL Server to listen on the TCP protocol
    • Configure SQL Server for mixed mode authentication
    • Create SQL Server authentication logins
    • Determine the DNS name of the virtual machine
    • Connect to the Database Engine from another computer

    For more information, please follow the Complete Configuration steps to connect to the virtual machine Using SQL Server Management Studio on another computer section from this Blog.

     

    Regards, Amber zhang

    • Proposed as answer by JamesYi Wednesday, July 18, 2012 2:23 AM
    • Marked as answer by JamesYi Friday, July 20, 2012 1:46 AM
    Tuesday, July 17, 2012 9:34 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Please take a look at the following tutorials:

    Connect to SQL Server in the same cloud service

    Connect to SQL Server in a different cloud service

    Connect ASP.NET application to SQL Server in Windows Azure via Virtual Network

    Selcin Turkarslan

    Monday, November 19, 2012 6:55 PM