blocks|key|299795|text|运行sql+server的帐户无权访问备份文件所在的位置或尝试将数据库还原到的位置。可以使用SQL+Server配置管理器查找用于运行SQL+Server实例的帐户，然后确保该帐户对.BAK文件和要还原到的文件夹具有完全控制权限。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|299796|​|299797|📷|atomic|299798|299799|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/0accedff6f24814b26ff3e0b1285660b.png|imageAlt^0|1A|F|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|X|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|Y|8|@]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|K|3|G|5|6|7|12|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|13|8|@]|D|@]|E|$]]]|M|$N|$5|O|P|Q|E|$R|S|T|-4]]]]

The account that sql server is running under does not have access to the location where you have the backup file or are trying to restore the database to. You can use SQL Server Configuration Manager to find which account is used to run the SQL Server instance, and then make sure that account has full control over the .BAK file and the folder where the MDF will be restored to.

<img src="https://i.stack.imgur.com/rA58U.png" alt="enter image description here">

blocks|key|3242096|text|我只是遇到了同样的问题，但有一个不同的解决方案。基本上，我的计算机上同时安装了SQL+Server和SQL+Server+Express。当我尝试还原到SQL+Express时，这将不起作用，但当我将其还原到SQL+Server时，它可以正常工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3242097|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 ran into this same problem but had a different fix. Essentially I had both SQL Server and SQL Server Express installed on my computer. This wouldn't work when I attempted to restore to SQL Express, but worked correctly when I restored it to SQL Server.

blocks|key|302650|text|我找到了这个，它对我很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|302651|CREATE+LOGIN+BackupRestoreAdmin+WITH+PASSWORD='$tr0ngP@$$w0rd'
GO
CREATE+USER+BackupRestoreAdmin+FOR+LOGIN+BackupRestoreAdmin
GO
EXEC+sp_addsrvrolemember+'BackupRestoreAdmin',+'dbcreator'
GO
EXEC+sp_addrolemember+'db_owner','BackupRestoreAdmin'
GO|code-block|syntax|javascript|302652|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I found this, and it worked for me:

<pre><code>CREATE LOGIN BackupRestoreAdmin WITH PASSWORD='$tr0ngP@$$w0rd'
GO
CREATE USER BackupRestoreAdmin FOR LOGIN BackupRestoreAdmin
GO
EXEC sp_addsrvrolemember 'BackupRestoreAdmin', 'dbcreator'
GO
EXEC sp_addrolemember 'db_owner','BackupRestoreAdmin'
GO
</code></pre>

blocks|key|3027780|text|我最近遇到了这个问题。我的修复方法是转到Restore+Database对话框的Files页面，然后选中"Relocate+all+files+to+folder“。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3027781|​|3027782|📷|atomic|offset|length|3027783|3027784|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/986106d256d0b41b77a256358a8a2fa4.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@$G|V|H|W|1|X]]|A|$]]|$1|I|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

I recently had this problem. The fix for me was to go to the Files page of the Restore Database dialog and check "Relocate all files to folder".

<img src="https://i.stack.imgur.com/llPjc.png" alt="Restore Database dialog">

blocks|key|302662|text|在我的例子中，我必须在Overwrite+the+existing+database+(WITH+REPLACE)页面上的Options选项卡下选中这个复选框。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|302663|我得到这个错误的原因:因为数据库已经存在一个MDF文件，并且它没有被覆盖。|302664|希望这能帮助到一些人。|302665|entityMap^0|B|1A|1P|7|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@$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|I|5|6|7|R|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|K|$]]

In my case I had to check the box in <code>Overwrite the existing database (WITH REPLACE)</code> under <code>Options</code> tab on <code>Restore Database</code> page.

The reason I was getting this error: because there was already an MDF file present for the database and it was not getting overwritten.

Hope this will help someone.

blocks|key|302667|text|如果要附加数据库，请查看"Databases+to+attach“网格，特别是在指定.mdf文件之后的Owner列中。请记下该帐户，并为其提供对mdf和ldf文件的完全权限。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|302668|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're attaching a database, take a look at the "Databases to attach" grid, and specifically in the Owner column after you've specified your .mdf file. Note the account and give Full Permissions to it for both mdf and ldf files.

