System.Net.Sockets.SocketException: No connection could be made because the target machine actively

microsoft.public.dotnet.framework.adonet

9 Aug 2006 12:50 PM

daz_oldham

Hi

I have what I believe an ADO.net problem with my ASP.net (c# 2.0)
application.

Background: Originally developed with VS2005 on an XP box with SQL
Server 2005 and running on Windows 2000 with SQL 2000. I am only
doing basic stored procedures so the database has transferred
perfectly.

When I try to run my application remotely I get the above mentioned
error message. When I change the password for the user, I do get a
"logon failed" so I know that the web server is managing to connect to
the SQL Server.

If I run the application locally (in VS2005 debug mode) with the
connection string pointing to the SQL Server remotely, it works in full
without any problems whatsoever. Strange huh!

The remote server runs both 1.1 and 2.0 applications if it help any.

Many thanks

Darren