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: Upgrade from 2005 to 2008: Invalid Credentials
    ... it seems that this issue was related to NETWORK SERVICE account for SSIS service could not be validated on DC. ... Please first go to your Services pane, double click your SQL Server Integration Services, switch to the Log On tab to check if the service account is NETWORK SERVICE account. ... Install SQL Server 2008 from the Command Prompt ... Microsoft Online Community Support ...
    (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 failed to execute because current security context
    ... INFO: databasename: xp_cmdshell failed to execute because ... SQL Server running under has appropriate privilege. ... Server service account does not have all the relevant permissions not the sql ... ontario, canada ...
    (microsoft.public.sqlserver.server)