localdb只读数据库问题 [英] localdb readonly database problems

问题描述

环境

visualStudio 2012 localdb v11

visualStudio 2012 localdb v11

上面有3个项目的解决方案:

a solution with 3 projects on it:

具有ORM数据库模型的第一类库，并且App_Data目录中具有本地db Localdb.mdf.

1st class library with an ORM database model, and a local db Localdb.mdf inside App_Data directory.

2nd是一个使用此数据库模型的Web项目.

2nd is a web project that uses this database model.

和第三个使用此localdb数据库的c#控制台项目，该对象引用第一个类库，并在app.config上具有一个定义为:

and 3rd a c# console project that uses this localdb database, referencing the 1st class library, and having at the app.config a localdb connection string defined as:

数据源=(LocalDB)\ v11.0; AttachDbFilename = C:_work_desarrollo \ Apps \ Business \ OpenAccessAppsModel \ App_Data \ LocalDb.mdf;集成安全性= True

Data Source=(LocalDB)\v11.0;AttachDbFilename=C:_work_desarrollo\Apps\Business\OpenAccessAppsModel\App_Data\LocalDb.mdf;Integrated Security=True

我的问题是: 我想使用VS 2012服务器资源管理器对此数据库进行一些更改，例如删除表，并且得到数据库为只读.直到将数据库设置为可读写后，数据库更新才会成功".

My problems are: i would like to made some changes using VS 2012 server explorer to this database like deleting tables and i got "The database is readonly. Updates to the database will not succeed until the database is made read write"

第二，如何使控制台应用程序(第3个项目)可以使用数据库文件，以便复制/粘贴发行文件夹以安装"控制台应用程序? 如何修改数据库连接以使数据库通过控制台应用程序本地化? (与应用程序相同的目录)

and second, how can i made available to the console application (the 3rd project) the database file so i can copy/paste the release folder to "install" the console application? How the database connection should be modified to have the database locally with the console applciation? (same directory as the app)

非常感谢

推荐答案

今天发生在我身上.

您可以像这样授予/更改数据库权限:

You can grant/change db permissions like this:

icacls mydabase *.*/grant"NT Service \ MSSQL $ SQLEXPRESS":[F)

icacls mydabase*.* /grant "NT Service\MSSQL$SQLEXPRESS":(F)

icacls mydabase *.*/grant"MYMACHINENAME \ Administrator" :( F)

我已经设置了sqlexpress权限，但是发现还需要machine \ administrator.

I already had sqlexpress permissions set but found out that machine\administrator was also needed.

希望有帮助.

这篇关于localdb只读数据库问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！