Attach database fail

  • I am trying to install MdxStepByStep database to my Server(SQL Server 2008)

    Authentication: Windows

    Logged in as Administrator.

    Owner of the database is set to be Administrator.

    On executing the query below,

    " exec master..sp_attach_db

    'MdxStepByStep',

    'C:\Microsoft Press\MDX SBS\Setup\SQL Server\MdxStepByStep.mdf' "

    I get the error;

    "Directory lookup for the file "C:\Microsoft Press\MDX SBS\Setup\SQL Server\MdxStepByStep.mdf" failed with the operating system error 5(Access is denied.)"

    I checked the permission and security of both .mdf and .ldf and the Administrator has Full Control.

    Is there anything else i have to modify to give access to the database?

    Thanks for your time!

  • What about permissions on the directory?

  • Duplicate post. Please post further replies here.

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

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