Replication and SQL Server Authentication

I'm trying to use replciation between two computers that run SQL Server that
has been installed using mixed mode authentication, but the replciation
fails. Here are the details:
The Publisher/Distributer - I have installed SQL Server using mixed mode
authentication and used a blank password for user 'sa'. The Publisher has
registered the Subscriber succesfully using SQL Server authentication.
The Subscriber - The same as the Publisher.
I prepared a database for a merge publication and the snapshot agent
completed its job successfully.
When I push a new subscription to the publication, the merge agent fails
declaring that he couldn't connect to the subscriber as login for us 'sa'
fails because it is not associated with a trusted connection.
I knew form Microsoft SQL Server administration book that a trusted
connection is used for windows authentication.
I have reinstalled SQL Server on the Subscriber using Windows
authentication, the publisher remains the same, but te problem remains the
same.
Can a merge publication be used when both the publisher and the subscriber
use SQL Server authentication?!
Thanks in advance,
Shehab.
Go to Tools, Replication, Configure Publishers, Distributors and
Subscribers, and click on the Subscribers tab. Click the browse button to
the right of your subscriber, make sure you are using SQL Authentication
here and make sure the password is blank.
Actually you should not be using a blank password at all. Its a secuirty
risk.
Hilary
"Shehab Kamal" <ShehabKamal@.discussions.microsoft.com> wrote in message
news:527D5795-FA53-44D6-9C73-FD604698A5AA@.microsoft.com...
> I'm trying to use replciation between two computers that run SQL Server
> that
> has been installed using mixed mode authentication, but the replciation
> fails. Here are the details:
> The Publisher/Distributer - I have installed SQL Server using mixed mode
> authentication and used a blank password for user 'sa'. The Publisher has
> registered the Subscriber succesfully using SQL Server authentication.
> The Subscriber - The same as the Publisher.
> I prepared a database for a merge publication and the snapshot agent
> completed its job successfully.
> When I push a new subscription to the publication, the merge agent fails
> declaring that he couldn't connect to the subscriber as login for us 'sa'
> fails because it is not associated with a trusted connection.
> I knew form Microsoft SQL Server administration book that a trusted
> connection is used for windows authentication.
> I have reinstalled SQL Server on the Subscriber using Windows
> authentication, the publisher remains the same, but te problem remains the
> same.
> Can a merge publication be used when both the publisher and the subscriber
> use SQL Server authentication?!
> Thanks in advance,
> Shehab.