SQL Server is not showing in Visual Studio

user_440611 0
Viewed 45399

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...

enter image description here

enter image description here

enter image description here

visual-studio-2010 visual-studio sql-server-2008 sql-server
12 Answers

I faced the same problem, My Visual studio doesn't show any of the SQL server in the network including the local SQL server. I tried all the options mentioned above. Finally I tried by disabling Windows Firewall and Defender option in Windows 10. Then I can See all the SQL server including the Local SQL server. This worked for me.

user_69258750

Just Start the SQL Server Browser service it will fix the issue.

user_109481660

You can follow following steps:

1.Open "services.mvc"

You can see here

2.After that search for the "SQL Server Browser".

You can see here

  1. Rigth click on it the you may see the option of Properties click o it.After that you can see "StartUp Type" which is disable by default to connect select it to "Automatic" or "Manual".

You can see here

  1. After selecting to "Automatic" click on the start button to start the SQL Server Browser.

You can see here

5.After following above steps you can see that the "SQL Server Browser" is currently running.

You can see here

user_120997510

Check the server name while connecting through Microsoft SQL Server.

enter image description here

enter image description here

user_51176710

if sqlserver is installed with new installation try the following:

(localdb)\mssqllocaldb
user_21236580
Related