SQL server - trouble restoring a database backup file

[strungoutyeh]

Hi all

Been stuck on this issue for a while now, i'm trying to restore a database backup file into a new database.....but with no luck.

I'm using:
Microsoft SQL Server Management Studio Express v9.0
SQL server 2005

And following this tutorial:
http://www.linglom.com/2008/01/12/ho...l-server-2005/


I have issues when i reach step 5/6 of the restore process. Please see the attached screenshot. It should display a tree structure of my folders/files, but i get that error message instead. Now, as you can see the path definitely exists, and i've checked my user account and i have administrator privileges, so i'm really not sure what the problem could be

Appreciate replys

cheers

[DaveMaxwell]

Your user account has access, but how about the service account that SQL Server uses? Right click on the folder itself and select "Properties". Then click on the security tab.

On my machine, I have a group listed as SQLServer2005MSSQLUsers$myMachineName. That group needs read/write and modify permissions on the folder.

[strungoutyeh]

Your user account has access, but how about the service account that SQL Server uses? Right click on the folder itself and select "Properties". Then click on the security tab.

On my machine, I have a group listed as SQLServer2005MSSQLUsers$myMachineName. That group needs read/write and modify permissions on the folder.

Ok just checked that, everything already looks like its setup properly.....yeah? (see attachment)

One thing i just remembered, my SQL account isn't the main admin account for this program, will this make a difference? (the admin password is unknown)

[strungoutyeh]

Can anyone else help me here?

I'm a bit new to this, but i've checked the permissions from articles on Google and still have no luck.


My account should have access to SQL service now

[strungoutyeh]

SOLVED


thanks for the help