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 |
|
netjam
Starting Member
37 Posts |
 Posted - 2008-05-26 : 00:24:31
|
| transactional replication with Updatable subscription – Allow queued updating subscription enabledChanges are replicated on subscription fine but when data changed on subscription I’ve got this: Server: A, Database B : ODBC Error:Could not change the Publisher because the subscription has been dropped. Use sp_subscription_cleanup to clean up the triggersI tried to use Allow immediate updating subscription as well but was given this error:Failed login for user saAny ideas? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-26 : 00:37:46
|
| It's permission issue, you have to run following on subscriber:sp_link_publication @publisher='server_name', @publisher_db='db_name', @publication='pub_name', @security_mode=0, @login='sa', @password='' |
 |
|
|
netjam
Starting Member
37 Posts |
Posted - 2008-05-26 : 01:28:18
|
| ThanksI resolved. But diff wayPublisher is DMZ server and subscriber is internal server. The issue was that subscriber was registed on publisher with a name diff from subscriber server name, using Client network utility.When I registed subscriber with it's real name(again using CNI). than All started to work fine. |
|
|
|
|
|
|
Transactional Replication