I'm trying to creating a new store. Added a store in HQ Manager without any problem. When trying to exporting a database to new store, all steps are working fine, The database has been created. Copied the template data from the source database to the destination database fine, until i came down to export. I clicked on Export, and the error popup as follow:
An error was encountered while exporting data. Your Store Operations database is not complete and may not work correctly.
Error -2147217900: Cannot drop server 'MYSQL001' because it is used as a Publisher in replication. sp_dropserver 'MYSQL001', 'droplogins' SELECT @@ROWCOUNT AS RecordsAffected
---------------------
Any ideas or helps would be appreciated. Thanks.