
October 15th, 2003, 02:44 AM
|
|
Registered User
|
|
Join Date: Jul 2003
Location: Malaysia
Posts: 10
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
MSSQL 2000 Server Database Replication
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
|