服务器:消息 17,级别16,状态1,SQL Server 不存在或访问被拒绝。服务里没有SQL server启动项
答案:4 悬赏:40 手机版
解决时间 2021-03-26 12:29
- 提问者网友:我没有何以琛的痴心不悔
- 2021-03-25 15:33
服务器:消息 17,级别16,状态1,SQL Server 不存在或访问被拒绝。服务里没有SQL server启动项
最佳答案
- 五星知识达人网友:舊物识亽
- 2021-03-25 15:55
操作系统的服务要是创建不成功,你可以通过命令的方式启动SQLSERVER,操作方法如下:
运行命令:C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe,运行后系统会有这样的提示:
2011-07-26 22:39:30.89 server initeventlog: Could not initiate the EventLog Service for the key 'MSSQLSERVER'.
2011-07-26 22:39:31.07 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
2011-07-26 22:39:31.09 server Copyright (C) 1988-2000 Microsoft Corporation.
2011-07-26 22:39:31.10 server All rights reserved.
2011-07-26 22:39:31.10 server Server Process ID is 4064.
2011-07-26 22:39:31.10 server Logging SQL Server messages in file 'd:\database\mssql\log\ERRORLOG'.
2011-07-26 22:39:31.17 server SQL Server is starting at priority class 'normal'(4 CPUs detected).
2011-07-26 22:39:31.92 server SQL Server configured for thread mode processing.
2011-07-26 22:39:31.92 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2011-07-26 22:39:32.00 spid4 Starting up database 'master'.
2011-07-26 22:39:32.34 server Using 'SSNETLIB.DLL' version '8.0.194'.
2011-07-26 22:39:32.34 spid5 Starting up database 'model'.
2011-07-26 22:39:32.35 spid4 Server name is 'LIUYX-X201'.
2011-07-26 22:39:32.35 spid4 Skipping startup of clean database id 4
2011-07-26 22:39:32.37 spid4 Skipping startup of clean database id 5
2011-07-26 22:39:32.37 spid4 Skipping startup of clean database id 6
2011-07-26 22:39:32.39 spid4 Skipping startup of clean database id 7
2011-07-26 22:39:32.46 spid5 Clearing tempdb database.
2011-07-26 22:39:32.51 server SQL server listening on Shared Memory, Named Pipes.
2011-07-26 22:39:32.53 server SQL Server is ready for client connections
2011-07-26 22:39:32.95 spid5 Starting up database 'tempdb'.
2011-07-26 22:39:33.04 spid4 Recovery complete.
2011-07-26 22:41:08.50 spid52 Starting up database 'dbBOM'.
2011-07-26 22:41:08.81 spid52 Starting up database 'msdb'.
2011-07-26 22:41:08.90 spid52 Starting up database 'Northwind'.
2011-07-26 22:41:08.99 spid52 Starting up database 'pubs'.
SQL Server is ready for client connections 假如这个关键字能出现,说明你的数据库安装没有问题,但是创建服务出了问题,这些服务器你可以通过注册表进行导入。追问关键字果然没有出现,那请问XP要安装数据库怎么装?追答看看你的版本是不是个人版,xp只能安装这种版本。要安装企业版你要安装一个windows2003的操作系统。
运行命令:C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe,运行后系统会有这样的提示:
2011-07-26 22:39:30.89 server initeventlog: Could not initiate the EventLog Service for the key 'MSSQLSERVER'.
2011-07-26 22:39:31.07 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
2011-07-26 22:39:31.09 server Copyright (C) 1988-2000 Microsoft Corporation.
2011-07-26 22:39:31.10 server All rights reserved.
2011-07-26 22:39:31.10 server Server Process ID is 4064.
2011-07-26 22:39:31.10 server Logging SQL Server messages in file 'd:\database\mssql\log\ERRORLOG'.
2011-07-26 22:39:31.17 server SQL Server is starting at priority class 'normal'(4 CPUs detected).
2011-07-26 22:39:31.92 server SQL Server configured for thread mode processing.
2011-07-26 22:39:31.92 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2011-07-26 22:39:32.00 spid4 Starting up database 'master'.
2011-07-26 22:39:32.34 server Using 'SSNETLIB.DLL' version '8.0.194'.
2011-07-26 22:39:32.34 spid5 Starting up database 'model'.
2011-07-26 22:39:32.35 spid4 Server name is 'LIUYX-X201'.
2011-07-26 22:39:32.35 spid4 Skipping startup of clean database id 4
2011-07-26 22:39:32.37 spid4 Skipping startup of clean database id 5
2011-07-26 22:39:32.37 spid4 Skipping startup of clean database id 6
2011-07-26 22:39:32.39 spid4 Skipping startup of clean database id 7
2011-07-26 22:39:32.46 spid5 Clearing tempdb database.
2011-07-26 22:39:32.51 server SQL server listening on Shared Memory, Named Pipes.
2011-07-26 22:39:32.53 server SQL Server is ready for client connections
2011-07-26 22:39:32.95 spid5 Starting up database 'tempdb'.
2011-07-26 22:39:33.04 spid4 Recovery complete.
2011-07-26 22:41:08.50 spid52 Starting up database 'dbBOM'.
2011-07-26 22:41:08.81 spid52 Starting up database 'msdb'.
2011-07-26 22:41:08.90 spid52 Starting up database 'Northwind'.
2011-07-26 22:41:08.99 spid52 Starting up database 'pubs'.
SQL Server is ready for client connections 假如这个关键字能出现,说明你的数据库安装没有问题,但是创建服务出了问题,这些服务器你可以通过注册表进行导入。追问关键字果然没有出现,那请问XP要安装数据库怎么装?追答看看你的版本是不是个人版,xp只能安装这种版本。要安装企业版你要安装一个windows2003的操作系统。
全部回答
- 1楼网友:走死在岁月里
- 2021-03-25 18:23
http://blog.csdn.net/feixianxxx/article/details/5523922
跟着做吧
跟着做吧
- 2楼网友:玩家
- 2021-03-25 17:21
xp能安装数据库服务器?那要看什么版本啦追问我查看了SQL2000的安装教程,果然没有找到XP!XP莫非不能安装数据库服务器?求办法,求帮助
- 3楼网友:不如潦草
- 2021-03-25 16:22
你安装的是SQLSERVER2000 的什么版本?
xp支持的个人版,其他版本不行。
另外,服务找MSSQL
xp支持的个人版,其他版本不行。
另外,服务找MSSQL
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