CODEWITHSUNDEEP
sql-servervisual-studiovisual-studio-2010sql-server-2008
Stan
Stan

Reputation: 26501

SQL Server is not showing in Visual Studio

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

Upvotes: 39

Views: 57093

Answers (12)

hayatSikandar
hayatSikandar

Reputation: 31

if sqlserver is installed with new installation try the following:

(localdb)\mssqllocaldb

Upvotes: 1

Jack
Jack

Reputation: 165

Check the server name while connecting through Microsoft SQL Server.

enter image description here

enter image description here

Upvotes: 0

Mayur Jadhav
Mayur Jadhav

Reputation: 11

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

Upvotes: 1

Mohammad Nabeel
Mohammad Nabeel

Reputation: 3

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

Upvotes: 0

InfernumDeus
InfernumDeus

Reputation: 1202

I just found out how to figure out the name of local database.

  1. Open View -> SQL Server Object Explorer.

  2. In explorer select SQL Server and you will see you local server.

  3. Select it and press F2 to select it's name.

  4. Now you can copy or change the name of your local database.

  5. Enter this name in add connection form.

Worked just fine for me. Name of my database happened to be "(localdb)\MSSQLLocalDB".

Neither of other solutions worked for me. And I think this one should help in most cases.

Upvotes: 8

varatharajan k
varatharajan k

Reputation: 1

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.

Upvotes: 0

Psy
Psy

Reputation: 184

I just had the same problem, I solved it by typing "." (without quotes) in the server name.

screenshot

Upvotes: 14

Matheus Miranda
Matheus Miranda

Reputation: 1805

I had the same problem, I solved problem uninstalling VMware. And working right.

Upvotes: 0

Gal Fridman
Gal Fridman

Reputation: 760

Had the same problem, after searching google for 2 hours while finding nothing, and the server name still wasn't there after refreshing for 100 times!

(server not working image)

Then, I tried 1 more thing:

Ignoring the fact that my server doesn't apear on the list.

I just wrote the server nae "(local)\SQLEXPRESS" and went to the connection name which now was enabled! (I didn't realized that before!)

if you were fools like me, this might be the answer!

(server working image)

Upvotes: 13

Bob
Bob

Reputation: 93

Mine stopped working after the last Win10 update (12 Jan 2016). I updated everything trying to get it going. I do think though that the SQL update was a necessary part of the sollution below, because that option in the Server Explorer had completely gone.

But after the update, the solution ends up a simple one as said here. In your VStudio's 'Server Explorer' right click on 'Data Connections' and select "Create new sql database'.

Use the string mentioned above '(local)\SQLEXPRESS' and give the database a name.

From then on it is all as you are used to. I must admit the near two days spent trying to get it working again had me in a panic, there is hardly any software I write these days that doesn't have a database component to it, and I could not edit any of the applications I had already written. Though those already published continued to work normally.

I do suspect that some MS Update has knocked out a registry setting that VStudio uses and over the coming months when a developer goes in to edit a database he/she will get a nasty surprise.

Upvotes: -2

Crezzer7
Crezzer7

Reputation: 2335

I had the exact same issue as Stan, and for me I had to connect using the IP of the SQL Server Database, followed by the name:

10.0.1.224\DatabaseName

  • your ip can be found by using cmd and pinging the device where SQL Server is installe. (in my case the server was hosted on a virtual machine)

Upvotes: 6

vcsjones
vcsjones

Reputation: 141588

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.

Upvotes: 60

Related Questions