September 26, 2008 at 5:04 am
Hi Folks,
Im using MSSQL Management Studio Express with sql server authentication for the SA user. I would like to restore a database from a backup file but when I attempt to browse a folder for the file, the SA user does not have permissions to open the folder.
How do I grant SA or any SQLServer user access to a folder, as it is not a Windows authenticated user. Sorry if this is a simple question!
Thanks
September 26, 2008 at 6:59 am
I believe SSMS is using your windows credentials to browse to the folder, so it would be your credentials that do not have access to the folder. I could be wrong.
How are the backups being written to the folder? What account(s) are the SQL Server services (SQL Server and SQL Server Agent) using?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 26, 2008 at 7:18 am
These are backups from a different server which have been placed into this backup folder. SS runs as the network service which has full read/write access to the folder.
Management studio is able to browse some folders on the computer but not others, I have compared the folder permissions and they are identical on the ones that it can access and the ones that it cant.
Any ideas?
September 27, 2008 at 5:47 pm
Don't use sa. Create a windows login with the appropriate premissions in SQL and Windows.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply