我的是企业版,我确定,我是装在服务器上的,win2003 另外我在服务器上发现这样的日志,好像是自己关掉了服务2010-09-05 01:02:11.96 备份 Database backed up. Database: Anyou, creation date(time): 2010/03/12(15:17:46), pages dumped: 347, first LSN: 173:482:37, last LSN: 173:498:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Anyou\Anyou_backup_201009050100.bak'}). This is an informational message only. No user action is required. 2010-09-05 05:30:16.12 spid51 Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install. 2010-09-05 05:30:16.12 spid51 Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install. 2010-09-05 05:30:16.13 spid51 Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install. 2010-09-05 05:30:18.65 spid53s Service Broker manager has shut down. 2010-09-05 05:30:19.12 spid7s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required. 2010-09-05 05:30:19.12 spid7s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required. 2010-09-05 05:30:19.13 服务器 The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.
一般情况下,启动SQL Server Engine后,SQL Server Agent也是会跟着启动的。 从你贴的ERRORLOG信息也是可以看出问题的:2010-09-05 05:30:19.12 spid7s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.很明显是在服务控制台上手工停止了。
创建失败看资料说是ssis没有装,但是我服务器上有这个服务了
很纠结
现在的问题是 SQL SERVER 2005 企业版不能安装在XP 系统上 你确认你是企业版
另外我在服务器上发现这样的日志,好像是自己关掉了服务2010-09-05 01:02:11.96 备份 Database backed up. Database: Anyou, creation date(time): 2010/03/12(15:17:46), pages dumped: 347, first LSN: 173:482:37, last LSN: 173:498:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Anyou\Anyou_backup_201009050100.bak'}). This is an informational message only. No user action is required.
2010-09-05 05:30:16.12 spid51 Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2010-09-05 05:30:16.12 spid51 Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
2010-09-05 05:30:16.13 spid51 Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.
2010-09-05 05:30:18.65 spid53s Service Broker manager has shut down.
2010-09-05 05:30:19.12 spid7s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
2010-09-05 05:30:19.12 spid7s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
2010-09-05 05:30:19.13 服务器 The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.
2010-09-04 10:37:00 - ? [100] Microsoft SQLServerAgent 版本 9.00.1399.06 (内部版本号 x86 unicode 零售): 进程 ID 7988
2010-09-04 10:37:00 - ? [101] SQL Server SVCTAG-5WJPT2X 版本 9.00.1399 (连接限制: 0)
2010-09-04 10:37:00 - ? [102] SQL Server ODBC 驱动程序版本 9.00.4035
2010-09-04 10:37:00 - ? [103] 驱动程序使用的 NetLib 是 DBNETLIB.DLL;本地主机服务器是
2010-09-04 10:37:00 - ? [310] 检测到 16 个处理器和 4096 MB RAM
2010-09-04 10:37:00 - ? [339] 本地计算机是 SVCTAG-5WJPT2X,运行的是 Windows NT 5.2 (3790) Service Pack 2
2010-09-04 10:37:00 - ? [432] 子系统缓存中有 11 个子系统
2010-09-04 10:37:04 - ! [364] 尚未启动 Messenger 服务 - 将不发送 NetSend 通知
2010-09-04 10:37:04 - ? [129] SQLSERVERAGENT 在 Windows NT 服务控制下启动
2010-09-04 10:37:04 - + [260] 无法启动邮件会话(原因: 没有定义邮件配置文件)
2010-09-04 10:37:04 - + [396] 尚未定义空闲 CPU 条件 - OnIdle 作业计划将不起任何作用
2010-09-05 01:00:30 - ! [298] SQLServer 错误: 258,共享内存提供程序: 超时错误 [258]. [SQLSTATE 08001]
2010-09-05 01:00:30 - ! [165] ODBC 错误: 0,登录超时已过期 [SQLSTATE HYT00]
2010-09-05 01:00:30 - ! [298] SQLServer 错误: 258,由于预登录响应中的延迟,无法完成登录过程 [SQLSTATE 08001]
2010-09-05 01:00:30 - ! [382] 无法登录到服务器“(local)”(ConUpdateRunRequestedJobActivity)
2010-09-05 05:30:00 - ? [131] 由于用户、进程或操作系统的停止请求,SQLSERVERAGENT 服务正在停止...
2010-09-05 05:30:16 - ? [098] SQLServerAgent 已终止(一般)
估计问题能解决了
是我同事做了一个计划任务,只是重新启动了下sqlserver,
没有启动代理服务可能
明天见答案不过这个数据库里还是有问题的我感觉,好多地方报错
哎,太乱了,竟然服务器也不用杀毒软件的
只用360安全卫士,360杀毒不用,基本上都是用Mcafee。
一般情况下,启动SQL Server Engine后,SQL Server Agent也是会跟着启动的。
从你贴的ERRORLOG信息也是可以看出问题的:2010-09-05 05:30:19.12 spid7s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.很明显是在服务控制台上手工停止了。