locked
DOCKER SQL CONTAINER RRS feed

  • Question

  • Hello All,

    How to access the DB from sql management studio by using the container’s IP Address along with the sql authentication credentials stored in the Docker file ?

    Thanks in Advance

    Friday, June 24, 2016 11:45 AM

Answers

  • Hi Ravi,

    Firstly, as indicated in this similar blog, connect the DB using SQL Server Management Studio(SSMS), you’ll need the hostname / IP address of the Windows Container Host VM (via “ipconfig”) and sa password.

    Secondly, have you checked Perry’s comments in this blog?  Use the container’s external IP Address if you are accessing the DB from SSMS installed on another machine. Note that a firewall rule might need to be created depending upon your setup. You can refer to this article for more information regarding Container Networking.

    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support


    Monday, June 27, 2016 5:49 AM