Search code examples
asp.netsql-servermdf

not connecting because read-only (sql server, mdf file)


this is a different question concerning:

add a connection to database not working, asp.net to mdf

i am unable to connect because of the noted error message

the database must be read only? but when i click the properties of the file read only is not checked

is there another way it could be read only?


Solution

  • Yes definitely - you can set a filegroup inside a MDF file to be read-only - only that shouldn't prevent you from connecting to it - just from altering anything inside it.