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.)
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; '
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.
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
.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.
Member
2 Points
16 Posts
System.ComponentModel.Win32Exception (233): No process is on the other end of the pipe
May 28, 2020 01:29 AM|Geol4549|LINK
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.
All-Star
194490 Points
28079 Posts
Moderator
Re: System.ComponentModel.Win32Exception (233): No process is on the other end of the pipe
May 28, 2020 10:01 AM|Mikesdotnetting|LINK
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; 'Member
2 Points
16 Posts
Re: System.ComponentModel.Win32Exception (233): No process is on the other end of the pipe
May 28, 2020 02:03 PM|Geol4549|LINK
Thank you for your reply.
Member
2 Points
16 Posts
Re: System.ComponentModel.Win32Exception (233): No process is on the other end of the pipe
May 28, 2020 02:51 PM|Geol4549|LINK
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?
Contributor
3730 Points
1425 Posts
Re: System.ComponentModel.Win32Exception (233): No process is on the other end of the pipe
May 29, 2020 02:55 AM|yij sun|LINK
Hi Geol4549,
Such as:
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