connection string for sqlserver in Docker container
I'm using Visual Studio 2017 for mac with dotnet Core and EF Core. After setting up the mssql image in Docker container , I was trying to add the connection string but throwing connection error. I tried with different options such as ip address , container name , host name etc. as server name but none of them worked.
"Default": "Server=172.17.0.2; Database=ERPDb; User=sa; Password =******;"
with container name
"Default": "Server=ecstatic_hermann; Database=ERPDb; User=sa; Password=******;"
with hostname :
"Default": "Server=f45840a59623; Database=ERPDb; User=sa; Password=******;"
While connecting through using localhost in Terminal its successfully connecting
$ mssql -s localhost -p Technocrat123
Connecting to localhost...done
sql-cli version 0.6.2
Enter ".help" for usage hints.
But when running the application the connection fails.
Appreciate any help. Thanks in advance.
If using localhost then error is
Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Integrated authentication only.
I just wrote up a blog post on this. Take a look at richminchuk.io. Otherwise:
sudo docker pull microsoft/mssql-server-linux:2017-latest
docker run
-d microsoft/mssql-server-linux:2017-latest
-e 'ACCEPT_EULA=Y'
-e 'MSSQL_SA_PASSWORD=YourSTRONG!Passw0rd'
-p 1401:1433
--name sql1
then,
private static string _connStr = @"
Server=127.0.0.1,1401;
Database=Master;
User Id=SA;
Password=YourSTRONG!Passw0rd
";
Most likely your server name is localhost and port 1401 (which is the default for Docker container setup). Therefore, you'll need to use the following connection string:
"Default": "Server=localhost,1401; Database=ERPDb; User=sa; Password =******;"
上一篇: sizeof（某个指针）总是等于四？