开发者

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

SQL Server is not showing in Visual Studio

SQL Server is not showing in Visual Studio

开发者_如何学JAVA

SQL Server is not showing in Visual Studio


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.


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)


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

SQL Server is not showing in Visual Studio


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.


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)


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


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.


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


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


Check the server name while connecting through Microsoft SQL Server.

SQL Server is not showing in Visual Studio

SQL Server is not showing in Visual Studio


if sqlserver is installed with new installation try the following:

(localdb)\mssqllocaldb


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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