Thursday, February 9, 2012

Access Denied Error when attaching a Database file

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,
WayneMHi
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|||Hi,
See if the SQL Server service starup accoung have read/write access to the
folder.
Thanks
Hari
SQL Server MVP
"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|||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 wa
y
to determine if the file is or is not corrupted?
Thanks,
WayneM
"Hari Prasad" wrote:

> Hi,
> See if the SQL Server service starup accoung have read/write access to the
> folder.
> Thanks
> Hari
> SQL Server MVP
> "WayneM" <WayneM@.discussions.microsoft.com> wrote in message
> news:66CD847E-6B85-41C7-AC03-491E4B6D32A2@.microsoft.com...
>
>|||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.
"WayneM" <WayneM@.discussions.microsoft.com> wrote in message
news:360AE82B-6E0D-4B75-847C-9C79247CDCFD@.microsoft.com...[vbcol=seagreen]
> 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
> "Hari Prasad" wrote:
>

No comments:

Post a Comment