Competition: What’s your favorite Redgate tool? Enter now.
Authentication error when using windows authentication
When trying to do a restore with the gui and using windows authentication we get an error saying that the user does not have backup or restore permissions. The user is a local windows administrator with sa rights on the database server. When switching to sql authentication we can get the restore process started but can not browse to the backup files or restore paths.
0 · Share on Twitter