August 23, 2015 at 2:37 pm
I just installed 2014 SqlExpress on a Win 10 machine & ssms sees the local server & will connect.
When I browse for network servers - there are 2 on the network - ssms does NOT find any. In fact, I do not see the "retrieving data" message at all when I click the Network Servers tab.
Sqlserver Browser service is running plus I have restarted it a couple of times.
Ques: Will ssms 2014 connect to 2012 express? (the 2 network servers are 2012 express).
ssms on either of the 2 network servers will connect to each other AND to the new 2014 instance.
All firewalls are turned OFF.
Any help or guidance will be much appreciated, TIA, Joe
August 24, 2015 at 5:28 am
Yes, SSMS 2014 will connect to 2012 Express.
Have you tried connecting with the servers' IP-addresses?
August 24, 2015 at 6:41 am
I had not tried the IP address, but I did now try & ssms did connect to both of the 2012 servers.
I can ping both the remote servers by their machine name so what is wrong?
August 24, 2015 at 1:13 pm
According to MSDN, the server may not be visible if the HideInstance flag is set.
https://msdn.microsoft.com/en-us/library/ms188200(v=sql.110).aspx
https://msdn.microsoft.com/en-us/library/ms179327(v=sql.110).aspx
August 24, 2015 at 6:15 pm
I did check the HideInstance flag on both network 2012 servers - neither is hidden. But, I already knew that because each of the remote servers can see each other and the 2014 server.
I have a c# application that uses SmoApplication.EnumAvailableSqlServers which does NOT run on the Win10 machine.
I believe SqlServer browsing is broken on the Win10 machine - either a Win10 configuration issue or a bug.
August 25, 2015 at 7:25 am
I believe SqlServer browsing is broken on the Win10 machine - either a Win10 configuration issue or a bug.
MS doesn't ship software with bugs, so that's out. 😛
August 27, 2015 at 3:05 am
Is the SQL Browser service started on the 2012 networked instances? Having it started on your Win10 box will not help you find the networked instances.
Joie Andrew
"Since 1982"
August 28, 2015 at 7:10 pm
Yes, SQL browser service is running on both of the 2012 machines and on the 2014 machine.
Ssms on either of the 2012 machines will browse and find all 3 of the Sql Server machines.
I appreciate all the help because I have no idea where to look any more. I have been over & over all the configurations and cannot find anything to fix the problem.
Until I can get this fixed, the 2014 machine is completely useless as a server because in addition to ssms not working, I have several c# apps that require SmoApplication.EnumAvailableSqlServers which also does NOT work - most probably for the same reason
August 29, 2015 at 9:34 am
Does anyone have a Win10 Pro machine running Sql Server 2014 Express - AND does ssms browse for network servers?
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply