System.ComponentModel.Win32Exception (233): No process is on the other end of the pipe

Question

User281366353 posted

I am trying to work out the syntax and potential bugs running EFCore using database first approach.  Using command line interface. my goal is to connect to an SQL Express database.  when I execute the statement: 

dotnet ef dbcontext scaffold 'Server= Russ\SQLExpress01; Database=ARC_WIMS02; User Id = fishe_000; ' Microsoft.EntityFrameworkCore.SQLServer -o MyModels

I get the error:

Microsoft.Data.SqlClient.SqlException (0x80131904): 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.)  

Any thoughts would be welcome.

Answer 1

User-821857111 posted

Your connection string contains a user name, but no password. If you are connecting as a SQL Server user, you need a password. Alternatively, connect using Windows authentication:

dotnet ef dbcontext scaffold 'Server= Russ\SQLExpress01; Database=ARC_WIMS02; Trusted_connection=true; '

Answer 2

User281366353 posted

Thank you for your reply. 

Answer 3

User281366353 posted

I tried the string: 

dotnet ef dbcontext scaffold 'Server= Russ\SQLExpress01; Database=ARC_WIMS02; Trusted_connection=true'

and receive the error:

Unrecognized command or argument 'Database=ARC_WIMS02;'

which seems like a step back.  My previous incorrect string acknowledged the connection but threw the 'No process is on the other end of the pipe' error.

What am I missing?

Answer 4

User1535942433 posted

Hi Geol4549,

Geol4549

Unrecognized command or argument 'Database=ARC_WIMS02;'

Such as:

"Server=.\SQLExpress;Database=SchoolDB;Trusted_Connection=True;"

Server refers to local SQLEXPRESS database server.Database is same with your database name. I suggest you could check if  the server and database name are right.

Best regards,

Yijing Sun