0

I am not able to attach the databases in sql express edition with service pack 4.it is showing error .It was working fine till few hours back.

I am logged in as windows authentication.My os is windows 7.

i have attached the screen shoot of errorenter image description here

Thanks in advance.

asked Apr 13, 2011 at 12:25
0

2 Answers 2

2

Set the Operating system permission on that .mdf file to full permission. In short, change the permission to 'Everyone'. It will not give that error

answered Apr 13, 2011 at 12:27
Sign up to request clarification or add additional context in comments.

Comments

2

User you are logged in when you are trying to attach the database does not have permission to access the file in "C:\Program Files\Microsoft SQL Server...".

Try to login as "sa" or use Windows Authentication with user that has permission to access file you are trying to attach.

answered Apr 13, 2011 at 12:27

Comments

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.