December 21, 2012 at 11:26 pm
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
December 22, 2012 at 11:21 am
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
December 27, 2012 at 6:56 pm
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply