-
Title
SQL server Restore fails with permission denied in database 'master' -
Description
SQL server Restore fails with permission denied in database 'master' as seen in binary log extract below
Error 2015/01/30 11:46:05 402 Data Plugin DHANNAVDB ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE DATABASE permission denied in database 'master'.
ODBC Error Number:42000, MsgState=1, Severity=14, Servername=DHANNAVDB, ProcName=, LineNumber=1, Message:[Microsoft][ODBC SQL Server Driver][SQL Server]CREATE DATABASE permission denied in database 'master'.
-
Cause
Default user assigned to SQL Server process has insufficient privilege/access wrights
-
Resolution
On client we are restoring SQL server backup to open windows services, right click the SQL Server process, select logon.
In here we see the user configured for the SQL Server process. Change the user to have sufficient privilege/access wrights to run restore.
Example of this would be domain administrator user with full SQL Server privileges
AD account that is running the Netvault Process Manager on the target SQL Server- has to have local admin on the server and ‘sysadmin’ rights in SQL. It needs local admin on the server so it can access the file system (directory) where the restore will take place.