I have tried to connect to a SQL Server database using the following steps:
-> Tools -> "Connect To Database"
"Add connection" gave me the server name to use:
Test connection succeeds:
But after clicking on "OK", this error pops up:
Unable to connect to SQL Server database in my ASP.NET Core project
Viewed 273
2 Answers
The steps you've described for connecting to the database are for the Server Explorer in the IDE -- the error dialog and message clearly indicate this. This is not related to an ASP.NET Core project. These steps can be performed w/o any solutions/projects opened in the IDE.
It's likely an issue with your installation. Try a "modify/repair" install, or a even a clean install. If the issue persists, open a ticket with the Visual Studio team. To open a ticket, from inside the IDE, at the top right corner, click the icon for sending feedback (next to the "Live Share" icon) and follow the prompts.
Please note that not being able to create a database connection in Server Explorer will NOT prevent you from coding an ASP.NET Core app that connects to that database.
So, I've solved my above error by [temporary workaround] replacing the "Microsoft.VisualStudio.Data.Providers.SqlServer" assembly with the older version of visual studio 2019, this assembly is present in "C:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE". you'll find the above assembly in the original answer(go to this below link).
Taken from : https://developercommunity.visualstudio.com/t/Could-not-find-any-resources-appropriate/1505966#T-N1506125
Related