Menu
I just installed SQL Server Express on my PC and for some reason it is not showing in my list of available servers to connect on Visual Studio 2010. I added some pictures to explain exactly my problem. I have no idea how to fix this because it is up and running, but not showing up...
869
To connect to your SQL Server database in Visual Studio start a new project and bring up Server Explorer either by clicking on the tab next to the Toolbox or by going to View > Server Explorer. Right click on 'Data Connections' then click 'Add Connection'.
Visual Studio 2022 installs an old version of SQL Server Local DB (2016) but should be 2019. THis makes it difficult to develop and test code compatible with 2019 but not 2016.
Nope, you have to buy them separately, but you can work with SQL Express in the meantime.
If the SQL Server Browser service isn't running, it won't find it (which you have disabled). You should still be able to connect to it even though it isn't "discoverable". Try connecting with (local)\SQLEXPRESS.
57
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
