MS SQL Server Concepts and Programming Question:
Download Questions PDF

How To Start SQL Server Browser Service?

Answer:

SQL Server Browser Service is installed as part of the SQL Server. But it is turned off by default to reduce the security risk. If you want start SQL Server Browser Service to allow the SQL Server to accept network connections, you need to follow the steps below:

1. Go to Control Panel > Administrative Tools.

2. Double click on "Services". The Services window shows up.

3. Double click on "SQL Server Browser". The properties dialog box shows up.

4. Change the "Startup Type" from Disabled to Automatic. Then click the Start button.

The "SQL Server Browser" service should be running now.

Download MS SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
What Are the Requirements on SQL Server Network Connections?How To Enable TCP/IP Protocol on a SQL Server?