Question
Which specific Windows user account requires permissions to restore a SQL Server database?
Asked by: USER7198
90 Viewed
90 Answers
Answer (90)
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.