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.