Issue creating Service-Based SQL Database in Visual Studio 2022

Question

I am attempting to create an SQL Database in visual studio 2022:

I get the following error:

even though sql client has been added as a package reference:

Any thoughts? thanks

Answer 1

Hello @John Dyson ,

Please try to reinstall the Data storage and processing workload from VS Installer > Modify > Workloads.

Actually, there’s no need to install the separate NuGet package, but it’s strange that the error persisted after you installed the NuGet package. I guess there’s something wrong in settings or framework.

Try to install .NET 8.0 manually and see if this works(Download .NET 8.0).

Please also try to repair VS(VS Installer > More > Repair), create a new project and add the "Service-based Database" item again. If this still doesn't work, I would recommend trying to reinstall VS 2022.

Some other suggestions:

1. Delete the bin, obj and the hidden .vs folder in your solution/project folder. Rebuild your project and then try to add the "Service-based Database" item.
2. Tools > NuGet Package Manager > Package Manager Settings > click "Clear All NuGet Storage" button, try to reinstall the NuGet and add the item again.
3. Update VS 2022 and reset VS(run devenv /ResetSettings command in Developer Command Prompt for Visual Studio 2022).

Feel free to contact us and let us know the results:)

Sincerely,

Tianyu

---

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

I encountered the same issue, but after installing Tools, navigating to 'Get Tools and Features,' selecting 'Modify,' and then choosing 'Other Tool Sets' followed by 'Data Storage and Processing,' the problem was resolved."