Home / server / Questions / 546452
Accepted
Luke Puplett
Asked: 2013-10-17 07:12:09 +0800 CST

I attached an MSSQL database but its read-only

  • 772

I copied a small database from one SQL Server 2008 R2 Express (physical) server to another of the same version, but I cannot re-attach. It attaches but the DB is greyed and read-only. It was writable in its former location.

sql-server

1 Answers

  1. Best Answer

    Ensure that the SQL Server account has permissions on the folder in which the database file(s) and log file(s) reside.

    • 0