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
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
Member
2 Points
9 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
191614 Points
27777 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
9 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
9 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?
Participant
1460 Points
646 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
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.