connect sql server from Microsoft Sql Server Management Studio

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