Friday, 5 July 2013

SQL Fix : Operating system error 5(access is denied)






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