How to solve this Sql server Issue [Resolved]

Posted by Jayakumars under Sql Server on 2/17/2017 | Points: 10 | Views : 1793 | Status : [Member] [MVP] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

hi

In my Pc Sql server last day working good. now i start in my sql server service

i meet this issue . how to fix this?

this is my issue.

Windows could not start the SQL Server (MSSQLSERVER) on Local Computer.
For more information, review the System Event Log. If this is a non-Microsoft service,
contact the service vendor, and refer to service-specific error code 5.

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Rajnilari2015 on: 2/19/2017 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

0	@Jayakumars Sir, error code 5 indicates that there is some permission issue over the .mdf and .ldf files and so Access is denied The SQL Server database engine service account must have permissions to read/write for the .mdf and .ldf files in which they are located. So solve this, Provide Full control permission for both .mdf and .ldf files for Users group. More information a) https://dbamohsin.wordpress.com/2009/06/03/attaching-database-unable-to-open-physical-file-access-is-denied/ b)http://stackoverflow.com/questions/19060441/cannot-install-adventureworks-2012-database-operating-system-error-5-access-i/19061137#19061137 Hope that helps. -- Thanks & Regards, RNA Team Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

@Jayakumars Sir,

error code 5 indicates that there is some permission issue over the .mdf and .ldf files and so Access is denied

The SQL Server database engine service account must have permissions to read/write for the .mdf and .ldf files in which they are located.

So solve this, Provide Full control permission for both .mdf and .ldf files for Users group.

More information

a) https://dbamohsin.wordpress.com/2009/06/03/attaching-database-unable-to-open-physical-file-access-is-denied/

b)http://stackoverflow.com/questions/19060441/cannot-install-adventureworks-2012-database-operating-system-error-5-access-i/19061137#19061137

Hope that helps.

--
Thanks & Regards,
RNA Team

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts