Unable to create a new project - Could not load file or assembly 'System.Text.Json

Dan_ODan_O Posts: 3 New member
in SQL Data Generator
Full error: Could not load file or assembly 'System.Text.Json, Version=8.0.0.4, Culture=neutral, 
PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The system cannot find the file specified.

No major changes to the VM, that I'm aware of. 
Tagged:
· Share on Twitter

Answers

  • hassan_imamhassan_imam Posts: 51 Bronze 1
    Hey Dan, 

    Apologies for the issues you're experiencing with SQL Data Generator. Could you let me know which authentication method you're using to connect to SQL Server?  SQL Data Generator does not natively support Multi-Factor Authentication (MFA) for SQL Server. This is because MFA typically requires interactive prompts, which are not supported by SQL Data Generator's connection mechanisms. The tool primarily supports SQL Server Authentication and Windows Authentication. 

    Best, 

    Hassan 
    Product Support Engineer
    · Share on Twitter
  • Dan_ODan_O Posts: 3 New member
    Hi Hassan, 

    I've been using 'Active Directory universal with MFA' for months now, it hasn't been a problem until I tried it yesterday. I see the MFA prompts and can authenticate properly; I can pick the database I want to use but when I click 'ok' to start the project I get the error. I'm passed the MFA prompts at that point. Side note: I am still able to use this authentication method with the Mulit-Script tool, and SQL Compare. 
    · Share on Twitter
  • hassan_imamhassan_imam Posts: 51 Bronze 1

    Hi Dan,

    Thank you for the additional details. Could you please confirm if there have been any changes to your setup. The error message you received points to a potential issue with the .NET assembly on your system. Our application requires .NET Framework version 4.7.2 or later to function correctly, which I assume is in place since there haven't been any major changes reported.

    Additionally, I noticed that there was an update released for SDG to version 4.6.2 yesterday. Can you confirm if this is the version you currently have installed? If not can you let me know which version you have installed? 

    · Share on Twitter
  • Dan_ODan_O Posts: 3 New member
    Hassan - I have v4.6.2.5848 installed, I did perform the update yesterday after I was having this issue. I thought the update would fix it, but it did not. I can also confirm the VM has .NET 8.0.3 installed. 
    · Share on Twitter
  • hassan_imamhassan_imam Posts: 51 Bronze 1
    Do you know which version you were on yesterday before updating to the most recent one? Version 4.6 is a major release. I’m attaching the link to the latest 4.5 version we have. Could you uninstall 4.6, install 4.5 instead, and let me know if the issue persists with that version? 

    Download SQLDataGenerator_4.5.21.5722.exe
    · Share on Twitter
Sign In or Register to comment.