Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-27 : 11:15:50
|
Jayamaruthyraman writes "Hi,
My setup is as follows:
2 Windows 2000 Professional edition (SP1) running MSSqlServer 7.0 SP3. I am trying to setup snapshot replication with immediate updation.
Initial snapshot goes through fine and the subscriber database is populated with data from from the publisher database.
But when I open a transferred database on the subscriber machine and update a table row, I get the message 'Login failed for user 'sa''.
I tried running the sp_link_publication, but no avail. Both the SQLServers have their own passwords.
Whenever I remove the passwords on the both the machines for sa the replication is successful from both the ends.
Is there any reason why I am not able to do replication from the subscriber if there is a password on the SQLServer user 'sa'?
I am able to create linked servers from both publisher and subcriber SQLServer installations and it works fine.
thanks,
J Maruti" |
|
|
|
|
|
SQLServer Replication