Hi there,

I try to setup/configure MSSQL Database replication over Internet!

My SQL server on both site can communicate with each other with no problems.

I follow the steps from Microsoft Press book - but it would work! The configuration is as below:

Publisher
Windows 2000 Server with SP4, MSSQL 2000 Server with SP3. Services startup account - domain account with administrators right.

Subscription
Windows 2003 Server, MSSQL 2000 with SP3. Services startup account - domain account with administrators right.

I have enabled the Windows 2003 server as subscription. When I start the agent - it say cannot log on to server with sa!! But I can access both server with no problems - and I sure the password is correct!

Any ideas?

Thanks

Wings