Access Denied Error when attaching a Database file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WayneM - 30 Sep 2005 00:02 GMT

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

Reply to this Message

Mike Epprecht (SQL MVP) - 30 Sep 2005 01:35 GMT

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/

>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
[quoted text clipped - 7 lines]
>
> WayneM

Reply to this Message

Hari Prasad - 30 Sep 2005 07:29 GMT

Hi,

See if the SQL Server service starup accoung have read/write access to the
folder.

Thanks
Hari
SQL Server MVP

>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
[quoted text clipped - 7 lines]
>
> WayneM

Reply to this Message

WayneM - 30 Sep 2005 19:47 GMT

Is it possible that the database file is corrupted? I am able to copy the
Master database file, but not my application database. Is there a simple way
to determine if the file is or is not corrupted?

Thanks,

WayneM

> Hi,
>
[quoted text clipped - 16 lines]
> >
> > WayneM

Reply to this Message

Keith Wilson [MSFT] - 05 Oct 2005 23:36 GMT

Is there a backup of these database(s), and is the backup file on a
different hard drive or server?

Regards,
Keith

This posting is provided "as is" without inferring rights or warranties.

> Is it possible that the database file is corrupted? I am able to copy the
> Master database file, but not my application database. Is there a simple
[quoted text clipped - 28 lines]
>> >
>> > WayneM

Reply to this Message