Stay “ Select the user 、 Computer 、 Service account or group ” In the dialog box, single click “ Location ”, Select your computer name at the top of the location list, And then click “ determine ”. Stay “ Security ” On the tab, single click “ edit ”, And then click “ add to ”. Right click the file system folder, And then click “ attribute ”. Use Windows Explorer, Navigate to the file system location where the database files are stored. For details, please refer to MSDN file, The interception section is as follows To the current directory Virtual accounts NT Service\MSSQLSERVER And grant relevant authority to solve this problem. We from E The root directory of the disk, Right click the attribute and select Security Delete this user, Then when I create a new database, I come across CREATE FILE encountered operating system error 5(Access is denied.) error. Now let's delete the user GETTESTNT55\Users This account, In the catalog E:\SQL_DATA Properties of （Properties）-> Security （Security）-> edit （Edit） If you delete it directly, you will encounter the following error. At this point we create the database Test No problem at all. 8Īs shown below ,SQL Server Database Services The starting account number of the service is NT Service\MSSQLSERVER, Let's set the default path of the database as E:\SQL_DATAĪt this point to see E:\SQL_DATA Directory permissions （ Blocked is a domain account ）. Operating system version : Windows Server 2012 SP2ĭatabase version ：Microsoft SQL Server 2014.
#Createfile error 32 when trying set file time how to
This blog post mainly demonstrates ”CREATE FILE encountered operating system error 5(Access is denied.)“ Causes of errors such as （ Of course, it's just a scenario that leads to this error ） And how to solve this problem and some puzzles.
0 kommentar(er)
