i'm creating installation setup 1 of applications using visual studio setup project in vs2010. in i'm accessing database application folder. have added both mdf , ldf files data folder in application folder. works fine , i'm able install application, when opening application i'm getting error saying 'cannot update database because read-only'. have checked database ssms , see read-only flag set true default , database showing in gray color. after change read property application works fine.i have done lot of searching , rebuild-ed project many times changing database. how can rid of issue ?
a couple of possibilities:
in setup project, on properties window of db file in file system on target machine view, make sure didn't accidentally set readonly property true.
if database in application folder in (for example) program files folder, location read-only limited users. haven't said whether app users or administrators. if it's limited user install file user's personal folder or location limited users can write to. if app requires admin privilege app needs elevation manifest cause run admin privilege, if that's why db readonly. running app administrator quick test see if issue.
Comments
Post a Comment