blocks|key|2875532|text|我能够以管理员身份运行MS+SQL+Management+Studio来解决这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2875533|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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

blocks|key|3089470|text|这是一个Windows权限问题。如果使用Windows身份验证连接到服务器，则该Windows用户需要对该文件具有访问权限。如果使用SQL+server身份验证连接到服务器，则SQL+Server实例帐户(MSSQL$，例如MSSQL$SQLEXPRESS)需要该文件的权限。建议以管理员身份登录的其他解决方案基本上完成了相同的事情(使用了一些大锤:)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3089471|如果数据库文件位于SQL+Server的data文件夹中，则它应该已从该文件夹继承了SQL+Server帐户的用户权限，因此SQL+Server身份验证应该可以正常工作。我建议您修复SQL+Server实例对该文件夹的帐户权限。如果数据文件位于其他位置，而SQL+Server帐户没有权限，则以后可能会遇到其他问题。同样，更好的解决方案是修复SS帐户权限。除非您总是以管理员身份登录...|3089472|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

It's a Windows permissions issue. If you connected to your server using Windows Authentication then that Windows user needs permissions to the file. If you connected to your server using SQL Server authentication then the SQL Server instance account (MSSQL$, e.g. MSSQL$SQLEXPRESS) needs permissions to the file. The other solutions suggesting logging in as an administrator essentially accomplish the same thing (with a bit of a sledgehammer :).

If the database file is in your SQL Server's data folder then it should have inherited the user rights for the SQL Server account from that folder so the SQL Server authentication should have worked. I would recommend fixing the SQL Server instance's account's rights for that folder. If the data file is somewhere else and the SQL Server account does not have permissions then you will likely encounter other problems later. Again, the better solution is to fix the SS account rights. Unless you are always going to log in as administrator...

blocks|key|226040|text|右键单击文件mdf和ldf属性->安全->full权限|type|unstyled|depth|inlineStyleRanges|entityRanges|data|226041|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Right Click on File mdf and ldf properties -> security ->full permission

blocks|key|2875941|text|为我的数据库安装位置提供管理员权限或完全控制解决了我的问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2875942|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Giving admin rights or full control to my database install location solved my problem

blocks|key|225854|text|我也有同样的问题。经过几次尝试，我意识到将sql+server连接到windows身份验证解决了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|225855|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I had the same problem. After several tries, I realized that connecting the sql server with windows authentication resolved the issue.

blocks|key|225939|text|我也收到了类似的错误。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|225940|CREATE+FILE+encountered+operating+system+error+**32**(failed+to+retrieve+text+for+this+error.+Reason:+15105)+while+attempting+to+open+or+create+the+physical+file|code-block|syntax|javascript|225941|我使用以下命令附加数据库：|225942|EXEC+sp_attach_single_file_db+@dbname+=+'SPDB',
@physname+=+'D:\SPDB.mdf'|225943|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I was getting similar error.

<pre><code>CREATE FILE encountered operating system error **32**(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file
</code></pre>

I used the following command to attach the database:

<pre><code>EXEC sp_attach_single_file_db @dbname = 'SPDB',
@physname = 'D:\SPDB.mdf'
</code></pre>

blocks|key|224087|text|开始->运行->services.msc->scroll浏览服务列表，直到您找到SQL+Server->右键单击->属性->登录选项卡：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|224088|然后选择Local+System+Account并选中Allow+service+to+interact+with+desktop复选框。|224089|重新启动服务。|224090|​|224091|📷|atomic|224092|224093|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/3e6eec8aeb358d4cb6e09b1839384a8d.png|imageAlt^0|8|C|0|4|K|R|12|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|11|8|@$9|12|A|13|B|C]|$9|14|A|15|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|16|8|@]|D|@]|E|$]]|$1|J|3|K|5|6|7|17|8|@]|D|@]|E|$]]|$1|L|3|M|5|N|7|18|8|@]|D|@$9|19|A|1A|1|1B]]|E|$]]|$1|O|3|K|5|6|7|1C|8|@]|D|@]|E|$]]|$1|P|3|-4|5|6|7|1D|8|@]|D|@]|E|$]]]|Q|$R|$5|S|T|U|E|$V|W|X|-4]]]]

Start->Run-><code>services.msc</code>->scroll through the list of services until you find SQL Server->right-click->properties->Log On tab:

Then choose <code>Local System Account</code> and check the <code>Allow service to interact with desktop</code> checkbox.

