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...

Question

1.80/5 (2 votes)

See more:

Hi all!!!

I created a database owner in sql-server 2008. I set authentication type to sql server authentication , added username and password to it then set the user mapping for this user to be database owner.

Now when i am trying to run management studio using sql sever authentication , it's showing me this error

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.) (.Net SqlClient Data Provider)

I tried to find solution on google but can't find any specific solution.

Posted 28-Mar-12 22:16pm

ujjwal uniyal

Updated 15-Feb-21 7:19am

Add a Solution

10 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 14806265 · Answer 1 · 2020-04-18T15:26:00

Solution 13

I have same issue regarding creating a new user in DB. This issue is caused when your TCP/IP is Enabled but the named Pipes is Disabled in SQL server configuration. TO solve

SQL Server Configuration Manager > SQL server Network Configuration > Protocols for MSSQLSERVER(choose the server you want to create the user).
On left Pane TCP/IP > Enabled & Named Pipes > Enabled.

Above process solved my issue of login with different User that I have created for database.

Posted 18-Apr-20 15:26pm

Member 14806265

Comments

CHill60 20-Apr-20 5:46am

Solution 1 from 8 years ago stated it was because named pipes were disabled. You have added nothing new to the thread

Member 14806265 21-Apr-20 22:03pm

Well solution 1 provides a link to solution where people after googling 10 times comes to this page and they might not want another link page but rather a solution in this page. That's only the reason i thought would might be helpful. thank you

Member 8979660 · Answer 2 · 2017-05-30T07:48:00

Solution 8

Issue resolved after I have started the SQL Browser service which was disable and stooped before.

Posted 30-May-17 7:48am

Member 8979660

Comments

CHill60 1-Jun-17 18:39pm

Why have you resurrected a 5 year old question from someone else to inform us that you have solved your own problem?

Saral S Stalin · Answer 3 · 2012-03-30T21:17:00

Solution 1

This error happens becasue the named pipe support is not enabled for your SQL server.To enable named pipes or for workarounds see the link http://msdn.microsoft.com/en-us/library/ms175496(v=sql.110).aspx[^]

Posted 30-Mar-12 21:17pm

Saral S Stalin

nim274 · Answer 4 · 2014-07-18T09:38:00

Hi,

I faced similar issue today, In my case I had a default database associated with user. It was other than master. I deleted the database and when next time I tried to login via Management studio it started giving error.

I went to options tab of connection dialog and specified default = master.

It worked for me.

Thanks,
Nimesh

TZESENG · Answer 5 · 2013-07-25T08:33:00

Solution 3

For my case, resolve using [Surface Area Configuration] set the [Local and remote connections] to [Using TCP/IP only].

Posted 25-Jul-13 8:33am

TZESENG

Comments

CHill60 27-Jul-13 8:50am

Which is what solution 1 said to do a year ago

Eliasvalentine · Answer 6 · 2013-07-27T01:16:00

Solution 4

this can be useful in troubleshooting sql 2012, basically the connection is there but fails on login. therefore to resolve this issue, change the authentication to sql authentication, login with your sa account and add your acoount or domain account you want to have access and voila it works!. hope this helps

Posted 27-Jul-13 1:16am

Eliasvalentine

Comments

CHill60 27-Jul-13 8:51am

Did you realise that this question is over a year old?

rtrm110 · Answer 7 · 2015-11-11T00:35:00

Hi All,

I faced the same issue once and what I did was

1. I stopped all other services (Analysis, integration and reporting services) and restarted the MSSQLSERVER service.
2. Then I was able to connect to database engine using SSMS.
3. Properties > Connection > Changed the value into 0 (Unlimited).

Of course this was not a production environment.

Jafar_Ulla · Answer 8 · 2018-06-01T18:56:00

Solution 9

I face this issue and this link work for me

Change Server Authentication Mode | Microsoft Docs[^]

Posted 1-Jun-18 18:56pm

Jafar_Ulla

Member 14008086 · Answer 9 · 2018-10-04T10:37:00

Solution 10

The SQL Server login I was using was setup to require the password to be changed at the next login. Once I reset the password my issue was resolved.

Posted 4-Oct-18 10:37am

Member 14008086

Comments

Member 14992308 5-Feb-21 8:41am

Same here! I had that problem and I logged into management studio (with the user I was trying to use in c#) that asked to change password. Then, everything just worked fine!

Member 14530665 · Answer 10 · 2019-10-16T19:58:00

Hi, I am using it in EF Core.
In My Case I forget to add ";" in front of Database name in Package Consoe Manager.

First Command: Scaffold-DbContext "Server= DESKTOP-DDP\SQLEXPRESS; Database=DairyDispatch Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

Correct Command: Scaffold-DbContext "Server= DESKTOP-DDP\SQLEXPRESS; Database=DairyDispatch; Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

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...

10 solutions

Solution 13

Solution 8

Solution 1

Solution 5

Solution 3

Solution 4

Solution 7

Solution 9

Solution 10

Solution 12

Add your solution here

Preview 0