积极答复者
双机装sql server2008,其中一台服务启动不了

问题
-
2012-07-09 18:24:28.08 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Evaluation Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)2012-07-09 18:24:28.08 Server (c) Microsoft Corporation.
2012-07-09 18:24:28.08 Server All rights reserved.
2012-07-09 18:24:28.08 Server Server process ID is 3672.
2012-07-09 18:24:28.08 Server System Manufacturer: 'Dell Inc.', System Model: 'PowerEdge M610'.
2012-07-09 18:24:28.08 Server Authentication mode is MIXED.
2012-07-09 18:24:28.08 Server Logging SQL Server messages in file 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
2012-07-09 18:24:28.08 Server This instance of SQL Server last reported using a process ID of 2408 at 2012/7/9 18:23:48 (local) 2012/7/9 10:23:48 (UTC). This is an informational message only; no user action is required.
2012-07-09 18:24:28.09 Server Registry startup parameters:
-d E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
-e E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
2012-07-09 18:24:28.09 Server Error: 17113, Severity: 16, State: 1.
2012-07-09 18:24:28.09 Server Error 5(拒绝访问。) occurred while opening file 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.
答案
-
你好,
请问你使用的是那些客户端协议?是非开启了VIA 协议, 如果是的话,请关闭该协议再试着连接。
Thanks.
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
- 已标记为答案 Molly Chen_Moderator 2012年7月23日 6:52
-
根据错误提示,确认一下 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf' 这个文件是否存在,你的 sql 服务的启动用户,是否有权限对它进行读写操作
- 已标记为答案 Molly Chen_Moderator 2012年7月23日 6:52
全部回复
-
你好,
请问你使用的是那些客户端协议?是非开启了VIA 协议, 如果是的话,请关闭该协议再试着连接。
Thanks.
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
- 已标记为答案 Molly Chen_Moderator 2012年7月23日 6:52
-
根据错误提示,确认一下 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf' 这个文件是否存在,你的 sql 服务的启动用户,是否有权限对它进行读写操作
- 已标记为答案 Molly Chen_Moderator 2012年7月23日 6:52