remote connection problem

• Naadir Peterson

  Newbie

  Points: 1

  More actions

  February 8, 2006 at 8:26 am

  #67139

  Hi

  I'm having a problem connecting to a remote sql server 2000, A, database using asp.net 2.

  Im able to connect to another remote database, B, fine but when i connect A 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: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

  I figure it might be a server problem. I tried using all sorts of connection strings.

  Thanks

• Jo Pattyn

  SSC-Dedicated

  Points: 32510

  More actions

  February 9, 2006 at 4:31 am

  #619725

  Best bet is contacting the administrator of server A (could be a security setting)