Link to home
Start Free TrialLog in
Avatar of Stan_Greene
Stan_Greene

asked on

TCP Provider: No connection could be made because the target machine actively refused it.

1.I have insstalled SQLNCLI.MSI ( Sql 2005/2000 version) and now getting this message.
2. I have tried telnet server and it is OK
3. I have set up an ODBC connection and it connects OK
4. Using SNC as MSS no longer supported by MS. The connection is for a PowerBuilder application
5. Old PowerBuilder app still connect OK to server using MSS
6. Same application has been installed using same SQLNCLI.MSi and same app at several other sites
7. Firewall lets default SQL Server port through

I am stumped. Any assistance will be greatly appreciated.
Stan

Avatar of ccwill88
ccwill88
Flag of Taiwan, Province of China image

Try to Ping your client from server.
Maybe DNS has wrong client's ip
Avatar of Stan_Greene
Stan_Greene

ASKER

I;m working remotely to NZ from Australia. I'll get the local client support person to check your solution.

Thanks for the prompt response.

Stan
Can you post your SQLCA settings for the PowerBuilder application? (Obscure any passwords of course...)
ASKER CERTIFIED SOLUTION
Avatar of Stan_Greene
Stan_Greene

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
We tried multiple configurations.