- Grant the "Log On As" account for the SQL Server instance full control permissions to the database files. To find out the "Log On As" account for your SQL Server instance, use the following steps:
- Click Start
- Type services.msc and press Enter
- In the window that opens, scroll down to locate the service titled SQL Server (INSTANCE NAME)
- Scroll to the right to find the name of the account listed under the column "Log On As" (see the screenshot below)
4. Reboot the server.