ConnectionOpen(Connect()) in SQL server 2000

hi,
i am new to SQL Server 2000 n trying to set up a Server in Windows 200
pro,
but whenever i try to Register the server it fails n gives the below
error,
ConnectionOpen(Connect()) faIled.
plz if some one can rectify this issue,
thanks in advance,
mandeepFirstly check if your SQL Server services are running; If yes then
proceed
Start-->programs --> Microsoft SQL Server --> Client Network Utility
Check to see if TCP/IP and NamedPipes are enabled only check if Shared
Memory is checked, if its not checked, check it

ConnectionOpen (PreLoginHandshake()). General Network Error

Hi all,
I'm getting the following error on my SQL on a local machine when running a
client program that connects to sql server located at the same machine. What
does it means? Do i have to configure in SQL settings?
[DBNETLIB]ConnectionOpen (PreLoginHandshake()). General Network Error.
thanks,
joelNormally this message would indicate a timeout of some kind attempting to
connect. Open the SQL Client Network Utility and see if Shared Memory is
enabled. If it is not enable it and see if the problem goes away. Local
connections by default should use shared memory so it would appear that
this is not enabled.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Connection.Open () ERROR ! Unable to find stored procedure sp_sdidebug.

Hi all,

When I try to open a connection it gives me error "Stored Procedure sp_sdidebug not found"

Can anyone help me in this respect?

I was running the same application with the SQL Server 2005 only earlier when it was running.But now after I reinstalled VS.NET & SQL Server I am getting this error.What could be the problem?

Please help... I am badly stuck up.

PAM

To rule out the obvious, have you double checked that sp_sdidebug exists on the server that your SQL connection is connecting to? Also, are you connecting to the same server?|||

You are right this stored procedure does not exist in <Database>/Programmability/Stored Procedures/

Is this the location where I should see for it or I need to look into Master?Even that is not there.I checked all other databases but this procedure is nowhere.

What can be done?I have already reinstalles Sql Server 2005.

& I am really stuck up in a stupid issue of connecting to database.

Please advise me something.

Pam

|||

I found the answer somewhere in online forums.The cause of the problem was that the sql server debugging was enabled in the debugging properties of the project.

thanks anyways.

pam