DM,
Sorry, don't know about this personally, but perhaps these conversations
will help you.
http://www.msdner.net/dev-archive/13/12-40-139178.shtm
http://forums.asp.net/p/993719/1295643.aspx
The consensus from Googling around seems to be that "target machine actively
refused it" usually means that the service you are trying to connect to is
inactive. This may not be your SQL Server, but the SSH tunnel server.
In case you want to pursue other posts, my Google search was for:
"target machine actively refused it" tunnel "SQL SERVER"
You can drop the "SQL Server" to get other posts related to tunneling
problems.
RLF
"DM" wrote in message
> As a result of the new network policy in our company, I can no longer
> access a Sql Server instance located on a remote domain. Till now I
> accessed
> it by using "DataSource=mssql.domain.com\SQLEXPRESS;..." . Right now I am
> trying to access it by using a ssh tunnel. I set up a tunnel :
> L3392<->mssql.domain.com\SQLEXPRESS:1433 and tried to access it using
> "DataSource=localhost,3392;..." . But it doesn't work. I am getting the
> "...target machine actively refused it." error. Anybody has experienced
> this
> before?
> Thanks for your time,
> DM