Restore database from SQL 2000 to 2005 gives me a permission error

I am creating a backup of a database using Enterprise Manager. This creates a
file (a rather large file). I transfer this file to a machine where SQL 2005
is installed. I choose to restore the database. I type in the destaination
database name and browse to find the "device"/file where my backup resides. I
change the path for the transaction logs and data file because the paths on
the backup copy do not match the path to where SQL 2005 has the data stored.
Besides the backup copy references a drive letter that does not exist on the
SQL2005 machine. Anyway once all of that is done I click on OK then I get an
error indicating access deniied. No file name or path is given the error just
indicates a permission problem. I did not have this problem with backup and
restore from SQL 2000 to another SQL 2000 machine. Any ideas?
Thank you.
Kevin BurtonDoes your SQL Server service account has permissions to write to that
location?
For example, if you are restoring to K:\Data then make sure the service
account has write permissions on the K: drive.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Kevin Burton" wrote:
> I am creating a backup of a database using Enterprise Manager. This creates a
> file (a rather large file). I transfer this file to a machine where SQL 2005
> is installed. I choose to restore the database. I type in the destaination
> database name and browse to find the "device"/file where my backup resides. I
> change the path for the transaction logs and data file because the paths on
> the backup copy do not match the path to where SQL 2005 has the data stored.
> Besides the backup copy references a drive letter that does not exist on the
> SQL2005 machine. Anyway once all of that is done I click on OK then I get an
> error indicating access deniied. No file name or path is given the error just
> indicates a permission problem. I did not have this problem with backup and
> restore from SQL 2000 to another SQL 2000 machine. Any ideas?
> Thank you.
> Kevin Burton|||I am guessing NTFS permissions with the agent
"Kevin Burton" wrote:
> I am creating a backup of a database using Enterprise Manager. This creates a
> file (a rather large file). I transfer this file to a machine where SQL 2005
> is installed. I choose to restore the database. I type in the destaination
> database name and browse to find the "device"/file where my backup resides. I
> change the path for the transaction logs and data file because the paths on
> the backup copy do not match the path to where SQL 2005 has the data stored.
> Besides the backup copy references a drive letter that does not exist on the
> SQL2005 machine. Anyway once all of that is done I click on OK then I get an
> error indicating access deniied. No file name or path is given the error just
> indicates a permission problem. I did not have this problem with backup and
> restore from SQL 2000 to another SQL 2000 machine. Any ideas?
> Thank you.
> Kevin Burtonsql