Linked Server

I'm trying to setup a linked server from SQL server to another. Here's the
catch. One server is in a domain the other is in a workgroup. I can't get
the linking to work. Has anyone gotten this to work?What kind of security are you using for the linked server login?
You should not have any issues if you are using SQL authentication.
--
Vikram Vamshi
Database Engineer
Eclipsys Corporation
"Gates" <jgates@.someisp.com> wrote in message
news:%23mhRUUenFHA.2152@.TK2MSFTNGP14.phx.gbl...
> I'm trying to setup a linked server from SQL server to another. Here's
> the catch. One server is in a domain the other is in a workgroup. I
> can't get the linking to work. Has anyone gotten this to work?
>|||I'm using Windows Authentication on the server in the workgroup.
"Vikram Vamshi" <vikram.vamshi@.online.eclipsys.com> wrote in message
news:OtU5$ffnFHA.1468@.TK2MSFTNGP12.phx.gbl...
> What kind of security are you using for the linked server login?
> You should not have any issues if you are using SQL authentication.
> --
> Vikram Vamshi
> Database Engineer
> Eclipsys Corporation
> "Gates" <jgates@.someisp.com> wrote in message
> news:%23mhRUUenFHA.2152@.TK2MSFTNGP14.phx.gbl...
>