CODEWITHSUNDEEP
sql-servermacosdockervisual-studio-code
Mateusz Dygas
Mateusz Dygas

Reputation: 31

Cannot connect to MSSQL with Docker via VSC (MacOS)

I am trying to connect to MSSQL via Visual Studio Code with installed mssql extension. I did pull and run SQL Server 2017 container image with Docker and I am trying to make a connection, although I do get an error:

mssql: Failed to connect: System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 25 - Connection string is not valid) ---> System.Net.Sockets.SocketException (0x80004005): Undefined error: 0 at System.Data.SqlClient.SN

The container image is running - I did log on to MSSQL through terminal, but I can't with Visual Studio Code. Do I have to provide an instance as well? Where I can find it - cannot find it on docker inspect statement.

Did you guys have similar problem and maybe found a solution?

Upvotes: 0

Views: 2034

Answers (1)

Mateusz Dygas
Mateusz Dygas

Reputation: 31

Okay I managed to solve the problem. I do connect to sql server container on 1401 port (localhost,1401 on VSC), but apparently when you start a container you need to change the password for sa. Rookie mistake :) Thanks for trying to help

Upvotes: 1

Related Questions