October 15th, 2003, 02:44 AM
MSSQL 2000 Server Database Replication
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:
Windows 2000 Server with SP4, MSSQL 2000 Server with SP3. Services startup account - domain account with administrators right.
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!