Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > connection issue from our developer
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 3rd April 13:26
lynn
External User
 
Posts: 1
Default connection issue from our developer


We only enable Shared Memory and TCP/IP protocal in server side. And, those
are the error they are getting.

osql -- SQL server doesn't exist or access denied
Query ****yzer -- General network error. Check your network do***entation
VS 2005 -- (without specifing TCP protocal in connection) A connection was
succssfully established with the server, but then an error occured during the
pre-login handshake. When connecting .....(provider: Named Pipes provider,
error: 0 - No process is on the ther end of the pipe)
VS 2005 -- (specify TCP protocal in connection) An error has occurred while
establishing a connection to the server. When connecting to SQL server 2005,
this failure may be caused by the fact that under the default settings ...
(provider: TCP provider: 0 -- A connection attempt failed because the
connected party didn't not properly respond after a period of tiem, or
established connection failed because connected host has failed to respond.)

Again, this developer is able to login by using my machine with his WIN
account.

After I enable Named Pipes in server. This developer is able to connect to
server on his machine by using Named Pipe.

Firewall is off in the server, so I can't think of the issue for TCP
connection on developer's machine.

Please advise. Thank you.
--
Best Regards,

Lynn
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666