object was not found on the server check if the object exists on the server (Sql Server)

Srikanth Cherupally 1 Reputation point
2022-08-31T13:44:27.633+00:00

I am trying to do a merge replication( from local sql server to destination sql server on azure vm) , using windows authentication

when i try to create /connect subscriber , got error message saying

"object was not found on the server check if the object exists on the server" , Please check the screenshot

236588-6.png

thanks for your support

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,820 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
496 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 41,006 Reputation points
    2022-08-31T14:25:46.943+00:00

    In the error message click on "Show details" for more details.

  2. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2022-09-01T02:34:53.86+00:00

    Hi @Srikanth Cherupally ,

    According to your error message, please check if the target database is existed on your subscriber server? Which account that your merge agent running under? Did the login used to connect to the subscriber server is a DB owner of this subscription database?

    236680-capture9.png

    236724-capture10.png

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments