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的图片，一直上传不成功。
【意外情况】
可能你通过上面的解决方法，给数据文件所在的文件夹添加了相应的用户和操作权限，但问题依旧（这也正是我纠结痛苦的地方，网上都是那么说的，咋就不行哩~~？？！）。最后我的解决方法是：。问题终于彻底得到解决。原因应该是文件夹的权限没有自动继承到里面的文件上。
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
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1382
52
Use java's File.length() function to get the size of the file
Jul 24, 2023 am 08:36 AM
Use Java's File.length() function to get the size of a file. File size is a very common requirement when dealing with file operations. Java provides a very convenient way to get the size of a file, that is, using the length() method of the File class. . This article will introduce how to use this method to get the size of a file and give corresponding code examples. First, we need to create a File object to represent the file we want to get the size of. Here is how to create a File object: Filef
Hongmeng native application random poetry
Feb 19, 2024 pm 01:36 PM
To learn more about open source, please visit: 51CTO Hongmeng Developer Community https://ost.51cto.com Running environment DAYU200:4.0.10.16SDK: 4.0.10.15IDE: 4.0.600 1. To create an application, click File- >newFile->CreateProgect. Select template: [OpenHarmony] EmptyAbility: Fill in the project name, shici, application package name com.nut.shici, and application storage location XXX (no Chinese, special characters, or spaces). CompileSDK10, Model: Stage. Device
How to convert php blob to file
Mar 16, 2023 am 10:47 AM
How to convert php blob to file: 1. Create a php sample file; 2. Through "function blobToFile(blob) {return new File([blob], 'screenshot.png', { type: 'image/jpeg' })} ” method can be used to convert Blob to File.
Rename files using java's File.renameTo() function
Jul 25, 2023 pm 03:45 PM
Use Java's File.renameTo() function to rename files. In Java programming, we often need to rename files. Java provides the File class to handle file operations, and its renameTo() function can easily rename files. This article will introduce how to use Java's File.renameTo() function to rename files and provide corresponding code examples. The File.renameTo() function is a method of the File class.
Use java's File.getParent() function to get the parent path of the file
Jul 24, 2023 pm 01:40 PM
Use java's File.getParent() function to get the parent path of a file. In Java programming, we often need to operate files and folders. Sometimes, we need to get the parent path of a file, which is the path of the folder where the file is located. Java's File class provides the getParent() method to obtain the parent path of a file or folder. The File class is Java's abstract representation of files and folders. It provides a series of methods for operating files and folders. Among them, get
Use java's File.getParentFile() function to get the parent directory of the file
Jul 27, 2023 am 11:45 AM
Use java's File.getParentFile() function to get the parent directory of a file. In Java programming, we often need to operate files and folders. When we need to get the parent directory of a file, we can use the File.getParentFile() function provided by Java. This article explains how to use this function and provides code examples. File class in Java is the main class used to operate files and folders. It provides many methods to obtain and manipulate file properties
How to delete a file or directory using File.delete() method in Java?
Nov 18, 2023 am 08:02 AM
How to delete a file or directory using File.delete() method in Java? Overview: In Java, we can delete a file or directory using the delete() method of the File class. This method is used to delete the specified file or directory. However, it should be noted that this method can only delete empty directories or files that are not opened by other programs. If file or directory deletion fails, you can find the specific reason by catching IOException. Step 1: Import related packages First, we need
Create multi-level directories using java's File.mkdirs() function
Jul 24, 2023 am 11:04 AM
Create multi-level directories using Java's File.mkdirs() function In Java, we often need to create folders to store and organize files. Sometimes, we need to create multi-level directories, which are folders containing subfolders. Java provides the mkdirs() function of the File class to implement this function. The File class is a class in Java that handles files and directories. It provides a series of methods for operating files and directories. Among them, the mkdirs() function is a function that creates multi-level directories. Down
