SQL2005 create file encountered an operating system error 5 denial of access error 1802_mssql
Source: Internet
Author: User
Issue 1: When you try to open or create a physical file ' E:\Library.mdf ', the Create file encounters operating system error 5 (Access denied.) )。
Best Answer:
This is because SQL Server's startup account (typically system or an operating system administrator) does not have permission to create files for the e-packing directory. Right-click E disk and view the Security tab in the properties to view the user's permissions. To see who the startup account is, run services.msc, locate the SQL Server service in the Service Manager, and then look at the Login tab.
I added that it was a matter of authority. -> Task Manager: Locate the Sqlservr.exe Username: Network Service and system. The permissions for the specified directory are then added to these two users. Full Control. The problem is solved ...
If you want to log in with the SA user, you need to set the status and password of the SA for login in security
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
