Not able to start SQL server browser in windows


Today, I was trying to Start my SQL server browser using SQL server configuration manager in windows 10, but I cannot see any option to start it as it is blurred and not clickable, so cannot start SQL server browser, here is the screenshot of my pc

How can I start it? Thanks

 


Asked by:- manish
0
: 6069 At:- 2/19/2019 3:16:51 PM
SQL SQL-server sql-server-browser







2 Answers
profileImage Answered by:- vikas_jk

You need to enable SQL Server Browser for your Windows

In Windows 10 : Go to Control Panel->Administrative Tools->Services, and look for the SQL Server Browser. Right-click, and select Properties From the Startup Type dropdown, change from Disabled to Automatic.

In Windows Server 2012 : Go to Control Panel > System and Security > Administrative Tools > Services, right-click SQL Server Browser > Properties > General tab, change Startup type to Automatic, click Apply button, then click Start button in Service Status area.

That's it, you are done.

2
At:- 3/3/2019 3:24:49 PM


profileImage Answered by:- bhanu

Also make sure, you run SQL Server Configuration Manager snap-in as Administrator if UAC is enabled.

Right-Click the "Service", then click properties, change the start mode to enabled, then start it.

OR

Follow these steps

Start -> Search "Run ", select "Run" -> enter "regedit" -> HKEY_LOCAL_MACHINE -> SOFTWARE -> WOW6432Node -> Microsoft -> Microsoft SQL Server -> 90 ( this can be changed based on your SQL Server version) -> SQL Browser -> Set SsrpListener=0

0
At:- 4/12/2021 3:20:08 PM






Login/Register to answer
Or
Register directly by posting answer/details

Full Name *

Email *




By posting your answer you agree on privacy policy & terms of use