Hi
I have a C# application which creates and populates a SQL Server
Express database. I then copy the database and log files and move it
to a different directory where I would like to use SQL Server
Management Studio Express to view the results. Problem is, when I try
to attach to the database file I get a message which says directory
lookup for <path to original location> failed with operating system
error 5 (access is denied). Can anyone tell me how to go about doing
this?

thanks,

Zenon

Does the service account have proper permissions on the directory/files where the database files
resides? The error message comes from the operating system and is very clear.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Zenon" <zenonk@comcast.net> wrote in message
news:1182870192.805735.96570@o61g2000hsh.googlegro ups.com...
> Hi
> I have a C# application which creates and populates a SQL Server
> Express database. I then copy the database and log files and move it
> to a different directory where I would like to use SQL Server
> Management Studio Express to view the results. Problem is, when I try
> to attach to the database file I get a message which says directory
> lookup for <path to original location> failed with operating system
> error 5 (access is denied). Can anyone tell me how to go about doing
> this?
>
> thanks,
>
> Zenon
>

On Jun 26, 5:03 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@hotmail.nomail.co m> wrote:
> Does the service account have proper permissions on the directory/files where the database files
> resides? The error message comes from the operating system and is very clear.
>
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>
> "Zenon" <zen...@comcast.net> wrote in message
>
> news:1182870192.805735.96570@o61g2000hsh.googlegro ups.com...
>
>
>
> > Hi
> > I have a C# application which creates and populates a SQL Server
> > Express database. I then copy the database and log files and move it
> > to a different directory where I would like to use SQL Server
> > Management Studio Express to view the results. Problem is, when I try
> > to attach to the database file I get a message which says directory
> > lookup for <path to original location> failed with operating system
> > error 5 (access is denied). Can anyone tell me how to go about doing
> > this?
>
> > thanks,
>
> > Zenon- Hide quoted text -
>
> - Show quoted text -

I am not certain that it does. I have tried to create a service
account with a TSQL statement that I found and then I gave it
permissions in SQL Server Manager. I cannot navigate to the file
where the copy of the db is though (only to the directory) so that
leads me to believe that my permission granting was unsuccessful. Can
you tell me how or point me to a good set of instructions please? I
am a newbie and everything I found is pretty vague.

thanks very much

Hi,

What do you mean about that you can't navigate to the file but you can
navigate to the directory? Does it mean that you can browse to the
folder but not see the file? If that's the case, then you have to look
at your OS permissions for that user you are using (..and that's not
really a SQL server issue..:-)...). The errormessage you get, isn't a
SQL server message but an OS error.

Maybe you could also show us the code you are running so we can see if
there're anything in there that rings a bell?

--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator

- Show quoted text -
>
> I am not certain that it does. I have tried to create a service
> account with a TSQL statement that I found and then I gave it
> permissions in SQL Server Manager. I cannot navigate to the file
> where the copy of the db is though (only to the directory) so that
> leads me to believe that my permission granting was unsuccessful. Can
> you tell me how or point me to a good set of instructions please? I
> am a newbie and everything I found is pretty vague.
>
> thanks very much
>

On Jun 28, 5:23 am, "Steen Schlüter Persson (DK)"
<steen@REMOVE_THIS_asavaenget.dk> wrote:
> Hi,
>
> What do you mean about that you can't navigate to the file but you can
> navigate to the directory? Does it mean that you can browse to the
> folder but not see the file? If that's the case, then you have to look
> at your OS permissions for that user you are using (..and that's not
> really a SQL server issue..:-)...). The errormessage you get, isn't a
> SQL server message but an OS error.
>
> Maybe you could also show us the code you are running so we can see if
> there're anything in there that rings a bell?
>
> --
> Regards
> Steen Schlüter Persson
> Database Administrator / System Administrator
>
> - Show quoted text -
>
>
>
>
>
> > I am not certain that it does. I have tried to create a service
> > account with a TSQL statement that I found and then I gave it
> > permissions in SQL Server Manager. I cannot navigate to the file
> > where the copy of the db is though (only to the directory) so that
> > leads me to believe that my permission granting was unsuccessful. Can
> > you tell me how or point me to a good set of instructions please? I
> > am a newbie and everything I found is pretty vague.
>
> > thanks very much- Hide quoted text -
>
> - Show quoted text -

Hi,

Yes, I meant that I could browse the folder but not the file. You
gave me a good idea about the problem being an OS permission and not a
SQL Server issue (sorry foe being off topic). I solved this by
creating a Network Service in the directory's Group or User Names
section, then giving that user full permissions on the directory in
question. Thanks all for the .