Restart the service.

<a href="https://i.stack.imgur.com/KWqjW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KWqjW.png" alt="Services"></a>

blocks|key|3089433|text|当文件的所有者已被删除时，也会出现同样的问题。发生这种情况时，如果您转到文件的属性，您将看到SID而不是用户名。取得文件的所有权(给自己完全的控制权)。完成后，您可以对该文件执行所需的任何操作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3089434|当管理员没有做这个工作时，我已经做了这项工作。|3089435|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

This same problem occurs when the owners of the file have been deleted. When this happens, if you go to the file's properties, you will see a SID rather than a user name. Take ownership of the file (giving yourself FULL CONTROL). Once that is done you can do whatever you need to do with the file.

I've had this work when logging in as the administrator didn't do the trick.

blocks|key|220551|text|按照其他人的建议，以管理员身份运行将会有所帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|220552|但是，只有当windows用户实际上是sql+server运行的计算机上的认可用户时，才能执行此操作。|220553|例如，从远程计算机使用SSMS时，如果用户只是运行SSMS的计算机上的管理员，而不是运行SQL+Server的计算机上的管理员，则使用“以管理员身份运行”将无济于事。|220554|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

As other suggested running as administrator will help.

However this only if the windows user is actually an admisnitrator on the machine which sql server runs.

For example when using SSMS from a remote machine it will not help using "run as administartor" if the user is only a administrator on the machine runing SSMS but not on the machine running SQL Server.

blocks|key|225936|text|1.copy+your+--..MDF，--.LDF+files+to+pate此位置+2008+server+C:\Program+Files\Microsoft+2.在SQL+server+2008中使用ATTACH并选择相同位置添加|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|225937|entityMap^0|2|4|C|K|10|4|17|24|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|G|$]]

1.copy your --.MDF,--.LDF files to pate this location
For 2008 server
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA
2.In sql server 2008 use ATTACH and select same location for add

blocks|key|223888|text|我在装有SQL2005的Windows2003上遇到了这个问题。我必须将文件的所有权作为我的Windows用户帐户，并通过这种方式获得附加的数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|223889|您必须右键单击文件，选择属性，单击确定以跳过信息屏幕，单击高级按钮，从可用帐户或组列表中选择您的帐户，应用更改，然后在属性屏幕上单击确定。完成所有这些操作后，您将能够管理文件权限。|223890|我使用Windows身份验证登录SSMS，并且能够毫无错误地附加数据库。|223891|干杯!|223892|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

I had this issue on Windows 2003 with SQL 2005. I had to take ownership of the files as my Windows user account and I got the database to attache that way.

You have to right click on the file, select Properties, click OK to get past the information screen, click the Advanced button, select your account from the listing of available accounts or groups, apply that change, and Click OK on the Properties screen. Once you have done all that you will be able to manage the file permissions.

I logged into SSMS with Windows Authentication and I was able to attach the database without error.

Cheers!

blocks|key|3089503|text|如果您已经以管理员身份运行，请确保您使用的用户具有适当的服务器角色。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3089504|以sa身份登录(如果可以)|3089505|展开安全文件夹|unordered-list-item|3089506|
|3089507|展开Logins文件夹|3089508|3089509|右键单击要使用|3089510|
的用户|3089511|选择所有服务器角色|3089512|3089513|单击确定|3089514|3089515|重新启动SSMS|3089516|3089517|使用修改后的用户登录|3089518|3089519|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|14|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|15|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|16|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|17|8|@]|9|@]|A|$]]|$1|K|3|H|5|6|7|18|8|@]|9|@]|A|$]]|$1|L|3|M|5|F|7|19|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1A|8|@]|9|@]|A|$]]|$1|P|3|Q|5|F|7|1B|8|@]|9|@]|A|$]]|$1|R|3|H|5|6|7|1C|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|1D|8|@]|9|@]|A|$]]|$1|U|3|H|5|6|7|1E|8|@]|9|@]|A|$]]|$1|V|3|W|5|F|7|1F|8|@]|9|@]|A|$]]|$1|X|3|H|5|6|7|1G|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|F|7|1H|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|11|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]]|12|$]]

If you are already running as an adminstrator, make sure the user you are using has the proper server roles.

<ol>
<li>Login as sa (if you can)</li>
<li>Expand the Security folder</li>
<li>Expand the Logins Folder</li>
<li>Right click on the user you would like to use</li>
<li>Select Properties</li>
<li>Select Server Roles</li>
<li>Select all the server roles</li>
<li>Click OK</li>
<li>Restart SSMS</li>
<li>Login with the modified user</li>
</ol>

