Solved

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

Posted on 2007-12-06
2
17,072 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Creating an OSPF network that automatically (dynamically) reroutes network traffic over other connections to prevent network downtime.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

830 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