blocks|key|299844|text|我尝试了上面的场景，得到了相同的错误5(访问被拒绝)。我深入研究了一下，发现文件.bak应该有权访问SQL服务帐户。如果不确定，请在Start+->+Run中键入services.msc，然后检查SQL+Service登录帐户。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|299845|然后转到该文件，右键单击并选择Properties中的Security选项卡，然后选择edit以添加新用户。|299846|最后，授予它完全的权限，以便提供完全的访问权限。|299847|然后从SSMS尝试恢复备份。|299848|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 tried the above scenario and got the same error 5 (access denied). I did a deep dive and found that the file .bak should have access to the SQL service account. If you are not sure, type services.msc in Start -> Run then check for SQL Service logon account.

Then go to the file, right-click and select Security tab in Properties, then edit to add the new user.

Finally then give full permission to it in order to give full access.

Then from SSMS try to restore the backup.

blocks|key|297492|text|在尝试恢复SQL2012数据库中的SQL2008+R2备份数据库时，我遇到了相同的错误。我猜这个错误是由于没有足够的权限将.mdf和.ldf文件放入C盘。我尝试了一件简单的事情，然后我成功地恢复了它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|297493|试试这个：|297494|在Restore+DB向导窗口中，转到Files选项卡，将restore+destination从C:更改为其他驱动器。然后继续执行常规还原过程。它一定会成功恢复的！|297495|希望这对你也有帮助。干杯:)|297496|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 was getting the same error while trying to restore SQL 2008 R2 backup db in SQL 2012 DB. I guess the error is due to insufficient permissions to place .mdf and .ldf files in C drive. I tried one simple thing then I succeeded in restoring it successfully.

Try this:

In the Restore DB wizard windows, go to Files tab, change the restore destination from C: to some other drive. Then proceed with the regular restore process. It will definitely get restores successfully!

Hope this helps you too. Cheers :)

blocks|key|302711|text|嗯，在我的例子中，解决方案非常简单和直接。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|302712|我只需要更改log+On+As值的值。|offset|length|style|BOLD|CODE|302713|要解决的步骤-|302714|在Properties上打开Sql+Server+Configuration+manager|302715|Right+click+on+SQL+Server+(MSSQLSERVER**)**|unordered-list-item|302716|
|302717|Go的|302718|ordered-list-item|302719|302720|302721|​|302722|📷|atomic|302723|302724|将log+On+As值更改为LocalSystem的|302725|302726|302727|302728|302729|302730|希望这也能对你有所帮助:)|302731|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/9edfee67e0a92b730dde4b7fb12ef13a.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/c5466a5035d07a17eb1e405acaa3a2eb.png^0|0|6|9|6|9|0|4|3|0|1|A|E|W|1|A|E|W|0|6|Y|6|W|0|0|0|0|0|0|0|0|1|0|0|0|1|9|E|B|1|9|E|B|0|0|0|0|0|1|1|0|0|0|D|0^^$0|@$1|2|3|4|5|6|7|1N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1O|8|@$D|1P|E|1Q|F|G]|$D|1R|E|1S|F|H]]|9|@]|A|$]]|$1|I|3|J|5|6|7|1T|8|@$D|1U|E|1V|F|G]]|9|@]|A|$]]|$1|K|3|L|5|6|7|1W|8|@$D|1X|E|1Y|F|G]|$D|1Z|E|20|F|G]|$D|21|E|22|F|H]|$D|23|E|24|F|H]]|9|@]|A|$]]|$1|M|3|N|5|O|7|25|8|@$D|26|E|27|F|G]|$D|28|E|29|F|H]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|2A|8|@]|9|@]|A|$]]|$1|R|3|S|5|O|7|2B|8|@]|9|@]|A|$]]|$1|T|3|-4|5|U|7|2C|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|2D|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|2E|8|@]|9|@]|A|$]]|$1|X|3|Y|5|6|7|2F|8|@]|9|@]|A|$]]|$1|Z|3|10|5|11|7|2G|8|@]|9|@$D|2H|E|2I|1|2J]]|A|$]]|$1|12|3|Y|5|6|7|2K|8|@]|9|@]|A|$]]|$1|13|3|14|5|6|7|2L|8|@$D|2M|E|2N|F|G]|$D|2O|E|2P|F|G]|$D|2Q|E|2R|F|H]|$D|2S|E|2T|F|H]]|9|@]|A|$]]|$1|15|3|-4|5|U|7|2U|8|@]|9|@]|A|$]]|$1|16|3|-4|5|6|7|2V|8|@]|9|@]|A|$]]|$1|17|3|Y|5|6|7|2W|8|@]|9|@]|A|$]]|$1|18|3|10|5|11|7|2X|8|@]|9|@$D|2Y|E|2Z|1|30]]|A|$]]|$1|19|3|Y|5|6|7|31|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|6|7|32|8|@$D|33|E|34|F|G]]|9|@]|A|$]]|$1|1C|3|-4|5|6|7|35|8|@]|9|@]|A|$]]]|1D|$1E|$5|1F|1G|1H|A|$1I|1J|1K|-4]]|1L|$5|1F|1G|1H|A|$1I|1M|1K|-4]]]]

Well, In my case the solution was quite simple and straight. 

I had to change just the value of <code>log On As</code> value.

Steps to Resolve- 

<ol>
<li>Open <code>Sql Server Configuration manager</code></li>
<li>Right <code>click on SQL Server (MSSQLSERVER</code>)</li>
<li>Go to <code>Properties</code></li>
</ol>

<a href="https://i.stack.imgur.com/y53oV.png" rel="noreferrer"><img src="https://i.stack.imgur.com/y53oV.png" alt="enter image description here"></a>

<ol start="4">
<li>change <code>log On As</code> value to <code>LocalSystem</code></li>
</ol>

<a href="https://i.stack.imgur.com/C0Lbq.png" rel="noreferrer"><img src="https://i.stack.imgur.com/C0Lbq.png" alt="enter image description here"></a>

Hoping this will help you too :)

blocks|key|300470|text|我有完全相同的问题，但我的解决方案是不同的-我的公司正在加密我机器上的所有文件。解密文件后，MSSQL在访问并创建数据库时没有任何问题。只需右键单击.bak+file+->+Properties+->+Advanced...+->+Encrypt+contents以保护数据。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|300471|📷|atomic|300472|​|300473|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/4695d6c978b80a1e684f5ff4d2ecf54c.png|imageAlt^0|22|9|2F|A|2T|B|38|M|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@$9|U|A|V|B|C]|$9|W|A|X|B|C]|$9|Y|A|Z|B|C]|$9|10|A|11|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|12|8|@]|D|@$9|13|A|14|1|15]]|E|$]]|$1|I|3|J|5|6|7|16|8|@]|D|@]|E|$]]|$1|K|3|-4|5|6|7|17|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R|S|-4]]]]

I had exactly same problem but my fix was different - my company is encrypting all the files on my machines. After decrypting the file MSSQL did not have any issues to accessing and created the DB. Just right click .bak file -> Properties -> Advanced... -> Encrypt contents to secure data.
<a href="https://i.stack.imgur.com/TZaUo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TZaUo.png" alt="Decrypting"></a>

blocks|key|3027926|text|这在今天早些时候发生在我身上，我是本地服务器管理员组的成员，可以畅通无阻地访问，或者我认为是这样。我还勾选了"replace“选项，即使实例中没有这样的DB。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3027927|发现那里曾经有同名的DB，MDF和LDF文件在物理上仍然位于服务器的data和log文件夹中，但在sys.databases中缺少实际的元数据。SQL+server的服务帐户也无法写入现有文件。我还发现文件的所有者是“未知的”，我不得不将所有权更改为上面的两个文件，以便它现在归本地服务器的admin组所有，然后重命名。|3027928|最后，它成功了。|3027929|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|$]]

this happened to me earlier today, i was a member of the local server's admin group and have unimpeded access, or i thought so. I also ticked the "replace" option, even though there is no such DB in the instance.

Found out that there used to be DB of the same name there, and the MDF and LDF files are still physically located at the data and log folders of the server, but the actual metadata is missing in the sys.databases. the service account of SQL server also can't ovewrwrite the existing files. Found out also that the files' owner is "unknown", i had to change ownership, to the 2 files above so that it is now owned by the local server's admin group, then renamed it.

Then finally, it worked.

blocks|key|302759|text|这个错误有几个原因，我得到这个错误是因为我在还原数据库窗口的文件选项卡中选中了“重新分配所有文件到文件夹”，但是默认路径在我的本地计算机上不存在。我将ldf/mdf文件放在另一个文件夹中，一旦我更改了它，我就可以恢复它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|302760|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|$]]

There are several causes for this error, I got this error because I checked &quot;Reallocate all files to folder&quot; in the Files tab of Restore Database window but the default path did not exist on my local machine. I had the ldf/mdf files in another folder, once I changed that I was able to restore.

blocks|key|3242325|text|该帐户无权访问备份文件的位置。要通过计算机管理器轻松访问SQL+Server配置管理器，请执行以下步骤|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3242326|3242327|单击Windows键%2B+R打开运行窗口。|ordered-list-item|offset|length|style|BOLD|3242328|在打开:框中键入compmgmt.msc。单击<|3242329|>E114服务和SQL+Server+Configuration+SQL+Server用户帐户。在<代码>E122选项卡中，以<代码>E223的身份登录。<代码>H224<代码>G225|3242330|现在您可以轻松地恢复数据库|3242331|entityMap^0|0|0|2|B|0|8|C|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|S|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|T|8|@$F|U|G|V|H|I]]|9|@]|A|$]]|$1|J|3|K|5|E|7|W|8|@$F|X|G|Y|H|I]]|9|@]|A|$]]|$1|L|3|M|5|6|7|Z|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|10|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|Q|$]]

The account does not have access to the location for backup file. 
Take the following steps to access the SQL Server Configuration Manager via Computer Manager easily

<ol>
<li>Click the Windows key + R to open the Run window.</li>
<li>Type compmgmt.msc in the Open: box.</li>
<li>Click OK.</li>
<li>Expand Services and Applications.</li>
<li>Expand SQL Server Configuration Manager.</li>
<li>Change User Account in Log On As tab .</li>
</ol>

Now you can Restore Data Base easily

blocks|key|299927|text|一个不错的解决方案是转到文件>并选中重新分配所有文件|type|unstyled|depth|inlineStyleRanges|entityRanges|data|299928|​|299929|📷|atomic|offset|length|299930|299931|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/a5799324d031c67f22ea4a845f2fcb14.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@$G|V|H|W|1|X]]|A|$]]|$1|I|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

A good solution that can work is go to files > and check the reallocate all files 

<img src="https://i.stack.imgur.com/2yp41.png" alt="Files relocate">

blocks|key|302778|text|对我来说，修复方法是在尝试恢复数据库时进入选项，并将路径更改为新路径。Here+is+the+screenshot|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|302779|entityMap|0|LINK|mutability|MUTABLE|url|https://i.stack.imgur.com/BQSWn.png^0|Z|M|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

The fix for me was to go into Options when trying to Restore the database and change the path to the new path.
<a href="https://i.stack.imgur.com/BQSWn.png" rel="nofollow noreferrer">Here is the screenshot</a>

I want to restore a database from a file (Tasks → Restore → Database; after I select from device and select file) via SQL Server Management Studio. 

After that, I get this error:

<blockquote>
 The operating system returned the error '5(Access is denied.)' while attempting
 'RestoreContainer::ValidateTargetForCreation' on 'E:\Program Files\Microsoft SQL
 Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\XXXXXX.mdf'.
 Msg 3156, Level 16, State 8, Server XXXX, Line 2
</blockquote>

How do I fix this problem? Is it a security error?

mssql '5 (Access is denied.)' error during restoring database

备份数据库

SQL Server

数据库

服务器

Windows

我想通过SQL Server Management Studio从文件(任务和还原→数据库；在我选择从设备并选择文件之后)还原数据库。在那之后，我得到了这个错误：操作系统返回错误‘5(访问被拒绝。)’尝试在“E：\Program Files\Microsoft Server\MSSQL10.MSSQLSERVER\MS...

问mssql '5 (访问被拒绝。)‘还原数据库时出错
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mssql '5 (访问被拒绝。)‘还原数据库时出错EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mssql '5 (访问被拒绝。)‘还原数据库时出错
EN