Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to connect sql server Expand / Collapse
Author
Message
Posted Friday, December 21, 2012 11:26 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, April 21, 2014 12:41 PM
Points: 65, Visits: 234
hi guys,

While connecting to sql server named instance we are getting following error:

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

reply......thnx
Post #1399653
Posted Saturday, December 22, 2012 11:21 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:02 PM
Points: 2,357, Visits: 6,195
The error "(Microsoft SQL Server, Error: 233)" is because the SQL Server client cannot connect to the server. This error could occur because the server is not configured to accept remote connections.

see the link below for more info
http://msdn.microsoft.com/en-us/library/bb326280(v=sql.100).aspx

http://msdn.microsoft.com/en-us/library/ms345318(v=sql.100).aspx
Post #1399695
Posted Thursday, December 27, 2012 6:56 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 2:46 AM
Points: 55, Visits: 159
You may want to try this steps.

1. Log on to the machine where the sql server instance resides.
2. Start SSMS. Use windows authentication (assuming your account have access to the server).
3. Right click the instance and choose properties.
4. Select Connections on the left pane.
5. Tick "Allow remote connections to this server". found on the right side.
6. Click ok button.
7. Close ssms and logoff to the server.
8. Access the sql instance again using ssms from a remote server.
Let me know if this works.
Post #1400773
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse