Solved

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

Posted on 2011-03-13
5
531 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now