Re: Rights needed to restore DB

Have you tried to login with the service account and access the path? I know
it does not sound logical that SQL Server would not have access to its own
path, but anway...
In addition, could you script your student login / user / permissions, in
order I can check it?

--
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message

"TLuebke" <TLuebke@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:78358925-255D-4EB7-B5D5-8448256078E3@xxxxxxxxxxxxxxxx
Here's the message:

"C:\Program Files\Microsoft SQL Server\MSSQL\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.

If you know that the service account can access a specific file, type in
the
full path for the file in the File Name control in the Locate Dialog box."

The File Name control is greyed out and doesn't allow students to type.
Also
trying to Add a file path fails.


"Dejan Sarka" wrote:

We are using the backup/ restore wizard and trying to reach the
default
SQL back-up folder on the local drive. The Administrator and Instructor
accounts can reach the folder and restore a file, but they have
sysadmin
role. Students with dbcreator role can backup but not restore.

So, what is the exact error message?

--
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of
the
sender.
This message does not imply endorsement from Solid Quality Learning, and
it
does not represent the point of view of Solid Quality Learning or any
other
person, company or institution mentioned in this message





.

Relevant Pages

  • Re: Cant Start Local Instance
    ... Perhaps the Password for the service Account did expire ... > Manager and click on Start I get an error message "The service did not ... >> If you get a login failure message, saying tht the password is not right ... >>>I installed SQL Server 2000 on my local WinXP Pro box. ...
    (microsoft.public.sqlserver.setup)
  • Re: SPN Requirement
    ... The service account for SQL Server needs to be a domain ... account to allow Write Public Information rights but I'd ... The SQL Network Interface library could not register the Service Principal ... Name for the SQL Server service. ...
    (microsoft.public.sqlserver.security)
  • Re: Question about "Distribution clean up: distribution" Job
    ... I granted the SQL Server Service Account "Full Control" over ... the Snapshot Folder and the job has been running successfully ever since. ... Then I went into the job step and copied the command it was ...
    (microsoft.public.sqlserver.replication)
  • Re: xp_cmdshell right for non sysadmin
    ... You can get the error when the SQL Server service account ... does not have the necessary permissions to change security ...
    (microsoft.public.sqlserver.server)
  • Re: Question about "Distribution clean up: distribution" Job
    ... I am guessing that the SQL Server Agent service account is not what ... rights to remove folders under P:\ReplData. ... Then I went into the job step and copied the command it was ...
    (microsoft.public.sqlserver.replication)