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.

Who is Participating?
Stan_GreeneConnect With a Mentor Author Commented:
Thanks for prompt response. The issue has been solved. When connecting frpm app installed on the server , server addressed as (local) worked Ok. However when connecting from a workstation this diod not work. It worked addressing the server by the server name.


Try to Ping your client from server.
Maybe DNS has wrong client's ip
Stan_GreeneAuthor Commented:
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.

Can you post your SQLCA settings for the PowerBuilder application? (Obscure any passwords of course...)
Stan_GreeneAuthor Commented:
We tried multiple configurations.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.