0

I tried to add luxury database to my SQL Serever 2008 but I'm getting an error.

It displays below error :

attach database failed for server 'SAMEER-PC'.(Microsoft.SqlServer.Smo)
ADDITIONAL INFORMATION
An exception occured while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Database luxury Drive cannot be upgraded because it is read-only or has read only files. Make the database or files writeable,and rerun recovery.
Could not open new database'luxury drive'. CREATE DATABASE id aborted.(Microsoft SQL Server, Error: 3415)

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Sameer
  • 11
  • 4
  • 2
    @Sameer please always **`Google`** before Asking a Question. – Prahalad Gaggar Oct 05 '13 at 05:29
  • 1
    Database luxury Drive cannot be upgraded because it is read-only or has read only files. Make the database or files writeable,and rerun recovery.... please read the error message well – Ilyes Dec 02 '16 at 08:59

2 Answers2

0

Follow this steps :

  • Right click on your .MDF , click on properties Uncheck Read Only property.

  • Right click on the folder that contain your .MDF , click on properties Uncheck Read Only property.

  • Open SSMS ( SQL Server Management Studio).

  • Right click on the DB in the Object Explorer , Set Read Only Property toFALSE in the options menu.

Ilyes
  • 14,640
  • 4
  • 29
  • 55
-1

The user not have the permissions to access.

The below link was helpful in figuring out the problem.

Reference

Community
  • 1
  • 1
Prahalad Gaggar
  • 11,389
  • 16
  • 53
  • 71