Re: Access Denied Error when attaching a Database file

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 09/30/05 

Date: Fri, 30 Sep 2005 02:35:46 +0200

Hi

Right click on the File > Properties, Security Tab.

Change the permissions that you can access it.

You may want to login as administrator and take ownership of the directory
too.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"WayneM" <WayneM@discussions.microsoft.com> wrote in message
news:66CD847E-6B85-41C7-AC03-491E4B6D32A2@microsoft.com...
>I have a server that crashed, so a new OS was installed. I now have access
> to the drive where the database file exists. I am now trying to either
> copy
> that file onto a new server or reattach it to a new insance of SQL Server.
> In both cases I get a Access denied error.
>
> Any suggestions on how to get around this ?
>
> Thanks in advance,
>
> WayneM

Relevant Pages