Database is read-only 的解决方法
来源:互联网 发布:淘宝搜下血滴子 编辑:程序博客网 时间:2024/04/28 21:42
You need Read/Write permission on both MDF and LDF in order to editing data. If you're using IIS 6.0, you need to add Network Process account and give Read/Write permission to these two files. You also need to detach the database before changing the permissions on the file. You can do this using SSEUtil.exe tool:
http://www.microsoft.com/downloads/details.aspx?FamilyID=FA87E828-173F-472E-A85C-27ED01CF6B02&displaylang=en
> SSEUtil.exe -child "NT Authority/Network Service" -detach
Thanks,
Lan
>>> This account is use by IIS6. For more detail on the account, see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconiis60applicationisolationmodes.asp
- How can i create it.
>>> It should already created for you
- What do you mean by detach.
>>> you need to detach the database to release the current info in master database; so that the next time you load the page, it load the new permission for this database
- how can i use this tool for the same, as it is doing nothing when i have tried,
>>> here're the steps:
1) open window explorer, go to your app_data folder of your web project (e.g. d:/mywebsite/app_data folder)
2) select both *.mdf and *.ldf, right mouse click and click on Properties
3) click on security tab, click "Add" button
4) type <your Machine Name>/Network Service in the "Enter the object names to select textbox, click ok
5) make sure Read and Write permissions checkboxes are checked and click ok
6) open cmd window (assuming you already have a copy of SSEUtil tool)
7) type SSEUtil -d d:/mywebsite/app_data/test.mdf --- this step detach the database
8) run your page
Hope that help,
Lan
1. Delete the MDF/LDF files from the App_Data directory of the website under inetpub/wwwroot.
2. Download and install the SSEUTIL command line tool from:
http://www.microsoft.com/downloads/details.aspx?FamilyID=FA87E828-173F-472E-A85C-27ED01CF6B02&displaylang=en
3. Using sseutil, issue a command that looks something like: sseutil -child "NT AUTHORITY/NETWORK SERVICE" -detach D:/ . You will need to change the account name and the detach path to match your machine settings. If on IIS5/5.1, then ASPNET will be the correct user account. Also, you can determine the detach path pretty easily by issuing sseutil -list to see where the problematic MDFs are currently attached. The "D:/" in the sample command line is just the first few characters that sseutil uses to auto-detach all databases that begin with "D:/". Change the path as neeeded for your machine.
4. Set the ACLs on App_Data directory under inetpub/wwwroot to grant R/W to the appropriate process account - NETWORK SERVICE on WS03 or ASPNET on IIS5/5.1.
5. Re-copy the MDF/LDF files from the directory where the file-based website exists back into App_Data under inetpub/wwwroot. After the copy occurs, check that the MDF/LDF files have now inherited the new ACLs.
6. Re-run the application (ignore any connection errors that might occur - just hit refresh in the browser).
We are working on a fix in SSE that will eliminate the manual reconfiguration for RTM.
It's probably read only because the user that the SQL Server service runs as
only has read permissions on the files. Change the Windows permissions and
restart the database service.
- Database is read-only 的解决方法
- mysql的table is read only 解决方法
- mysql提示Table is read only的解决方法
- mysql中Table is read only的解决方法
- mysql中Table is read only的解决方法小结
- mysql中Table is read only的解决方法
- Connection is read-only问题的产生原因与解决方法
- ORA-16003: standby database is restricted to read-only access
- Database '' is in warm standby. A warm-standby database is read-only.
- Fedora11上安装bugzilla出现 max_allowed_packet is read-only问题的解决方法
- mysql做master/slave时当出现ERROR 1036 (HY000): Table is read only 的解决方法
- linux下mysql error #1036 - Table 'xxxx' is read only问题的解决方法
- ssh中Connection is read-only问题的产生原因与解决方法
- ssh中Connection is read-only问题的产生原因与解决方法
- ssh中Connection is read-only问题的产生原因与解决方法
- ADODB使用excel的"Cannot modify the design of table 'xxxx'. It is in a read-only database"的问题
- MySql出现#1036 – Table ‘ ‘ is read only 错误解决方法
- solution:Failed to update database "XXX.MDF" because the database is read-only.
- Crack Themida v1008 by KernelKiller
- Linux系统下的多线程编程入门
- 8088 汇编速查手册
- linux之 F.A.Q(转载)
- 老家的猫咪(图)
- Database is read-only 的解决方法
- 长期食素也增加患心血管病风险
- 海里的世界
- 老年人不能一味吃素
- 为何年龄越小越惹蚊子
- 用matlab编程实现计算器
- 马上考试了
- 读书笔记:JAVA.io 包
- Solr 企业级搜索引擎简介