Please try to execute: sp_helpserver and see if you see repl_distributor in
the query result. If so, please remove the repl_distributor server as no
replication is set up.
To remove the repl_distributor, please execute the following SQL statement:
exec sp_dropserver 'repl_distributor', 'droplogins'
After removing repl_distributor, try to set up replication again and see if
Microsoft Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
I am trying to configure database server with paramters such as below
Distributor/Publisher : user sa, database : test
Subcriber : user : abc (dbowner), database : test1
I configure Publisher as Transactional and Queue Update
I configure "type Push Subscriber" to replicate 2 database
But it's OK to update data from Publisher to Subscriber and when
Updating occur in Subcriber it can' t update to Publisher and it has error
as message below :
Server: SERVER, Database pmw : ODBC Error:Could not change the
Publisher because the subscription has been dropped. Use
sp_subscription_cleanup to clean up the triggers.