Management Studio with SQL Server 2000

  • Thought the article was helpful, but I am having issues connecting my SQL 2005 Management Studio on my notebook to the SQL2000 server instance on my workstation.  I keep getting this error, but "help" link doesn't go anywhere.  Any chance you can help me figure this out?  Thanks.


    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 SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

    For help, click:

  • Greg,

    Can you connect to that same server from your client using Enterprise Manager? That error may suggest that the installation of SQL Server may not be letting anyone connect to it from outside the server.


    Rob Farley
    LobsterPot Solutions & Adelaide SQL Server User Group

  • Hi,

    I have the same problem as Greg. I am trying to connect to a remote SQL Server 2000 DB from SQL Server 2005 Management Studio and I get the exact same error message. Any ideas??

    I can connect using Enterprise Manager so the remote server is fine.


    Scott Anderson

  • well, i tried to use the SMSS with my SQL SERVER 2000 engine and when i started using the Object Explorer by double click over my Database then Tables, then double click over a given table it shows me this error:

    any clue?

Viewing 4 posts - 31 through 33 (of 33 total)

You must be logged in to reply to this topic. Login to reply