Connectivity across Domains. -- sql server connect

Simon
12/13/2005 5:17:07 AM

The two domains do not trust each other and the Network guys have no
intention of changing this. However when i try and link the server with
username and password I still can`t connect to run a query on the linked
server.

Si

[quoted text, click to view]

Jeff A. Stucker
12/13/2005 1:48:25 PM

Make sure the request is going over TCP rather than named pipes. The latter
tries to enforce a network login even though you're using SQL
authentication.

--
Cheers,

'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com

[quoted text, click to view]

Mike Epprecht (SQL MVP)
12/13/2005 1:55:53 PM

Hi

Unless you have a trust relationship between the 2 domains, you need to use
a SQL Server login for the linked server.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]

Sue Hoegemeier
12/13/2005 6:54:32 PM

And use an IP address for the server name.

-Sue

On Tue, 13 Dec 2005 05:17:07 -0800, "Simon"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server connect

sql server connect : Connectivity across Domains.