Post reply

Permissions needed for SA to restore files

  • September 26, 2008 at 5:05 am

    #194157

    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 5:45 am

    #877565

    do you have Sysadmin role granted?

  • September 26, 2008 at 6:13 am

    #877588

    Yes its got the sysad role.

  • September 27, 2008 at 5:48 pm

    #878105

    Double post .... Don't reply here, use the other one.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply