Computer room charge System--additional database

When attaching the database, there was an error "attaching the database error, for specific information, click the hyperlink in the message column." ”

Click "OK" to open the hyperlink in the Message column and pop up the error box "An exception occurred while executing the Transact-SQL statement or batch." Unable to upgrade to database ' Charge_sys ' because it is read-only, or just read files. Make the database or file writable, and then perform the restore operation again. ”

Cause of error: This is the NTFS permissions issue (disk partition format), NTFS format has a lot more options for permissions, and therefore brings many problems. For example, this time the authority is unassigned and the attach is unsuccessful.

Workaround: Assign the "Full Control" permission to the directory where the file resides to users to resolve the problem.

Select the directory where the files you want to attach are located, and then right-click Properties-Security-users-to select "Full Control" in Users-apply-OK.

Then open the database, attach

Click "Join"

Check the MDF file-"OK"

Click OK

haha ~ the Attach succeeded

Of course, there are two ways to solve the problem besides this one (by myself)

The first copy of the file to be attached is copied to the SQL Server default data folder, and then the attach succeeds.

Another option is to select Windows Authentication when logging in to verify that you can attach a success.

Additionally, there may not be a "security" tab in the properties of the XP user directory. WORKAROUND: Open My Computer-tools-Directory Options

Remove the "Use Simple File Sharing (recommended)" button on the View tab to

Database attached successfully, the next knock on the machine room. Haha, look forward to ~

If you have any questions or suggestions, please leave a message ~

Computer room charge System--additional database