[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2011-03-13
5
Medium Priority
?
544 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

656 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