• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

Why am I getting an error message, "No process on the other end of the pipe?"

Can not log into the SQL (Server 2008 R2) instance anymore using SQL authentication. When I attempt to login using SQL authentication with a user that has login permissions, I get the attached error message.  I enabled "named pipes," the suggested solution and did not fix the issue.

Any other ideas? Thanks
Picture-3.png
0
PDSWSS
Asked:
PDSWSS
1 Solution
 
baretreeCommented:
there can be several things affecting.. you can try the following

1. Login as Administartor
2. Right click on the Instance name - Server Properties
3. Security page
4. Set the Server Authentication - 'SQL Server and Windows Authentication mode'
5. Restart the SQL Service

other

1. Login as an Administrator into the SqL Server
2. Expand Security/ Logins folder
3. Right Click on the particular user and go to properties
4. Click Status Permission: Granted Login : Enabled

also

1. Log into an administrative account that has access to both the machine and sql server 2008 database
2. Open up SQL Server Management studio with "Windows Authentication"
3. Click on the security folder
4. Click on "logins"
5. Then click on the account that is not working
6. Answer - Make sure there is a database within the "Database Default"  specified "for example, the admin account to master
0
 
PDSWSSAuthor Commented:
The first 2 solutions did not work.  Not clear what you mean by #6 in the 3rd option.
Under Default database:  =  master

Should another database be chosen in the dropdown instead of master?  Thanks
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
would this article help to troubleshoot your problem?
http://www.experts-exchange.com/A_1881.html
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
PDSWSSAuthor Commented:
Looks like a lot of good information. I tried some of the suggestions but nothing seems to make it possible to login to the SQL Instance using SQL authentication.

Windows authentication works fine. We are running a clinical website which requires SQL authenticated login.
0
 
TempDBACommented:
Is tcp\ip enabled or not? If not, please do it.
And then check the server is ready to do remote access. Most probably it should be as with windows authentication you are already able to connect, but just wanted to re-assure.
sp_configure 'remote access',1
0
 
PDSWSSAuthor Commented:
Thanks for all your input. Fixed issue by replacing the web config file.
0
 
PDSWSSAuthor Commented:
This turned out to be a server specific issue as I fixed it by replacing the web config file.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now