How to: Start SQL Browser Service

When using a named database instance for Microsoft Dynamics NAV, and the SQL Server is not on the same computer as Microsoft Dynamics NAV Server, then the SQL Server Browser Service must be running on the SQL Server. If it is not, Microsoft Dynamics NAV Server cannot connect to the Microsoft Dynamics NAV database and an error occurs when you try to open a RoleTailored client. A database instanced named NAVDEMO is used when you install the CRONUS International Ltd. demonstration database by using Microsoft Dynamics NAV 2016 Setup.

You enable and start the SQL Server Browser Service by using the SQL Server Configuration Manager that is installed with Microsoft SQL Server 2008.

To start SQL Server Browser Service

1. On the computer running SQL Server, run the SQL Server Configuration Manager.

   On the Start menu, in the Search Programs and Files box, type SQL, and then choose SQL Server Configuration Manager.

2. In SQL Server Configuration Manager, in the navigation pane on the left, choose SQL Server Services.

3. Right-click SQL Server Browser, and then choose Properties.

4. On the Service tab of the SQL Server Browser dialog box, set the Start mode to Automatic.

5. Choose OK to return to the SQL Server Configuration Manager main page.

6. Right-click SQL Server Browser again, and then choose Start.

See Also

Concepts

Installation Considerations for Microsoft SQL Server
Configuring Microsoft Dynamics NAV Server
Troubleshooting: SQL Server Connection Problems