Replication --Procedure or function sp_MSadd_snapshot_agent has too many arguments specified.

chrisrdba 361 Reputation points

Our current environment is OLTP and replication both on windows 2016, SQL on 2019 (15.0.4198).

We want to upgrade to upgrade to windows 2022 for OLTP only (long winded reasons), and have already built the OLTP server. When I installed SQL I naturally installed the latest CU that's mentioned above, and am experiencing this issue. We're scheduled two weekends from now.

Now when trying to create the Publication I get the error:

"Procedure or function sp_MSadd_snapshot_agent has too many arguments specified."

Someone in this post mentioned it may be either an outdated distribution server or the specified CU on OLTP.

The final crack in the chin is we dont replicate non production, so I have no place to test anything.

All said I think my two options are

1.     Uninstall the latest CU from my new OLTP, and drop it down to the same version that's on current OLTP. The problem here is that means that testing hasnt been done on the real version. I think this is a small risk, but still there.

2.     Upgrade the CU on replication to this higher level. The problem there is finding available time, as well as not being able to test first since we dont replicate in non Prod.

Im going w option 1 trying to uninstall the KB, but halfway through it's complaining that I need to produce sql_engine_core_inst.msi in the form of a CD, which I don't have. What it is is described here, but involves going further down the rabbit hole Im trying to avoid, at least before I know if Im on the right track or not.

I have a lot going on here. I've got a not very documented replication issue, and and unable to complete the one workaround I can find for it. Can anyone assist with either issue?


SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,571 questions
{count} votes

1 answer

Sort by: Most helpful
  1. chrisrdba 361 Reputation points

    Like the post in the link I provided above, I uninstalled 15.0.4322, reinstalled 15.0.4198, and was able to create the replication as expected.

    Thanks Microsoft!

    0 comments No comments