Learning EF - Error running Scaffold-DbContext

Stephen Ng Qui Sang 10

I am learning how to user Entity Framework where the models are built from an existing SQL server. I ran this command in the package manager:

Scaffold-DbContext “Server=xxx; database=Contoso; user id = cnnxxxxx; password = xxxx” Microsoft.EntityFrameworkCore.SqlServer –ContextDir Data -OutputDir Models

I got the following error:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

I know the database connection string works as I built a quick connection and sent the output of a table to the console.

I appreciate any ideas to fix this issue. Thanks.

Jack J Jun 24,516 Reputation points Microsoft Vendor

2023-02-08T05:39:54.6666667+00:00

@Stephen Ng Qui Sang, Welcome to Microsoft Q&A, based on my test, I could generate the models correctly without any problems. And according to my search, I find that you could try to add Encrypt=False in your connection string to solve the problem.
Jack J Jun 24,516 Reputation points Microsoft Vendor

2023-02-14T08:07:29.52+00:00

@Stephen Ng Qui Sang, have you tried my advice to check if it works for you?
JYOTHISH MB 5 Reputation points

2023-07-02T07:29:22.7266667+00:00

Encrypt=False resolved my issue also. Thanks
Yash Jha 0 Reputation points

2024-04-13T20:35:59.66+00:00

where to write Encrypt=False, in the end of the command or somewhere else; please provide the full command

my database name is web.

1 answer

Christoffer Broberg 15 Reputation points

2023-02-15T11:23:13.4333333+00:00

Hi,

I had the same issue today, and setting the Encrypt=False in the connectionstring solved the problem
Thanks a lot!
Please sign in to rate this answer.

3 people found this answer helpful.
iqworks Information Quality Works 296 Reputation points

2023-04-08T17:10:58.65+00:00

Hi, I created a core class library 6.0. I installed the these packages. I am using SQL 2012.

I run this command :
PM> Scaffold-DbContext “Data Source=.\MSSQLSERVER2012;Initial Catalog= MbsAnalysisData;User Id = xxxx Password= xxxx” Microsoft.EntityFrameworkCore.SqlServer -output iqModels

This is the error I get :
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

I run this command with Encrypt=False:

PM> Scaffold-DbContext “Data Source=.\MSSQLSERVER2012;Initial Catalog= MbsAnalysisData;User Id = xxxx; Password= xxxx; Encrypt=False” Microsoft.EntityFrameworkCore.SqlServer -output iqModels

This is the error :

Error Number:233,State:0,Class:20 A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

Not sure what I am doing wrong? I did this same process on a core 3.1 project and the scaffold built fine.

Thanks for any help or advice.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer