I am working with a database on another system via a ssh tunnel using
plink. We have setup an alias the local system for the remote database.

I am able to connect and work from within Visual Studio if I connect to

the remote database using with "SQL Server" as the data source and
".NET Framework Data Provider for OLEDB" as the data provider . If I
change the data provider to ".NET Framework Data Provider for SQL
Server" 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 setting SQL Server does not allow remote
connects. (provider: TCP Provider, error: 0 - No connection could be
made because the target machine actively refused it.)"


What do I need to do to fix this?


All help is appreciated.


===


Local system:
    Windows 2000 Professional,
    SQL Server 2005 Standard
    Visual Studio 2005 Standard
    .NET Framework 2.0 (1.1 not installed)


Remote system:
    SQL Server 2000

Enterprise Mgr - alter table fails
Checkpoint causes need for better IO subsystem?
Exception trying to import data from Excel .
SQL Server 2005: Error 14258...SQL Server Agent is starting
behavior of command in the 'SQL Query Analyzer'