When an SQL Server database is attached to Vista, error 5123 is returned.

A friend changed his notebook and appended the database of SQL Server 2005 that was originally backed up to report "trying to open or create a physical file"... ", create file encountered an operating system error 5 (Access denied .). (Microsoft SQL Server, error: 5123) "error. The same error is reported when the Administrator logs on.

It is normal to append data to the XP operating system or the SQL Server on 64-bit Vista, so it is basically determined that the File Permission is a problem. Find the MDF file and LOG of the database backed up on the hard disk, open the security option, and find that the currently logged-on user has no permission to modify the file, and the file modification is assigned to the current user, attach the database file again. It can be seen that the user permission control in Vista is strict, but once again, it is really annoying to click the button for N security prompts for each operation.