Recommended Posts

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

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?

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"

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.