"Hassan" <hassan@hotmail.com> wrote in message
news:uIDJeKudHHA.4964@TK2MSFTNGP04.phx.gbl...
> When I use transactional replication and push data to a set of subscriber,
> what authentication does the publisher( w/ distributor) use to connect to
> the subscriber ? Is it SQL Auth or Windows Auth ? If SQL, what is the
> username ? If Windows, is it the SQL Server or SQL Agent Service Account?
>
> The reason I ask this is my subscribers are outside the corporate network
> and are not on the same domain. I can use SQL Auth to connect to an IP
> address of the subscriber, but was wondering how do I create my
> transactional replication using that SQL Auth. Where do i insert that SQL
> Auth in the distribution agent ?
>
> Using SQL 2000
>
> Thanks
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:eg1IUZ3dHHA.1240@TK2MSFTNGP04.phx.gbl...
> That depends on how you have created your subscriber. In your case you can
> you would define a sql account on the publisher when you add your
> subscriber, or use pass through authentication when the sql server agent
> account on the publisher is the same account name and password as a SQL
> account on the subscriber.
>
> --
> Hilary Cotter
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
>
>
> "Hassan" <hassan@hotmail.com> wrote in message
> news:uIDJeKudHHA.4964@TK2MSFTNGP04.phx.gbl...
>> When I use transactional replication and push data to a set of
>> subscriber, what authentication does the publisher( w/ distributor) use
>> to connect to the subscriber ? Is it SQL Auth or Windows Auth ? If SQL,
>> what is the username ? If Windows, is it the SQL Server or SQL Agent
>> Service Account?
>>
>> The reason I ask this is my subscribers are outside the corporate network
>> and are not on the same domain. I can use SQL Auth to connect to an IP
>> address of the subscriber, but was wondering how do I create my
>> transactional replication using that SQL Auth. Where do i insert that SQL
>> Auth in the distribution agent ?
>>
>> Using SQL 2000
>>
>> Thanks
>>
>
>