"Kim" <anonymous@discussions.microsoft.com> wrote in message
news:0c2701c3b044$61d4b320$a301280a@phx.gbl...
> How can I connect to a SQL server that is on a different
> domain?.
>
> We have 1 NT and 1 Windows 2000 Domain Contollers both
> with SQL on. We used to dial in and connect, for
> replication purposes, which was fine but we now need to
> connect across a lan without re-configuring the domain
> server that SQL is on.
>
> I have set up the trusted and trusting connections on the
> respective domain controllers and tried making the 2000
> server a router. But I still cannot get a connection from
> either of them.
>
> The permissions are the same for both.

"Linchi Shea" <linchi_shea@NOSPAMml.com> wrote in message
news:030e01c3b06c$fb11a520$a301280a@phx.gbl...
> Just want to add,
>
> If you don't have to use Windows authentication, the trust
> relationship between the domains doesn't matter. You can
> always connect via TCP sockets, which requires only TCP
> level connectivity.
>
> Regards,
>
> Linchi
>
> >-----Original Message-----
> >How can I connect to a SQL server that is on a different
> >domain?.
> >
> > We have 1 NT and 1 Windows 2000 Domain Contollers both
> >with SQL on. We used to dial in and connect, for
> >replication purposes, which was fine but we now need to
> >connect across a lan without re-configuring the domain
> >server that SQL is on.
> >
> >I have set up the trusted and trusting connections on the
> >respective domain controllers and tried making the 2000
> >server a router. But I still cannot get a connection from
> >either of them.
> >
> >The permissions are the same for both.
> >
> >Thanks
> >.
> >