blocks|key|223752|text|在我的例子中，当我试图在一个新的驱动器上创建一个数据库时，我得到了这个错误。为了解决这个问题，我在该驱动器中创建了一个新文件夹，并将用户属性Security设置为对它的完全控制(设置Modify可能就足够了)。结论:将用户的驱动器/文件夹属性安全性设置为"Modify“。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|223753|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In my case I have got the error when trying to create a databae on a new drive.
To overcome the problem I created a new folder in that drive and set the user properties Security to full control on it(It may be sufficient to set Modify ).
Conclusion:
SET the Drive/Folder Properties Security for users to "Modify".

blocks|key|223799|text|我的解决方案稍微复杂一些。在验证了运行该服务的用户身份、以本地和域管理员身份运行MSSMS并检查了文件夹权限后，我仍然收到此错误。我的解决方案？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|223800|文件夹所有权仍由本地帐户维护。|223801|SQL属性>安全性>高级>所有者>(域/本地用户/组服务运行身份)|offset|length|style|BOLD|223802|这为我解决了这个问题。|223803|entityMap^0|0|0|Q|7|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@$F|Q|G|R|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

My solution was slightly more complicated. After verifying the user the service was running as, running MSSMS as local and domain administrator, and checking folder permissions, I was still getting this error. My solution? 

Folder ownership was still maintained by local account. 

Properties > Security > Advanced > Owner > (domain/local user/group SQL services are running as)

This resolved the issue for me.

blocks|key|2875875|text|复制--.MDF、--.LDF文件以将此位置粘贴到2008服务器C:\Program+Files\Microsoft+SQL+Server\MSSQL10.MSSQLSERVER\MSSQL\DATA+2的位置。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2875876|在sql+server+2008中，使用ATTACH并为add选择相同位置|2875877|entityMap^0|2|6|9|6|W|1Y|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Q|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|R|8|@]|D|@]|E|$]]]|I|$]]

copy your <code>--.MDF</code>,<code>--.LDF</code> files to pate this location For 2008 server <code>C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA 2</code>.

In sql server 2008 use ATTACH and select same location for add

blocks|key|3089861|text|以管理员身份打开SSMS并以SQL身份验证与Windows身份验证运行不起作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3089862|只需将我的文件名更改为LDF和MDF文件所在的位置即可。|3089863|alter+database+MyDB
add+file+(+name+=+N'FileStreamName',+
filename+=+N'D:\SQL+Databases\FileStreamSpace'+)+
to+filegroup+DocumentFiles;|code-block|syntax|javascript|3089864|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Opening SSMS as Administrator and running as SQL Auth vs Windows Auth did not work.

What worked was to just change my filename to the same location where the LDF and MDF files are located.

<pre><code>alter database MyDB
add file ( name = N'FileStreamName', 
filename = N'D:\SQL Databases\FileStreamSpace' ) 
to filegroup DocumentFiles;
</code></pre>

blocks|key|3089898|text|以下是步骤：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3089899|3089900|右键单击.mdf和.ldf文件。|ordered-list-item|3089901|，然后选择属性。|3089902|在security+->高级->权限中添加|3089903|的用户|3089904|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|O|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|Q|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

Here are the steps:

<ol>
<li>Right click on the .mdf and .ldf file.</li>
<li>Then select properties.</li>
<li>On the security -> advanced -> permission add the user which</li>
</ol>

blocks|key|2876026|text|在恢复备份到另一台服务器上的数据库时，我遇到了此错误。经过长时间的抗争，我终于做到了|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2876027|2876028|启用了即时文件初始化，|ordered-list-item|2876029|将文件夹的权限(完全控制)授予了服务帐户和我自己的windows帐户，|2876030|重新启动了SQL服务。数据库在此之后恢复。|2876031|2876032|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|N|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|P|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|Q|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|L|$]]

I got this error when restoring a database that was backed up on another server. After a long struggle this is what I did

<ol>
<li>Enabled Instant File Initialization,</li>
<li>Granted permissions (full control) on the folder to the service account and my own windows account,</li>
<li>Restarted the SQL service.
Database restored after that.</li>
</ol>

