I have in numerous places told that the first tool that I often open when the computer boots up will be SQL Server Management Studio. I get intrigued whenever someone comes up with an error relating to SSMS. There is something that gets my troubleshooting character out and I get out full swing to solve the same. Don’t you ever like such challenges? I am for sure you like similar challenges. One of my clients reported below problem with Network Servers List in SQL Server Management Studio.
I have a strange problem with my management studio. When I open Microsoft SQL Server 2014 Management Studio, chose “Connect to Server” dialog, go to Server name dropdown, select <Browse for more…>, Network Servers tab, there are no entries.
My first question was, is this happening with other clients also? This was to confirm if there are some real network issues or server issues or it is just the client.
The client confirmed that this is ONLY with few clients. After a lot of searching, I was able to find this KB (Add Connection dialog box doesn’t load server names in the drop-down list after you apply the .NET Framework 4.6 that talks about this issue.
They have upgraded their .NET to 4.6.1 and the issue was resolved. These are simple issues that one can easily get into. Have you ever encountered these errors in your environments? Let me know via comments.
Reference: Pinal Dave (https://blog.sqlauthority.com)
have .net framework 4.7.2 installed windows 10. Same issue as you are describing. Have you run across this anywhere else with any other solutions?
Never faced it.
Yes, I have seen it in my last environment, in sql server 2008 r2.
Unable to execute sqlcmd -L command , .Net version is 4.7
I have the Problem, that one SQL Server is not shown in the dropdown menu from other servers. But single Instanzes can be connected without a probelm.
Only when I search with Network Servers List, only this server is not there.