我无法启动SQL Server浏览器

时间:2022-09-01 11:23:57

I can't start the SQL Server browser from SQL Service Configuration Manager 2008 version. There are absolutely no options to start the service. It's disabled as image shown below. How should I start the service again?

我无法从SQL服务配置管理器2008版本启动SQL Server浏览器。完全没有启动服务的选项。如下图所示,它被禁用。我该如何重新开始服务?

我无法启动SQL Server浏览器

7 个解决方案

#1


95  

If it is disabled, go to Control Panel->Administrative Tools->Services, and look for the SQL Server Agent. Right-click, and select Properties From the Startup Type dropdown, change from Disabled to Automatic.

如果禁用它,请转到Control Panel—>管理工具—>服务,并查找SQL Server代理。右键单击,并从启动类型下拉列表中选择Properties,将其从禁用状态更改为Automatic。

#2


13  

Make sure that you run the SQL Server Configuration Manager snap-in as Administrator if UAC is enabled. Then right click the service and then click properties, change the start mode to enabled, then start it.

如果启用UAC,请确保以管理员的身份运行SQL Server Configuration Manager snapin。然后右键单击服务,然后单击properties,将start模式更改为enabled,然后启动它。

#3


10  

Clicking Properties, going to the Service tab and setting Start Mode to Automatic fixed the problem for me. Now the Start item in the context menu is active again.

单击Properties,进入Service选项卡,设置Start模式自动修复问题。现在,上下文菜单中的Start项再次激活。

#4


9  

My approach was similar to @SoftwareFactor, but different, perhaps because I'm running a different OS, Windows Server 2012. These steps worked for me.

我的方法与@SoftwareFactor类似,但不同,可能是因为我运行的是一个不同的OS, Windows Server 2012。这些步骤对我起了作用。

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.

控制面板>系统和安全>管理工具>服务,右击SQL Server浏览器>属性> General选项卡,将启动类型改为自动,点击Apply按钮,然后点击服务状态区域的Start按钮。

#5


4  

go to Services, find SQL Server Browser, right click --> Properties --> General tab --> Startup Type --> select automatic . Then go back to configuration management, start it.

转到服务,找到SQL Server浏览器,右键单击——>属性——> General选项卡——>启动类型——>选择automatic。然后回到配置管理,启动它。

#6


1  

right click on SQL Server browser and properties, then Connection tab and chose open session with system account and not this account. then apply and chose automatic and finally run the server.

右键单击SQL Server浏览器和属性,然后单击Connection选项卡,选择open session with system account而不是this account。然后应用并选择自动并最终运行服务器。

#7


0  

run>regedit>HKey-Local-Machin>Software>wow6432nod>microsoft>microsoft sql server>90>sql browser>ssrplistener=0

运行>注册表编辑器> HKey-Local-Machin >软件> wow6432nod >微软sql浏览器> microsoft sql server > 90 > > ssrplistener = 0

#1


95  

If it is disabled, go to Control Panel->Administrative Tools->Services, and look for the SQL Server Agent. Right-click, and select Properties From the Startup Type dropdown, change from Disabled to Automatic.

如果禁用它,请转到Control Panel—>管理工具—>服务,并查找SQL Server代理。右键单击,并从启动类型下拉列表中选择Properties,将其从禁用状态更改为Automatic。

#2


13  

Make sure that you run the SQL Server Configuration Manager snap-in as Administrator if UAC is enabled. Then right click the service and then click properties, change the start mode to enabled, then start it.

如果启用UAC,请确保以管理员的身份运行SQL Server Configuration Manager snapin。然后右键单击服务,然后单击properties,将start模式更改为enabled,然后启动它。

#3


10  

Clicking Properties, going to the Service tab and setting Start Mode to Automatic fixed the problem for me. Now the Start item in the context menu is active again.

单击Properties,进入Service选项卡,设置Start模式自动修复问题。现在,上下文菜单中的Start项再次激活。

#4


9  

My approach was similar to @SoftwareFactor, but different, perhaps because I'm running a different OS, Windows Server 2012. These steps worked for me.

我的方法与@SoftwareFactor类似,但不同,可能是因为我运行的是一个不同的OS, Windows Server 2012。这些步骤对我起了作用。

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.

控制面板>系统和安全>管理工具>服务,右击SQL Server浏览器>属性> General选项卡,将启动类型改为自动,点击Apply按钮,然后点击服务状态区域的Start按钮。

#5


4  

go to Services, find SQL Server Browser, right click --> Properties --> General tab --> Startup Type --> select automatic . Then go back to configuration management, start it.

转到服务,找到SQL Server浏览器,右键单击——>属性——> General选项卡——>启动类型——>选择automatic。然后回到配置管理,启动它。

#6


1  

right click on SQL Server browser and properties, then Connection tab and chose open session with system account and not this account. then apply and chose automatic and finally run the server.

右键单击SQL Server浏览器和属性,然后单击Connection选项卡,选择open session with system account而不是this account。然后应用并选择自动并最终运行服务器。

#7


0  

run>regedit>HKey-Local-Machin>Software>wow6432nod>microsoft>microsoft sql server>90>sql browser>ssrplistener=0

运行>注册表编辑器> HKey-Local-Machin >软件> wow6432nod >微软sql浏览器> microsoft sql server > 90 > > ssrplistener = 0