Create File Encountered Operating System Error 5(Failed to Retrieve Text for This Error. Reason: 15105)

CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105)

I was able to solve the problem running MS SQL Management Studio as ADMINISTRATOR.

CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file

I got the solution Thank you @Oscar for the solution. This is the problem originated due to visual studio's default behavior of storing the all projects in C drive and folders. Best solution Store the project files in other drives other than the OS.

Temporary solution: just rightclick -> property -> security give write permission

update: its said that the problem arises with a bug in Sql server 2017 which is fixed in update

Cumulative Update 6 for SQL Server 2017.

@moderators plz mark this question as closed, thank you.

SQL server 2008 backup error - Operating system error 5(failed to retrieve text for this error. Reason: 15105)

It looks like the SQL Server doesn't have permission to access file C:\backup.bak. I would check the permissions of the account that is assigned to the SQL Server service account.

As part of the solution, you may want to save your backup files to somewhere other that the root of the C: drive. That might be one reason why you are having permission problems.

ERROR 5123 in MS SQL Server while attaching; i've tried many ways but i haven't get a solution yet

Finally I did my best and solved my problem by myself with these:

I used Microsoft SQL Server Express 2014 with LocalDB for my program instead of Enterprise edition that it had Security that I didn't need it for this type of project!.

I used Microsoft Visual Studio 2015 update 1 instead of Microsoft Visual Studio 2013 update 4; I installed it(VS 2015) FULL! but this took about 3 hours!

I put my database in my project folder; I simply attatched and deattatched it in Microsoft SQL Server Express 2014 Management Studio program.

I used Microsoft Windows 8.1 instead of Windows 10, it probably was useful!

Msg 5123, Level 16, State 1, Line 1 CREATE FILE encountered operating system error 5(Access is denied.)

You need to ensure that you have the appropriate account permissions on the account in order to access the folder the mdf file is located in.

More detail can be found in the following link.

https://dba.stackexchange.com/questions/22250/sql-server-create-file-encountered-operating-system-error-5-access-is-denied

Cannot install adventureworks 2012 database - Operating system error 5: Access is denied

The reason for the problem - Putting the database mdf and ldf files in a directory outside the "official" SQL server installation folder.

Solution -

http://tryingmicrosoft.com/error-while-attaching-a-database-to-sql-server-2008-r2/

Paste your .mdf file and ldf file in this directory -
C:\Program Files\Microsoft SQL Server\MSSQL11.SS2012\MSSQL\DATA

Solutions that did NOT solve the problem -

1 - Unblocking the zipped files. Also checked that mdf and ldf files are
not blocked. (Steps - right click zip file > properties > unblock)

2 - Run SSMS 2012 as administrator.

3 - Run SQL query of the form -

CREATE DATABASE MyAdventureWorks 
    ON (FILENAME = 'C:\MySQLServer\AdventureWorks_Data.mdf'), 
    (FILENAME = 'C:\MySQLServer\AdventureWorks_Log.ldf') 
    FOR ATTACH; 

Error while allocating space to the database

Entering NET HELPMSG 112 from a command prompt, the resultant message is "There is not enough space on the disk". It seems there isn't enough space on the E drive volume to extend the file to the specified size.

---

Related Topics