SQL Server 2014 Express on Windows 10

SQL Server 2014 Management Studio on Windows 10 browse for network servers does not list any servers.

Browser and Server are running.

Opened ports 1433 and 1434 through firewall.

SQL Server 2012 Management Studio on Windows 8.1 can browse for network servers and lists server on Windows 10.

Any suggestions?

August 27th, 2015 5:55pm

Make sure in SQL server network configuration protocols section tcp/ip is enabled. 

And also check the firewall.

here is some more information.

-----------------------------------------------

If you are connecting to a SQL Server component and you do not know the exact name of the SQL Server instance, clickBrowse for more in the Server name box to open the Browse for Servers dialog box.

This dialog is populated by the SQL Server Browser service on the server computers. There are several reasons why the name of an instance might not appear in the list:

  • The SQL Server Browser service might not be running on the computer running SQL Server.

  • UDP port 1434 might be blocked by a firewall.

  • The HideInstance flag might be set.

To connect to an instance that does not appear in the list, type a full connection string for the instance, including the TCP/IP port number or the named pipes pipe name.

Options

Select a SQL Server instance in the network for your connection

Designate the server you want to connect to by clicking on the SQL Server instance displayed in the tree. You can show or hide portions of the tree view by clicking on the nodes marked with a + or  symbol.

Free Windows Admin Tool Kit Click here and download it now
August 27th, 2015 6:37pm

Server Settings

There are three significant aspects that users may neglect, which lead to the failure of the connection to the SQL Server.

Enable TCP/IP Connection

To check whether your server enabled to TCP/IP connections:

  1. Open your SQL Server Configuration Manager.

    Open SQL Server Configuration Manager

    Open SQL Server Configuration Manager

  2. Expand SQL Server Network Configuration and select Protocols for SQLEXPRESS.

    Select Network Configuration

    Select Network Configuration

  3. Take a look at TCP/IP, which requires to be Enabled. If yours is Disabled, right-click on it and select Enable in the popup menu.

    Enable TCP/IP Connection for SQL Server

    Enable TCP/IP Connection for SQL Server

  4. Also, you may take a look at the Port setting of your server. Right-click on TCP/IP and select Properties in the popup menu.

    Open TCP/IP Properties

    Open TCP/IP Properties

  5. Click the IP Address tab in the TCP/IP Properties dialog box.

    Switch to IP Address tab

    Switch to IP Address tab

  6. Under IPAll section, you can see the TCP Port (default: 1433) and you can edit the port of your server.

    Configure default port for SQL Server

    Configure default port for SQL Server

  7. You will need to restart server after changing any setting in SQL Server Configuration Manager. You can right click on the server instance and select Restart from popup menu.

    Restart SQL Server

    Restart SQL Server

Allow Remote Connection

Your need to make sure that remote connection to your SQL Server is enabled. To verify this setting:

  1. Startup your SQL Server Management Studio.

    Launch SQL Server Management Studio

    Launch SQL Server Management Studio

  2. Right-click on the server and select Properties in the popup menu.

    Open Server Properties

    Open Server Properties

  3. In the Server Properties dialog box, select Connections.

    Select Connections

    Select Connections

  4. Check the checkbox of Allow remote connections to this server.

    Turn on Allow remote connections to this server

    Turn on Allow remote connections to this server

Authentication Method

We recommend users to run their SQL Server with mixed authentication mode. To inspect the authentication mode of your SQL Server:

  1. Open SQL Server Management Studio. Then, right-click on the server and select Properties in the popup menu.
  2. In the Server Properties dialog box, select Security.

    Select Security setting

    Select Security setting

  3. Make sure Server Authentication is set to SQL Server and Windows Authentication Method.

    Select SQL Server and Windows Authentication mode

    Select SQL Server and Windows Authentication mode


August 27th, 2015 10:15pm

This is what the browse for servers looks like on Windows 8.1.

The Database Engine can be expanded and it shows all SQL Server Engine on our network.

On Windows 10 however the area is blank. No Database Engine. This is what I am trying to resolve.

The suggestions given thus far have not resolved this issue.


Connect to Server
  • Edited by MRoy 15 hours 42 minutes ago Missing image
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2015 11:28am

You are able to browse for network serves using 2012 SSMS and not 2014 SSMS on same machine.

  • If so what is the service pack of 2014 on that Win 10 machine ?
  • Please run and see the output for osql -L or sqlcmd -L in the command prompt(Just to make sure about the listing)
August 31st, 2015 1:35pm

I've the same problem. A Win 8.1 machine with Sql 2014 Express running and accessible from network. After the update to Win10 all still working but no connection from LAN. I've verified all: protocol, firewall (exe and port 1433), binding (SuperSocketNetLib), ecc. The "telnet pcName 1433" working (telnet show the black screen as result of successful connection to pc:port) ... but Management Studio, and software, cannot connect to it! THE SOLUTION (verified now) =====> **DISABLE** WINDOWS FIREWALL FOR PRIVATE NETWORKS! And retry to connect to it. This worked for me. Please mark this as answer if worked for you. Thanks. Have nice day. Davide.
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2015 6:19pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics