本文章介绍了关于SQL2005附加数据库出错(错误号:5123) 的方法,有需要了解的同学可参考一下下。
错误提示】
无法为此请求检索数据。(Microsoft.SqlServer.SmoEnum)其他信息执行Transact-Sql语句或批处理时发生了异常。(Microsoft.SqlServer.ConnectionInfo)尝试打开或创建物理文件“d:Data***.mdf”时,Create file遇到操作系统错误5(拒绝访问。)
【问题背景】
版本:SQL Server 2005企业版
操作系统版本:Windows Server 2003企业版
错误引发描述:数据库分离后,把数据硬盘从一台主机换挂到另一台主机上(两台主机的操作系统和数据库版本都是一样的)。结果附加数据库时,提示上面的错误。
【问题分析】
很明显,是文件操作权限不够引发的问题。
【解决方法】
给数据库文件所在的文件夹属性安全里添加相应的用户并赋予完全操作权限即可解决问题(网上的资料都是这么说的)。给什么用户添加权限呢?比如:Administrators用户组、NETWORK SERVICE、MSSQLUser或Everyone,具体用哪个,看你的SQL服务是哪个帐户启动的,如果不清楚或者懒一点,可以直接添加Everyone用户。本来想上个截图的,不知道为什么,几十Kb的图片,一直上传不成功。
【意外情况】
可能你通过上面的解决方法,给数据文件所在的文件夹添加了相应的用户和操作权限,但问题依旧(这也正是我纠结痛苦的地方,网上都是那么说的,咋就不行哩~~??!)。最后我的解决方法是:给每个数据库文件(包括mdf、ldf、ndf)分别设置用户和操作权限(操作方法和给文件夹加操作权限一样,都是在右键属性里的安全选项)。问题终于彻底得到解决。原因应该是文件夹的权限没有自动继承到里面的文件上。

This article addresses MySQL's "unable to open shared library" error. The issue stems from MySQL's inability to locate necessary shared libraries (.so/.dll files). Solutions involve verifying library installation via the system's package m

This article explores optimizing MySQL memory usage in Docker. It discusses monitoring techniques (Docker stats, Performance Schema, external tools) and configuration strategies. These include Docker memory limits, swapping, and cgroups, alongside

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

This article compares installing MySQL on Linux directly versus using Podman containers, with/without phpMyAdmin. It details installation steps for each method, emphasizing Podman's advantages in isolation, portability, and reproducibility, but also

This article provides a comprehensive overview of SQLite, a self-contained, serverless relational database. It details SQLite's advantages (simplicity, portability, ease of use) and disadvantages (concurrency limitations, scalability challenges). C

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

This guide demonstrates installing and managing multiple MySQL versions on macOS using Homebrew. It emphasizes using Homebrew to isolate installations, preventing conflicts. The article details installation, starting/stopping services, and best pra

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

SublimeText3 Linux new version
SublimeText3 Linux latest version

Notepad++7.3.1
Easy-to-use and free code editor
