data collector for sql server 2022

Question

I have just installed sql server 2022 (RTM). I am trying to get the data collector to work against a 2019 MDW database but get error message

"Executed as user: NT Service\xxxxxxxxxxxxx. The step did not generate any output. Process Exit Code -1073741511. The step failed."

I tried it with a 2022 MDW database and get the same result.

After some research it looks like a missing dll? but i've no confidence in that diagnosis and no idea what dll it may be if it's right.
The 2019 mdw database works with the rest of the estate (2012-2016-2017-2019)

Ray

Answer 1

Hi @Ray Miller ,

I'm a little confused about the version of SQL Server you are currently using. If it is the 2019 version, I suggest you install the latest cumulative update (CU18). Since there is no patch for 2022 yet, you can try using the Repair option. In SQL Server Installation Center->Maintenance->Repair

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

When i was trying Data Collector on previous SQL Server versions in some rare attempts i got error messages too. I fixed this by using different version of Management Studio. Maybe it is not your case but try to use different version of SSMS if you configure DMW in graphic or try use Data collector stored procedures.