problem in attaching ms sql database

why I get problem when I am trying to attach new database ( copied from another computer ) ??

I get the database attached as read-only !!

I took some snapshots of the problem

note, I am working in sql 2005 express
Ameerh24Asked:
Who is Participating?
 
sureshchsahuConnect With a Mentor Commented:
U can remove the readonly option for DB in sql

USE master
EXEC sp_dboption 'DBNAME', 'read only', 'FALSE'
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
was that database read-only when you originally took the backup ?
0
 
JakeBushnellCommented:
Check to make sure you have administrative rights to the folder where your new database resides...
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Ameerh24Author Commented:
Sorry, I forgot to upload the snapshots
1.JPG
2.bmp
3.JPG
0
 
Ameerh24Author Commented:
aneeshattingal, the database was not read only

JakeBushnell, yes I do have administrative rights
0
 
JakeBushnellCommented:
Your folder where the MDF file is is under the "Program Files" folder... Maybe its conflicting with what ever "program" that folder its in is associated with... Try making a new folder user your C drive and putting the MDF file there.

Then Right click the file and choose properties... On the general tab on the bottom right there is an Advanced button... There MAY be a button below that that says "Unblock".. If there is then click it.

Now try to attach the database again from there.

Hope that helps,
Jacob
0
 
Ameerh24Author Commented:
No Button called "Unblock"
0
 
Ameerh24Author Commented:
and its still read-only database !!!!
0
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
right click on the database -> properties -> options ->
 change database read-only to "false;
0
 
JakeBushnellConnect With a Mentor Commented:
Seems someone else here had a similar problem as well. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23417316.html

aneeshattingal's idea is a good one... also try renaming the database file.

Jacob
0
 
Ameerh24Author Commented:
right click on the database -> properties -> options ->
 change database read-only to "false;

it givrsd me error
0
 
Ameerh24Author Commented:
*gives
0
 
sureshchsahuCommented:
Did u try the option I have mentioned above.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.