I get a no process is on the other end of the pipe. Login failed?

iqworks Information Quality Works 276 Reputation points
2022-04-07T18:12:34.2+00:00

04/06/2022 – I am using visual studio and package manager console, visual studio 2019, Core 5.0 MVC With Angular.
I also have aso have sql 2008r2, 2014,2017, but i use sql server 2012,.

This is what I run and the error message:
PM> Scaffold-DbContext 'Data Source=.\MSSQLSERVER2012;Initial Catalog= MbsAnalysisData Trusted_Connection=TRUE User Id = ; Password= ' Microsoft.EntityFrameworkCore.SqlServer
Build started...
Build succeeded.
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.)
---> System.ComponentModel.Win32Exception (233): No process is on the other end of the pipe.

I read several links that suggested all of these requirements:
1 - in sql server configuration:
Shared Memory – enabled.
Named Pipes – enabled. .\pipe\MSSQL$MSSQLSERVER2012\sql\query
TCP/IP – enabled.

It was suggested I move TCP/IP above Named Pipes, how do you do that? Do you even NEED to do that?

2 – SQL Server Agent 2012 is not running, does it need to be running? If so, when I try to start the service, it starts and stops and then says something like “some services stop automatically if they are not in use by other services or programs”.

3 – I have my server properties in sql server management studio with the server authentication set to “SQL Server and windows authentication mode”

4 – do I need to go into the registry for anything?
Thanks for any help or suggestions

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,046 questions
{count} votes