Which specific Windows user account requires permissions to restore a SQL Server database?

Question

Grade: Education Subject: Support
Which specific Windows user account requires permissions to restore a SQL Server database?
Asked by:
90 Viewed 90 Answers

Answer (90)

Best Answer
(422)
The Windows user account that requires permissions is the SQL Server service account. This is the account configured to run the SQL Server Database Engine service (e.g., NT Service\MSSQLSERVER, LocalSystem, Network Service, or a dedicated domain account). This account needs 'Read' permission on the backup file and 'Full Control' or 'Modify' permission on the destination folder where the .mdf and .ldf files will reside.