Failed to update .mdf database because the database is read-only

Question

0.00/5 (No votes)

See more:

, +

Hi,

I've created a database windows application using C#.net.My application is running successfully in windowsXp, but it doesn't properly execute in vista/Windows7 systems.
My application shows a message like "Failed to update .mdf database because the database is read-only" Any one give me a proper solution.

Posted 18-Apr-11 22:03pm

ambarishtv

Add a Solution

8 solutions

Solution 2

First of all:
Any one give me a proper solution.
Well, define 'proper solution'. After that, no need to use bold for it. If you have an issue and you are here for help, please be a little respectful.

Now:
"Failed to update .mdf database because the database is read-only"
A simple Google search[^] could had given you many links like this:
Similar discussion[^]

based on what you say, and the discussion link above, Win7 & Vista has some extra security layer and you need to give proper permissions to the user who is trying to access the database. It's a security configuration issue.

(BTW, I think, you should get the details of this privilege issue in EventViewer logged as an error.)

Posted 18-Apr-11 22:18pm

Sandeep Mewara

Comments

ambarishtv 19-Apr-11 4:27am

Sorry for my bad english.
How to overcome this security configuration issue.

Sandeep Mewara 19-Apr-11 4:37am

Did you go through the link I shared?

Further, looks like, Dylan Morley provided you a link. Did you went through his answer too?

Solution 5

Hi,
"Failed To Update .mdf Database." Some months before while in a windows project i came through this problem.
I googled enough and found some vital informations which i like share on this topic.

I'll put it one by one for easy understanding.
No matter whether its XP, Vista or Windows7. The Solution is all the same.

1. Just go to the program files and find the folder of the installed program.
2. Just right click the .mdf file in the folder and click PROPERTIES.
3. In PROPERTIES TAB -> SECURITY -> you'll see Group or Usernames.
4. In that select the User to which u want to give Access to the file.
5. If for that user the PERMISSION is not set to FULL CONTROL.
6. TO CHANGE PERMISSIONS -> CLICK EDIT.
7. Now the Group or Username box will open.
8. In that Select The User -> Select FULL CONTROL in Permission Box.
9. Now follow the steps for the log file too. IF Needed.

Now it'll Work..

Thank U,
RAJASEKAR KALIDASSAN

Posted 17-Jan-12 21:07pm

rajasekar kalidassan

Updated 24-Sep-12 2:43am

v2

Comments

Member 12175264 4-Jan-16 1:45am

Thanks it works...

AshuRevgade 4-Apr-16 2:47am

thaks..

Member 12456565 19-Jun-16 7:03am

Thanks

Member 12456565 19-Jun-16 7:07am

Hi Sir,

I am new wit C#, I am getting the same problem of "Failed to update database",I aslo follow the steps also but the user is already have FULL CONTROL allow to Read, Write etc...but still I am getting this error. Please suggest.

Solution 1

right click on your database in object explorer. select properties. under select a page, select page named Options. set "database read only" property which is under "State" option to False.

Posted 18-Apr-11 22:16pm

Kaur Jatinder

Comments

ambarishtv 19-Apr-11 4:48am

Thanks for replay
Database is not in object browser in visual studio.

Solution 8

Provided the database is TFS bound, then it should be checked out, or have the read-only flag unset.

Posted 5-Jun-13 3:19am

Aletheuein

Solution 6

it not working on windows 7.

please help me.

thanks in advance

Posted 14-Apr-12 0:22am

Abdhesh Mishra

Comments

[no name] 14-Apr-12 6:26am

This is not an answer to this year old question. If "it not working on windows 7", whatever "it" is, then ask your own question.

Solution 7

Publish your website without publish copy of App_Data folder
finally copy&paste your developer copy of App_Data folder > webserver

Posted 24-Apr-13 0:43am

Rajung

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dylan Morley · Accepted Answer · 2011-04-18T22:23:00

Bound to be a permissions issue with Vista not allowing access to \YourProjectPath\App_Data

1) Make sure App_Data directory or any contained files does not have file system attribute Read-only set.

2) Make sure the user account you are attempting to connect with has modify control over the App_Data directory.

Have a look at this thread[^] which has a full step-by-step (that's for ASP.Net, but the principal is the same - just choose a different user account at the end)

ambarishtv · Accepted Answer · 2011-04-19T03:22:00

I got answer...
Moving the data(.mdf)to the ApplicationData shared folder, where end users will have write permissions by default.

Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData).ToString) this code is used to find out the Application folder path in xp,vista,win7

Thank you all..

Failed to update .mdf database because the database is read-only

8 solutions

Solution 2

Solution 3

Solution 5

Solution 1

Solution 4

Solution 8

Solution 6

Solution 7

Add your solution here

Preview 0