Re: Access Denied Error when attaching a Database file

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 09/30/05 

Date: Fri, 30 Sep 2005 11:59:59 +0530

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

Relevant Pages

  • Re: Backu plan
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > but if i use the codes, the folder will have so many backup files after ... >> Why not simply use a different file name for each backup. ...
    (microsoft.public.sqlserver.programming)
  • Re: Local datastore for visual basic .net aplication on a pda
    ... In other words, if you don't need to sync your datastore with the desktop, ... SqlServerCe is what you want. ... >> database file as an local datastore without the SQL server running? ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Upgraded to Visual C# Express 2005 SP1, can no longer persist data in SQL Server Express
    ... none of my apps will persist data to ... SQL Server Express (have not yet applied the Service ... Just off the top of my head, could it be that your database file is copied to the bin directory each time you build/run, so that you always start with the same version? ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Getting 5105 error when I try to attach database
    ... check SQL Server does to detect if I'm accessing a database file through a ... database file over a network share anyway. ... >> activation error), it gives the same path that I gave it, and says that the ...
    (microsoft.public.sqlserver.server)
  • Re: execute pkg
    ... Ideally you create the folder structure as per an installation of SQL Server. ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)