[Solved-3 Solutions] CREATE FILE Encountered Operating System Error 5 (Access is denied)

Error Description:

  • CREATE FILE encountered operating system error 5(failed to retrieve text for this error.) while attempting to open or create the physical file.

Solution 1:

  • It might be possible that the file path that you mention in FILENAME could be wrong.

Solution 2:

  • Right-click on the file which is mentioned in the error message and go to properties.
  • In the Properties dialog box, go to Security tab.
  • In the Select Group or user names box (which has sysadmin in above image). Click the Edit button and enter the name you used to login to SQL Server. If its windows account, then use that account else use service account.
  • Click Check Names and verify that the name you are specifying does exist as SQL Server login.
  • Click OK.
  • In the Group or User Names box, select the user name you selected in the above step and give full control permission to the user. Click OK.

Solution 3:

  • The service account might have been changed or something about the NTFS permissions might have been changed.
  • A resolution path (also based on comment string) is to confirm that the service that is running SQL Server has R/W permissions on the path that you're specifying. To do this:
  • Start->Run->services.msc->scroll through the list of services until you find SQL Server->right-click-properties->Log On tab
  • Now go and ensure that account has the appropriate permission on that directory to do what it needs to do.

Related Searches to CREATE FILE Encountered Operating System Error 5 (Access is denied)

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add wikitechy.com to your ad blocking whitelist or disable your adblocking software.