connect sql server from Microsoft Sql Server Management Studio

Posted on | Edited on | In

description: codes for connecting sql server from Microsoft sql server management studio

start sql server

Asdfgh123 is default password

1
2
3
docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Asdfgh123" `
   -p 1433:1433 --name sql1 `
   -d microsoft/mssql-server-linux:2017-latest

connect from external tools

under Windows, open Powershell to test service can be accessed from Windows

1
sqlcmd -S 10.3.2.4,1433 -U SA -P "Asdfgh123"

connect from sql server management studio

server name is the ip address for docker computer. can use commend ipconfig to get the IPv4 Address

1
2
3
4
5
server type: database engine 
server name: 192.168.11.11 
authentication: sql server authentication 
    login: SA
    password: Asdfgh123

more on search4fan.github.io