Recently, i try to to restore the data a SQL database on my
machine.
Instead of getting attached it pops up an error ‘Operating
system error 5(access is denied)’.
On first perception I
think there was an issue with data or operating system.
Then, I searched internet and found this solution.
You just need to change SQL service which is running
‘Network service’ to ‘Local system’.
Steps :
1. Locate SQL Server configuration Manager from start menu.
2. Then, locate for SQL Server service and right click for properties.
3. At this point it is running on ' Network service'.
4. Just change it to 'Local system ' and press 'Apply & OK' , but this will cause the service to be restarted.
Like this you can resolve your problem.
0 comments:
Post a Comment