October 18, 2012

CREATE FILE encountered operating system error 5


Problem:
- CREATE FILE encountered operating system error 5(Access is denied.)
- CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file 'PATH\FILE.mdf'.
- CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'PATH\FILE.mdf'.

Solution:
- Go to Control Panel > Administrative Tools > Services
- Right click on SQL SERVER (BLAH BLAH) and select the Properties
- Stop service
- Go to Log On tab and change the Log on as: to Local System Account
- Apply and Start service again ans enjoy ;-)

8 comments:

Anonymous said...

Thank you for sharing. Not to many people in your position are so gracious. Your article was very poignant and understandable. It helped me to understand very clearly. Thank you for your help.

Anonymous said...

Awesome post, where is the rss? I cant find it!

Anonymous said...

Thats good, your blog is cool, i like it. Thanks for the efforts my friend.

Hayden Poole said...

I have been having access issues while attaching the database. But the problem got solved when I ran SSMS as an admin. This helped.

Anonymous said...

Thanks, this solve my problem.

Anonymous said...

Thanks.

Anonymous said...

Awesome Post!!!!!

Anonymous said...

Oh man, save my time thank you very much.