November 6, 2013 at 4:19 am
HI All,
I changed startup parameter in my sql server.
While starting sql service i am getting below issue
2013-11-06 16:42:00.53 Server Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Oct 19 2012 13:38:57
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
2013-11-06 16:42:00.54 Server (c) Microsoft Corporation.
2013-11-06 16:42:00.54 Server All rights reserved.
2013-11-06 16:42:00.54 Server Server process ID is XXXX.
2013-11-06 16:42:00.54 Server System Manufacturer: 'XXXXX-XXXXX', System Model: 'HP Pro 3005 Microtower PC'.
2013-11-06 16:42:00.54 Server Authentication mode is MIXED.
2013-11-06 16:42:00.54 Server Logging SQL Server messages in file 'D:\DB\Data\ERRORLOG'.
2013-11-06 16:42:00.54 Server The service account is 'NT Service\MSSQLSERVER'. This is an informational message; no user action is required.
2013-11-06 16:42:00.54 Server Registry startup parameters:
-d D:\DB\Data\master.mdf
-e D:\DB\Data\ERRORLOG
-l D:\DB\Data\\mastlog.ldf
2013-11-06 16:42:00.54 Server Command Line Startup Parameters:
-s "MSSQLSERVER"
2013-11-06 16:42:01.17 Server SQL Server detected 1 sockets with 2 cores per socket and 2 logical processors per socket, 2 total logical processors; using 2 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2013-11-06 16:42:01.17 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2013-11-06 16:42:01.17 Server Detected 1791 MB of RAM. This is an informational message; no user action is required.
2013-11-06 16:42:01.17 Server Using conventional memory in the memory manager.
2013-11-06 16:42:01.24 Server This instance of SQL Server last reported using a process ID of 4180 at 11/6/2013 4:24:54 PM (local) 11/6/2013 10:54:54 AM (UTC). This is an informational message only; no user action is required.
2013-11-06 16:42:01.24 Server Node configuration: node 0: CPU mask: 0x0000000000000003:0 Active CPU mask: 0x0000000000000003:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2013-11-06 16:42:01.24 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2013-11-06 16:42:01.28 Server Software Usage Metrics is disabled.
2013-11-06 16:42:01.46 spid8s Starting up database 'master'.
2013-11-06 16:42:01.47 spid8s Error: 17204, Severity: 16, State: 1.
2013-11-06 16:42:01.47 spid8s FCB::Open failed: Could not open file D:\DB\Data\master.mdf for file number 1. OS error: 5(Access is denied.).
2013-11-06 16:42:01.58 spid8s Error: 5120, Severity: 16, State: 101.
2013-11-06 16:42:01.58 spid8s Unable to open the physical file "D:\DB\Data\master.mdf". Operating system error 5: "5(Access is denied.)".
2013-11-06 16:42:01.62 spid8s Error: 17204, Severity: 16, State: 1.
2013-11-06 16:42:01.62 spid8s FCB::Open failed: Could not open file D:\DB\Data\\mastlog.ldf for file number 2. OS error: 5(Access is denied.).
2013-11-06 16:42:01.62 spid8s Error: 5120, Severity: 16, State: 101.
2013-11-06 16:42:01.62 spid8s Unable to open the physical file "D:\DB\Data\\mastlog.ldf". Operating system error 5: "5(Access is denied.)".
November 6, 2013 at 4:29 am
Looks pretty clear
Could not open file D:\DB\Data\master.mdf for file number 1. OS error: 5(Access is denied.).
SQL doesn't have permission on the file, or probably the folder.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2013 at 4:35 am
GilaMonster (11/6/2013)
Looks pretty clearCould not open file D:\DB\Data\master.mdf for file number 1. OS error: 5(Access is denied.).
SQL doesn't have permission on the file, or probably the folder.
Thanks for your quick reply
It is local drive ..
How i can identify SQL having permission or not to that folder?
November 6, 2013 at 4:36 am
The error message tells you clearly that SQL doesn't have permission. You need to go to that folder and grant the SQL Server service account full rights to the folder and all files in it. Ask your sysadmin if you don't have permission to change folder security or don't know how to do it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2013 at 5:15 am
It is working fine.. thanks Gail Shaw
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply