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 |
|
jacksolm
Starting Member
4 Posts |
 Posted - 2008-01-01 : 16:22:02
|
| We have a problem with updatable subscriptions. We have a Citrix database that requires a replicated database. We want to use updatable subscriptions that allow our subscriber to be able to write to the database and send the updates to the publisher. Well when ever we try to update the database within the Citrix software by adding another server to the farm, the IMA service fails which is because it cant write to the database. Whenever I point to the publisher(over the WAN) the service starts without error because it can access and write to the database.In the database replication logs I noticed an error that says that the subscriber cannot reach the publisher however it was successful on the initial replication. Im thinking that it is not able to do the update when we join another server to the farm. Is the account needed to connect to the server the same as the account required to connect to the publisher or is it the account required to log into the SQL database engine such as the sa account? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-01 : 20:17:13
|
| What you can try is connecting to publisher in subscriber's em, other thing to check is did you run sp_link_publication on subscriper when set replication? It's required for updatable subscriptions. |
 |
|
|
jacksolm
Starting Member
4 Posts |
Posted - 2008-01-01 : 20:36:28
|
| We had to run the sp_change_user script for one reason or another on the subscriber. I am new to SQL Server from a DBA point of view.I will try the stored procedure you mentioned. Not sure what you mean by subscriber em... |
|
|
|
jacksolm
Starting Member
4 Posts |
Posted - 2008-01-01 : 20:38:03
|
| Another piece of info: We created the subscription using the wizard. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-01 : 22:21:49
|
| EM is enterprise manager, ensure both servers can talk to each other. |
|
|
|
jacksolm
Starting Member
4 Posts |
Posted - 2008-01-01 : 23:31:30
|
| Im sorry I forgot to mention a few details, we are using SQL Server 2005. But under Mgmt Studio, I can connect to the publisher without error. It also is successful in replicating the entire database to the subscriber. The problem comes when we try to update from the subscriber. I think it involves MSDTC to send the updates to the publisher? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-03 : 22:51:39
|
| Again, did you run sp_link_publication on subscriper? |
|
|
|
|
|
|
Replication - Updatable subscriptions