ATTACHING SQL SERVER_2000 DATABASE TO SQLSERVER 2008

Question

Post reply

ATTACHING SQL SERVER_2000 DATABASE TO SQLSERVER 2008

prasanthmanjelil

Valued Member

Points: 57
More actions
November 5, 2012 at 4:58 am

#284521

I TRIED TO ATTACH A DATABASE CREATED IN SQLSERVER_2000 INTO SQLSERVER_2008. BUT THE FOLLOWING ERROR MESSAGE APPEARED.
----------------------------------------------------------------
Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file "F:\Projects\Data\Geekay\PMS0001_Data.MDF". Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)".
----------------------------------------------------------------
PLEASE HELP ME.
REGARDS,
PRASANTH

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113445 More actions · Answer 1

OS Error 5 is access denied, ensure that the account running SQL has the nessesary permission to the directory

Lowell SSC Guru Points: 323504 More actions · Answer 2

i see that error in other posts a lot because people place the mdf in their MyDocuments folder or on their desktop, which all have restricted access, and the service account doesn't have access to places like C:\Users\SpecificUser\Desktop for example.

move the file to a non-private directory, like c:\Data or something first, and see if that fixes the issue for you.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Superdoc SSCommitted Points: 1654 More actions · Answer 3

I have seen this kind of behavior when i detach as someone and try to attach as someone else, also permission would be to a machine\user and machine name could be wrong.

wherever the mdf/ldf is located, go to the properties of the file, edit permissions and either inherit permission from parent or add yourself or the user who is trying to attach.