How to connect ASP.Net Core to a SQL Server Docker container on Mac

Question

I am developing an ASP.Net core MVC application using Visual Studio 2017 on Mac. However, I am facing some problems to connect to an instance of SQL Server that is running on a Docker container.

This is the connection string I'm using:

"ConnectionStrings": {
    "myCustomConnString": "Server=localhost;Database=myDataBase;User Id=sa;Password=myPassw0rd;Trusted_Connection=True;MultipleActiveResultSets=true"
  }

And this is the error I am getting:

Cannot authenticate using Kerberos. Ensure Kerberos has been initialized on the client with 'kinit' and a Service Principal Name has been registered for the SQL Server to allow Kerberos authentication. ErrorCode=InternalError, Exception=Interop+NetSecurityNative+GssApiException: GSSAPI operation failed with error - An unsupported mechanism was requested (unknown mech-code 0 for mech unknown).

Using SQL Operation Studio, Azure Data Studio and/ or Visual Studio Code and passing the same parameters I can connect to the docker instance of SQL Server. But not when running the ASP.Net core app. So, I'm not sure if I am missing any additional parameter for the connection string.

Does anyone have try this before?

Regards!

Found how to connect to the Docker instance of SQL Server. I had to set up the Trusted_Connection=false. After that I was able to connect when running my ASP.Net core app. — MikePR
– MikePR, Commented Oct 29, 2018 at 17:10
Thanks! I wasted so much time on this one and that fixed it! — Dontreadonme
– Dontreadonme, Commented Jan 4, 2019 at 6:58

Randy Eppinger · Accepted Answer · 2019-04-16 20:16:40Z

41

I know that @MikePR 's comment serves as the answer, but I wanted to provide a more complete answer for the issue I had. I could not get dotnet ef database commands to execute evan after using the connection string with Trusted_Connection=false. With the help of this article, I was able to use this connection string:

"ConnectionStrings": {
    "myCustomConnString": "Server=localhost,1433\\Catalog=myDatabase;Database=myDatabase;User=username;Password=MYSecurePWD;"
  }

Now, my migrations run against the SQL Server in the docker container. Note that the article did not include using Trusted_Connection=false. I assume that false is the default.

answered Apr 16, 2019 at 20:16

Randy Eppinger

1,12414 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hicham Mounadi · Accepted Answer · 2020-09-22 15:56:30Z

16

I got the same issue, and it works simply by deleting Trusted_Connection=True; from the connection string

answered Sep 22, 2020 at 15:56

Hicham Mounadi

4696 silver badges8 bronze badges

Comments

Salvation Lloyd Stanley-Kemuel · Accepted Answer · 2021-05-25 12:55:42Z

6

Solved mine by setting Trusted_Connection=False

answered May 25, 2021 at 12:55

Salvation Lloyd Stanley-Kemuel

1331 silver badge4 bronze badges

Comments

jonanv · Accepted Answer · 2021-03-07 04:03:40Z

4

I ran the connection string as follows and it worked

"ConnectionStrings": {
    "DevConnection": "Server=localhost,1433;Database=TarjetaCreditoDB;User Id=sa;Password=myPassw0rd;MultipleActiveResultSets=True;"
  }

answered Mar 7, 2021 at 4:03

jonanv

492 bronze badges

Comments

Obainodtq · Accepted Answer · 2021-06-23 10:42:49Z

4

I was able to solve mine by removing Trusted_Connection

answered Jun 23, 2021 at 10:42

Obainodtq

511 silver badge3 bronze badges

Comments

HiroCereal · Accepted Answer · 2023-06-23 13:54:57Z

2

I ran the connection string as follows and it worked

"ConnectionStrings": {
    "DefaultConnection": "Server=localhost,1433; Database=ERPDb; User=sa; Password =*****; Trusted_Connection=false; TrustServerCertificate=true;"
  },

edited Jun 23, 2023 at 13:54

HiroCereal

6443 silver badges13 bronze badges

answered Jun 18, 2023 at 8:16

mayank parihar

211 bronze badge

Comments

Tamilvanan G · Accepted Answer · 2023-01-31 04:48:49Z

1

Below string worked for me.

 Server=sql-server-db,1433;Database=EMP_DB_V2;User=SA;Password=Test_pwd@786;Trusted_Connection=False;MultipleActiveResultSets=True;

answered Jan 31, 2023 at 4:48

Tamilvanan G

112 bronze badges

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Marc Thieme · Accepted Answer · 2024-01-31 12:35:02Z

0

I solved mine by removing Integrated Security=true;.

answered Jan 31, 2024 at 12:35

Marc Thieme

1481 silver badge9 bronze badges

Collectives™ on Stack Overflow

How to connect ASP.Net Core to a SQL Server Docker container on Mac

8 Answers 8

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related