I created a new user on the server that will access certain databases.
But when I go to backup or restore the database I get the error:
C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLBackup
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.....................
The error shows for any other path in my system. Even those where the user and the Service Account has full control permissions.
BUT, if I type the full path and click ok, it complains that it can't show, BUT it does backup or restore the database. Just doesn't show the tree view for the path.
If I do the operation using the sa
account, the dialog shows all paths without complaint.
PS: Already added user to the db_backoperator
role.
What permissions are required?
See Question&Answers more detail:os