How to solve this Sql server Issue [Resolved]

Posted by Jayakumars under Sql Server on 2/17/2017 | Points: 10 | Views : 334 | Status : [Member] [MVP] | Replies : 1
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


Responses

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

Up
0
Down

Resolved
@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

Login to post response