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,496 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,496 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 (Delegate) 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 276 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