December 18, 2020

Permissions error when attaching a database: “Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists"

 When I try to backup or restore any database using a SQL Server, i have the following error when i click the browse button on the "Select backup destination" window:

D:\SQLServerData\Backup Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists. ...


When i try to edit folder path, execute backup I get this error.

The Service of SQL Server Instance hasn't enough rights to read the Data-Directory and/or the path of the folder. (Including the root of the drive to list the tree in the dialog box.) The Service needs at least the rights for listing the content of the whole path.SQL Service runing with local System account.


and i login using SQL Authentication, therefore user hasn't enough rights to read,

Solved:

If this is just a testing/developing environment the best way to solve this is to configure the SQL Server Instance Service for running with the SYSTEM-Accont. The SYSTEM-Account has Access to the Root of the Drive and the Data-Folder. This eliminates also a lot of other problems.

If you are using Windows Authentication you also need to run the Management Studio as an Administrator, if you don't have enough rights on this folder.



Warning: NEVER use the SYSTEM-Account for a productive Server. Use the Exec-Command to attach Databases and ensure there are enough rights for the service to access the Data-Folder.

Thanks.

0 comments:

Post a Comment