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.
data collector for sql server 2022
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
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
SQL Server | Other
2 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 39%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
David Hlaváček 1 Reputation point2023-01-10T21:38:50.167+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Seeya Xi-MSFT 16,676 Reputation points2023-01-04T06:44:57.427+00:00 Hi @Anonymous ,
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.-
Anonymous
2023-01-04T09:36:33.377+00:00 There are two parts to the Management Data Warehouse subsystem. The instance on which you are collecting data and the instance where the data is stored.
In this case the data warehouse (mdw databases) is running on sql server 2019, although I have briefly tries sql server 2022.
The instance trying to collect data is on sql server 2022.The two instances in question are on the same server
Your 'answer' is more a comment. The sql server 2019 is patched to date. I'll try a repair at some stage, but it was only installed a few days ago, so shouldn't need repairing already.
Sign in to comment -