up vote 0 down vote favorite
share [g+] share [fb]

I have a database backup located in my Windows 7 Documents folder (c:\Users\Aaron\Documents...), and I'm trying to restore it using SQL Server Management Studio. However, the program is unable to access anything within the Users\Aaron directory using its non-standard file selection dialog, even when run as an Administrator.

I'm brand new to Windows 7... Is there some sort of security setting that I need to trigger to give programs access to these files?

link|improve this question
feedback

2 Answers

up vote 1 down vote accepted

Try giving the "Network Service" permissions on the folder. Worked for me.

link|improve this answer
Could you explain how you discovered that those permissions were needed? – Tom Wijsman Dec 5 '11 at 13:46
1  
This page on sqlservercentral. However I didn't seem to have the security group they were talking about so I just added the network service account itself. As I added it to each sub directory SSMS could drill one level further into my user directory. (p.s. not sure what the security implications of doing this are..) – Mike Walsh Dec 6 '11 at 1:05
feedback
up vote 0 down vote

You will have to place the file some where else.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.