Post reply

Romote Connection to SQL Server 2000 using VS 2005.

  • October 5, 2006 at 6:42 am

    #75068

    I am attempting to connect to a sql server db through a remote connection and I get the following error:

    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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    Here is the thing, I am using sql server 2000! I am assuming that it may be something in visual studio 2005 that causes it to think it is looking for a sql server 2005 db. Anyway, I am stumped.

    I have no issues connecting to the db within my network using the same code and I can connect to the db remotely using php so I know the db is accessible inside and outside the network.

    I am an applications developer so I am not sure if this is the right place to look as but any help would be appreciated.

  • October 5, 2006 at 7:49 am

    #664310

    Hi Ozell ,

    You have to install the Sql Connectivity Tools on the Sever in which Visual Studio 2005 is installed.

    Then you will be able to access it.

    I am not very sure but it might be the reason for it.

    Please think about it.

    Thanks & Regards

    Amit Gupta (MVP)

    * Think Positive . Be Positive. *

     

  • October 5, 2006 at 12:45 pm

    #664425

    VS is not installed on any of the servers, it is only installed on the development machine. I can make connections from my dev machine as well as a networked server. I can not make them from the remote sever. This only applies to 2.0 apps. 1.1 apps find the db just fine.

Viewing 3 posts - 1 through 3 (of 3 total)

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