关于sql server 2005 服务启动
来源:百度知道 编辑:UC知道 时间:2024/05/31 16:19:22
Windows 不能在本地启动SQL Server Active Directory Helper,错误代码为-1073741724
Windows 不能在本地计算机启动SQL Server VSS Writer.
错误代码-2147418113
请哪位高手帮帮忙。 我该怎么解决
SQL Browser service 启动不了
提示 ,无法启动服务,原因可能是已被禁用或与其相关的设备没有启动
连不上 SQL Express 我以前遇到过,简略描述的解决步骤如下:
1、“服务器网络配置”中打开 Np/TCP 协议,重启
2、启动 SQL Browser service
原文摘引如下:
This is the short version, the longer version is further down, also make sure and review the SQL Express BOL and the Mini BOL.
Follow these steps:
1. Make sure express is running correctly (assumes a default install)
Drop to a cmd prompt
Type the following
sqlcmd -S.\sqlexpress
You should get a prompt like this
1>
Type
Exit
to exit sqlcmd
2. Enable Protocols
a. Launch SQL Computer Manager
b. Expand "Server Network Configuration"
c. Expand Protocols for "SQLEXPRESS"
d. Enable Np (for local and remote access)
e. Enable TCP (for local and remote access)
3. Restart SQL Express
a. c