Connection Established Successfully..Error during the log process
saw
When trying to connect to the SQL SERVER 2005 through Microsoft SQL Server
Management Studio Express, I get the following error:
Cannot connect to (SERVER NAME) which both are on the same machine, I am
using one machine for everything since it is a lab machine.
Additional Information:
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.) (Microsoft SQL
Server, Error: 223)
This error prevents my application on the same server machine from
connecting to the sql server on the same machine.
Please let me know what I can do to correct the issue.
Your help is greatly appreciated.
Rick Byham, (MSFT)
I have documented some of the reasons in Books Online:
http://msdn2.microsoft.com/en-us/library/ms175496.aspx
but these shouldn't occur when you make a local connection.
More reasons would be nice to add to this topic.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"saw" <swexpress(remove)@hotmail.com> wrote in message
news:eo7WuKQa...@TK2MSFTNGP06.phx.gbl...
Bohse@discussions.microsoft.com Markus Bohse
Here's my situation. I have SQL 2005 SP2 (3042) DEV Edition and try to
connect through application on the same machine. When using a sql login I get
the error "provider: Shared Memory Provider, error: 0 - No process is on
the other end of the pipe.". In the SQL Errorlog i see failed login messages.
So I tried Integrated Security and I can connect.
You might think that the server is configured to accept only Windows logins,
but in SSMS I can open a connection using the sql account. I already enabled
TCP and Named Pipes but no succes. I also tried other sql accounts but the
same result.
When I change the connection string to a different server the sql login
works fine.
For the moment I use Integrated Security as a workaround, but I sincerely
pray I never have this issue on a production server.
Markus
Markus Bohse
When I use a sql login with a name of 8 characters I get the error.
If I use a shorter login name it works fine. The same with a longer
loginname.
Only 8 character like "TestUser" causes the problem.
Markus
Rick Byham, (MSFT)
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.
"Markus Bohse" <Marku...@discussions.microsoft.com> wrote in message
news:10904B85-4504-425D...@microsoft.com...
mjmachuisa
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.) (Microsoft SQL
Server, Error: 223)
saw wrote:
Connection Established Successfully..Error during the log process
06-Feb-08
Hello,
Previous Posts In This Thread:
On Wednesday, February 06, 2008 4:24 PM
saw wrote:
Connection Established Successfully..Error during the log process
Hello,
On Friday, February 08, 2008 1:00 PM
Rick Byham, \(MSFT\) wrote:
Any luck on this?
Any luck on this? I would be interested in knowing what the problem was.
I have documented some of the reasons in Books Online:
http://msdn2.microsoft.com/en-us/library/ms175496.aspx
but these shouldn't occur when you make a local connection.
More reasons would be nice to add to this topic.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"saw" <swexpress(remove)@hotmail.com> wrote in message
news:eo7WuKQa...@TK2MSFTNGP06.phx.gbl...
On Tuesday, April 01, 2008 3:51 PM
Markus Bohs wrote:
I'm having the same problem. Here's my situation.
I'm having the same problem.
Here's my situation. I have SQL 2005 SP2 (3042) DEV Edition and try to
connect through application on the same machine. When using a sql login I get
the error "provider: Shared Memory Provider, error: 0 - No process is on
the other end of the pipe.". In the SQL Errorlog i see failed login messages.
So I tried Integrated Security and I can connect.
You might think that the server is configured to accept only Windows logins,
but in SSMS I can open a connection using the sql account. I already enabled
TCP and Named Pipes but no succes. I also tried other sql accounts but the
same result.
When I change the connection string to a different server the sql login
works fine.
For the moment I use Integrated Security as a workaround, but I sincerely
pray I never have this issue on a production server.
Markus
"Rick Byham, (MSFT)" wrote:
On Tuesday, April 01, 2008 4:07 PM
MarkusBohs wrote:
Just found something very weird.
Just found something very weird.
When I use a sql login with a name of 8 characters I get the error.
If I use a shorter login name it works fine. The same with a longer
loginname.
Only 8 character like "TestUser" causes the problem.
Markus
"Markus Bohse" wrote:
On Wednesday, April 02, 2008 11:33 AM
Rick Byham, \(MSFT\) wrote:
Very weird. Sorry, I have no suggestions.
Very weird. Sorry, I have no suggestions.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.
On Tuesday, May 12, 2009 8:16 PM
Roy Higgs wrote:
8 chars too
The same thing is happening for me. Trying to connect on the same server and my username is 8 characters. If that is indeed the cause chalk this one up as one of the wierdest bugs ever!!!
On Tuesday, May 12, 2009 8:20 PM
Roy Higgs wrote:
Still happens with 7 chars
Alright, just tried it with a username of 7 chars and still get the issue. Back to the drawing board.
Submitted via EggHeadCafe - Software Developer Portal of Choice
Design Pattern Interview questions part 2
http://www.eggheadcafe.com/tutorials/aspnet/5867c955-638f-435f-b720-2d3c3c35fb66/design-pattern-interview.aspx
sajjadahmad
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.
Then close the sqlserver and restart. It should work.
if the above steps donot work then try thebelow ones:
Make sure the user is not disabled
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
Mj Machuisa wrote:
Error in SQL Connection
14-Dec-09
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.) (Microsoft SQL
Server, Error: 223)
Previous Posts In This Thread:
Markus
"Markus Bohse" wrote:
On Monday, December 14, 2009 7:00 AM
Mj Machuisa wrote:
Error in SQL Connection
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.) (Microsoft SQL
Server, Error: 223)
Submitted via EggHeadCafe - Software Developer Portal of Choice
Store ASP.NET Site Visitor Stats in MongoDb
http://www.eggheadcafe.com/tutorials/aspnet/3a73c6de-82a1-4690-a7aa-d0eda58203f7/store-aspnet-site-visitor-stats-in-mongodb.aspx
gajendra...@gmail.com
THNAK YOU.