CODEWITHSUNDEEP
sql-serverdatabaselistnetwork-programming
PillowMetal
PillowMetal

Reputation: 785

SQL Server 2014 Express Network Servers Tab Empty

When connecting to a database engine in SSMS, and using the "browse for more" option, the Network Servers tab list is empty.

I can type the server name manually in the Server Name field in the "Connect to Server" dialog window and connect just fine, but I can't browse for the list of available servers which is obviously more convenient.

The SQL Browser service is running on all the network servers that I want to connect to, which I verified by running "osql -L" from the command line. This in fact gives me the complete list of servers I should see in the network server tab of SSMS but don't.

Running the SQL Browser service on my local machine does not help, as of course that is just allowing my machine to broadcast its available services.

Any idea of what would be causing this?

Upvotes: 0

Views: 2359

Answers (2)

Iasmini Gomes
Iasmini Gomes

Reputation: 805

This solution worked for me:

  1. Go to Connect Object Explorer:

enter image description here

  1. Fill in the Server name, Login and Password fields and click on Options: enter image description here

  2. Go to Connection Properties tab, click on Connection database, Browse server... enter image description here

  3. Click on Yes: enter image description here

  4. It will show the databases.

Upvotes: 0

Vojta Novák
Vojta Novák

Reputation: 58

I had the same problem. It seems like a bug in .NET Framework 4.6.

  • Uninstall Microsoft .NET Framework 4.6 (and all relevant component).
    • Visual Studio and Management Studio has been broken
  • I repaired Microsoft Visual Studio Premium 2013 with Update 3.
    • Control Panel --> Programs and functions --> MS VS P 2013 w U 3 --> Change --> Repair
  • Restart computer.

Everything is fine and Network Servers Tab works.

Upvotes: 1

Related Questions