Solved

TCP Provider: An existing connection was forcibly closed by the remote host.

Posted on 2007-12-06
2
17,065 Views
Last Modified: 2011-03-10
I have asked this question before and tried many fixed but wondering if anyone can offer any more suggestions.
TCP Provider: An existing connection was forcibly closed by the remote host.

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

the connection works every so often, so i think i have everything setup right, but then most of the time i get this error. i have not changed anything in between when it works and when it does not work.

this connection is to a linked server view. when i connect to a local table it always works. with the linked server view i would say it works about 10% of the time, all other times i get the above error.

searched everywhere i can find, no good results to fix it.
0
Comment
Question by:edi77
2 Comments
 
LVL 9

Accepted Solution

by:
codeclay earned 500 total points
ID: 20418340
0
 
LVL 18

Expert Comment

by:Ajay Sharma
ID: 20418350
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

863 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

20 Experts available now in Live!

Get 1:1 Help Now