I am having a similiar issue as has been described here except for one thing.  I can access the SQL2000 linked server (security context set to use this specific windows account) while I am logged in as that user.  However, if I login as a different user, I then receive the "TCP Provider: An existing connection was forcibly closed by the remote host.  Login failed for domain\user".  I have not set up anything for Kerberose, but as I understand it, it is only needed in a double-hop instance.  In this case, since I have selected "Be made using this context", I am under the impression that the login happens directly from the SQL Server to the linked server thereby creating only a single hop.  Can you explain what I need to do to make this work?

 Thanks.

I am having a similiar issue as has been described here except for one thing. The two servers are in different modes and will need to stay that way (2005- mixed; 2000 Windows).  When using the "...made using this context..." I also get the "TCP Provider: An existing connection was forcibly closed by the remote host.  Login failed for domain\user".  I have not set up anything for Kerberose, but as I understand it, it is only needed in a double-hop instance.  In this case, since I have selected "Be made using this context", I am under the impression that the login happens directly from the SQL Server to the linked server thereby creating only a single hop.  Can you explain what I need to do to make this work?

 Thanks.

That TCP error sounds like some network issue, check whether any dropped packet or issue within firewall for such authentication

Can you try to reproduce this on your end?  Create a linked server as follows.

From a PC/Laptop connect to the instance containing the linked server and run "Select * from LinkedServer.Database.dbo.sysobjects"

See if you get the following error.

I believe the problem is related to MSDTC on Windows 2003 Server and the linked server option   "Be made using the login's current security context"

Thanks,  Dave 

I have tried it and didn't get that error. The SQL instance runs under a domain accoun which has ADMIN privileges on that server along with permissions for MSDTC....

I'll try with Win2k too to see whether it happens...

HI,

I'm alos facing the same issue.

We havea server which is in Domain and is Running on SQL Server 2000 and with windows authentication.

Now we have another server running on 2005 and is not part of any domain and running in mixed mode. Now I want ot create a linked server on the 2nd server to the one which is running in domain. Wht should I do? I already created a user in domain and granted the necessary db access in 1st server. and created the same user (with same user id and p/w) in 2nd server which is not in domain and granted the db access. But still I'm not able to access the tables.

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

Reason: Not associated with trusted sql server connection. 

Can anybody help and give a step by step process to handle the situation.

In the past I have also attempted following step to resolve:

Add the following registry key and reboot the server.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\SycAttackProtect{DWORD} = 0

Make sure to test this before you apply on the live server.

I missed one thing Both the servers are not part of any domain and 1st one is running with windows authentication and 2nd is in mixed mode...Now I want to create linked server on 2nd server pointing to 1st server??? Is this possible? If Yes then How?

FYI: 1st server is on SQL Server 2000 standard SP4...2nd is on SQL Server 2005 Standard.

Its Very Urgent....

Thx

 

You should use with a common account between these server in order to pass-thru the authentication whihc is the first layer of connectivity.

Then Should I create the same user in 2nd server with same p/w and then try to connect???

Will this work???

Guys....I've tried everything to make this possible but I wasn't able to do it....

Can any body help me?

Satya where r u?

Rohit