Error: Access is Denied appears while restoring the database from Microsoft SQL Management Studio:
Root Cause: SQL Server Service (mostly SQL Express) is running with login account which is not having rights to perform the restore operation.
Solution:
It can be solved by changing the logon account of SQL Server Service from its properties and then restarting the service.
Refer below screenshot to change the service's login account:
Posted by Admin (administrator) on 18 January 2019 at 11:21.
Edited by Admin (administrator) on 18 January 2019 at 11:35. |
|
