Microsoft sql server error : 5123 [Solved]
Posted on Wednesday, February 19, 2014
|
No Comments
Access denied Error Solution :
open the properties of ldf and mdf file
1. Check the owner ship status of mdf and ldf file.
2. Check if there a use call Everyone user added to file group , if not found then added it to and give full permission.
1. if you have a lot file to do this operation you can do it using command prompt.
for taking ownership of all database or file of a directorry
D:
cd D:\SOL ServerDatabase2008\All
pause
takeown /f . /r
pause
save it and give extension of bat file and then execute using admin previlage
for add everyone user of a direcotry
icacls * /t /grant Everyone:F
pause
must run on same directory