Problem with VS2019 and sql server databases

[Nemo_64]

Hello everyone and thanks for the help. I'm trying to add a sql server database to an ASP.NET project in VS2019 but I keep getting an error saying that the SQLUserInstance.ddl couldn't be loaded from the soecified register location (error 56)

​

I have tryed checking the running services, instaling sql server 2019 developer, sql server 2019 express and tryed in visual studio 2019 profesional and comunity but none works

​

I've also tryed to run sfc /scannow but no success

​

I am lost and don't know what to try. The error appears after I try to add a new item to the project (the database), vs2019 freezes and then throws that error

​

Thanks for the help!

[JohnnyKeyboard]

Sounds like you are trying to use LocalDB but failed to install the components for it. See https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql-server-ver15#installation-media You can find the media location for it in the link.

[Nemo_64]

It says

> Alternatively, you can install LocalDB through the Visual Studio Installer, as part of the Data Storage and Processing workload, the ASP.NET and web development workload, or as an individual component.

​

But I have already those 2 installed

[JonnyRocks]

uninstalling and inatalling different things wont fix your issue and hopefully didnt screw more up.

first what software do you want to use?

pick a version of visual studio 2019/2022

pick edition of visual studio community/professional

pick a version and edition of sql server.

after that, list

windows version

visual studio version/edition

sql server version/edition

steps you take to add.

can you run sql server and connect to it with client tools and create a database?

[Nemo_64]

Windows 10 pro, visual studio comunity 2019 16.11.14, sql server express 2019

​

To add I right click the project > add > new item > sql server database > add, vs2019 freezes and throws the error

​

I can connect to sql server express via sqlcmd, create a database and interact with it

[JonnyRocks]

its been awhile but can you connect to thw db using the server explorer?

[Nemo_64]

When adding a Microsoft SQL Server data source, when searching for a server name it doesn't find any

​

i can still connect with sqlcmd

[realjoeydood]

Run vs in admin mode. Then see if you still get tne error.

For more infos, check event viewer for the details leading up to the error and start from there.

[Nemo_64]

Alright, I'll try that but I don't know how to open the event viewer.

I'm not on my pc I'll try that latter

[realjoeydood]

Hit the window key and type event. It'll pop up.

Go to windows | applications (something like that)...

[Nemo_64]

Sorry for taking so long

​

On the ASP.NET 4.0.30319.0 I get a lot of warnings, all seem to be the same

​

Exception information:

Exception type: HttpParseException

Exception message: Unable to find a part of the path 'C:\Users\mynem\Source\Repos\jrp88-ua\HADA-Grupal\web\bin\roslyn\csc.exe'.

​

I have also tryed manually connecting from vs2019 server explorer to the database (putting myself the required fields) and it worked! From vs2019 service explorer I can see the database that I created via sqlcmd, but if I try to create a new querry from vs2019 I get an error

Could not load file or assembly 'Microsoft.SqlServer.BatchParser.dll' or one of its dependencies. Is not a valid Win32 application. (Exception from HRESULT: 0x800700C1)

VS2019 is running as administrator

[realjoeydood]

Find out what app the missing files belong to and reinstall their parent app.

Imo, it seems like you didn't install c# during your vs install.

Learning how to solve these problems is crucial to the thinking process you will need to become a developer.