关于sql server 2005 服务启动

来源:百度知道 编辑:UC知道 时间:2024/05/31 16:19:22
刚安装的sqlserver ,登陆不能勇sqlserver 管理员进行连接, 然后我近 服务 发现 sql服务未启动, 可是我启动 发现如下错误,
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