January 27, 2009 at 8:08 pm
Hi there,
I'm unable to connect to my local SQL server 2008, on my work station.
Error goes like this:
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 it to solve through SQL Server Configuration Manager. Still unable to sort it out.
I'm stuck now. Could any one please help me ASAP.
Many Thanks.
May 6, 2010 at 9:33 am
I got the same issue. Let me know if you solved this problem
May 7, 2010 at 12:01 pm
1st step (I'd do) is attempt setting up user or system DSN via the ODBC Data Souces wizard.
(Control Panel / Administrative Tools)
It should display an error message when you test the connection . . .
M
Free Expert Advice . . .
http://xkcd.com/627/
Mark
May 7, 2010 at 12:15 pm
Are you connecting with SSMS? Try changing the default connections options when you connect to use TCPIP
May 7, 2010 at 12:58 pm
Also . . .
Ensure your workstation's MDAC is updated to the latest version.
(Assuming you're using WinXP)
To check the version -
http://support.microsoft.com/kb/301202
To Download -
2.) For a local instance of SQL server - Named Pipes is the way to go . . .
http://technet.microsoft.com/en-us/library/ms187892.aspx
TCPIP is a good catch all . . . but the performance boost with named pipes makes it the better option.
Free Expert Advice . . .
http://xkcd.com/627/
Mark
May 29, 2012 at 7:22 am
Enable the Protocols "Named Pipes"
Rudy
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply