SQL Enterprise Manager unable to find Instance

[Atom]

I'm having an odd problem with my sql server box on a 2003 server OS. Im unable to remotely connect to the sql server even though i can connect to an MSDE install on the same box. Im getting the following error,

A connection could not be established to Server_Name

Reason: Invalid connection.

ConnectionOpen (Invalid Instance())..

I've tried ODBC and query analyzer and neither can connect.

I dont belive it to be authentication because i cant even speak to the box let alone get to a point that requires authentication.

Any ideas would be of great help. Thanks

[garethevans1986]

May sound stupid but, any firewall running on the server machine?

And is all networking correct between that server and your machine?

Example: Ping, etc

ChocIST

[jonovate]

We're having the same problem now. Our SHAREPOINT is an upgraded MSDE -> SQL Server 2000 instance.

We have ISA running, but from a workstation it can connect to the default local instance on the server, but not the SHAREPOINT instance for example. Already gave full login to the windows account im trying with. ANyone have an idea?

[jonovate]

Make the following CODE into a .reg file, then run it on your test client (then all clients needing to connect if it works). The only thing you should have to change is MYSERVER\\SHAREPOINT to your server\instance

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo]
"SHAREPOINT"="DBMSSOCN,MYSERVER\\SHAREPOINT,1433"