blocks|key|224019|text|关键是“操作系统错误5”。Microsoft在其网站上列出了各种错误代码和值|type|unstyled|depth|inlineStyleRanges|entityRanges|data|224020|https://msdn.microsoft.com/en-us/library/windows/desktop/ms681382(v=vs.85).aspx|offset|length|224021|ERROR_ACCESS_DENIED+5+(0x5)访问被拒绝。|224022|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|27|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@$D|Q|E|R|1|S]]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]]]

The key is "operating system error 5". Microsoft helpfully list the various error codes and values on their site

<a href="https://msdn.microsoft.com/en-us/library/windows/desktop/ms681382(v=vs.85).aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/windows/desktop/ms681382(v=vs.85).aspx</a>

ERROR_ACCESS_DENIED
5 (0x5)
Access is denied.

blocks|key|220741|text|我们遇到了这个问题，当windowsuser用户分离数据库和windowsuser用户附加数据库是不同的。当without用户分离数据库，试图附加它时，它工作得很好，没有问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|220742|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

We faced this issue, when the windowsuser detaching the database and windowsuser attaching the database are different. When the windowsuser detaching the database, tried to attach it, it worked fine without issues.

blocks|key|3090026|text|我只是决定在D:而不是C:中创建文件，一切都运行得很好。windows+7...10在文件和文件夹的共享和授权方面存在许多问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3090027|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I just decided to create the file in D: instead of C: and everything worked well. windows 7...10 have many issues regarding the sharing and authorization of files and folder..

blocks|key|220765|text|在我的例子中，以管理员身份运行没有帮助。我通过在Configuration+Manager中将Build-in帐户更改为Local+System解决了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|220766|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In my case, Run as Administrator does not help. I solved the problem by changing the Build-in Account to Local System in Configuration Manager.

blocks|key|2876160|text|这是在我的案例中发生的事情。我被要求附加一个数据库的文件。我得到的文件名如下|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2876161|2876162|devdb.mdf和devdb.ldf|unordered-list-item|2876163|2876164|我继续附加这些文件，并不断获取另一个进程正在使用的文件。|2876165|我对系统视图select名称physical_name+from+sys.master_files运行了一个查询，发现确切的文件名已被另一个数据库使用，因此每次我尝试附加这些文件时，都会得到错误消息:该文件正被另一个进程(Sql+server)使用。|2876166|因此，如果您收到这样的消息，那么还要查询系统视图sys.master_files，看看哪个数据库可能已经在使用相同名称的文件。以后你就会知道该怎么做了。|2876167|谢谢。|2876168|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|R|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|S|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|T|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|P|$]]

Here is what happened in my case.
I was asked to attach files for a database. I was given the file names as follows

<ul>
<li>devdb.mdf and devdb.ldf</li>
</ul>

I proceeded to attach the files and kept getting the files are in use by another process.

I ran a query against the system view select name, physical_name from sys.master_files; and saw that the exact file names were already in use by another database, thus each time I tried to attach the files, I kept getting the error the files are in use by another process(sql server)

Thus if you are getting such a message, then also query against the system view sys.master_files and see which database may already be using the same name files.
Hereafter you will figure out what to do.

thanks.

blocks|key|2876189|text|如果您有装入点，请相应地将SQL+server服务帐户添加到卷安全中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2876190|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

if you have mount points add the the SQL server service account to volume security accordingly

blocks|key|2875780|text|不需要做所有这些。只需右键单击数据库文件并向每个人添加权限即可。这肯定能行得通。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2875781|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

No need to do all this. Just right click on database files and add permission to everyone. That will work for sure.

I have a database file <code>.mdf</code> from MS SQL EXPRESS in folder:

<pre><code>C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA
</code></pre>

I would like to attach it to MS 2008 R2 (MSSQL10_50.MSSQLSERVER) but using Server Management Studio I receive the following error:

<code>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</code>

Do you have any idea how to solve it?

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

身份验证

SQL Server

数据库

服务器

Windows

我在文件夹中有一个来自MS SQL EXPRESS的数据库文件.mdf：C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA我想将其附加到MS 2008 R2 (MSSQL10_50.MSSQLSERVER)，但使用Server Management Studio时收到以下错误：CREATE FILE encount

问CREATE FILE遇到操作系统错误5(无法检索此错误的文本。原因: 15105)
EN

回答 25

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问CREATE FILE遇到操作系统错误5(无法检索此错误的文本。原因: 15105)EN

回答 25

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问CREATE FILE遇到操作系统错误5(无法检索此错误的文本。原因: 15105)
EN