Tuesday, February 21, 2012

Restoring database to Win 2003 Server

We are restoring a database to a Windows 2003 Server. After the install it
created a Data folder at E:\Microsoft SQL Server. I'm a local admin on the
machine and yet whenever I try to drill down into E:\Microsoft SQL
Server\MSSQL\, it gives me the error message "E:\Microsoft SQL Server\MSSQL
is not accessible. Access is denied."
I was hoping to create several subdirectories in this folder to structure
how our database .mdf files are structured. Suggestions? Am I missing
something? Is there something about SQL Server on 2003 that we should be
aware of?
Thanks in advance!
Mark
field027@.umn.eduMy guess is that the SQL Server service account lacks some permission on
that drive/directory.
--
Tibor Karaszi
"Mark" <mfield@.idonotlikespam.cce.umn.edu> wrote in message
news:ubJmEvkoDHA.2188@.TK2MSFTNGP11.phx.gbl...
> We are restoring a database to a Windows 2003 Server. After the install
it
> created a Data folder at E:\Microsoft SQL Server. I'm a local admin on
the
> machine and yet whenever I try to drill down into E:\Microsoft SQL
> Server\MSSQL\, it gives me the error message "E:\Microsoft SQL
Server\MSSQL
> is not accessible. Access is denied."
> I was hoping to create several subdirectories in this folder to structure
> how our database .mdf files are structured. Suggestions? Am I missing
> something? Is there something about SQL Server on 2003 that we should be
> aware of?
> Thanks in advance!
> Mark
> field027@.umn.edu
>

No comments:

Post a Comment