Solved

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

Posted on 2007-12-06
2
17,051 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
Comment Utility
0
 
LVL 18

Expert Comment

by:Ajay Sharma
Comment Utility
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
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.

743 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

16 Experts available now in Live!

Get 1:1 Help Now