Solved

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

Posted on 2011-03-13
5
538 Views
Last Modified: 2012-06-27
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

0
Comment
Question by:Stan_Greene
  • 3
5 Comments
 
LVL 3

Expert Comment

by:ccwill88
ID: 35125523
Try to Ping your client from server.
Maybe DNS has wrong client's ip
0
 

Author Comment

by:Stan_Greene
ID: 35125553
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
0
 
LVL 3

Expert Comment

by:kotukunui
ID: 35132008
Can you post your SQLCA settings for the PowerBuilder application? (Obscure any passwords of course...)
0
 

Accepted Solution

by:
Stan_Greene earned 0 total points
ID: 35170499
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.

Thanks

Stan
0
 

Author Closing Comment

by:Stan_Greene
ID: 35196784
We tried multiple configurations.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question