Re: SQL Express MDF file moved from 1 computer to another - auth f

I gave netwok service full control over everything in C: but still have same
error.
--
CommDown


"Roger Wolter[MSFT]" wrote:

The SQL Express runs as "Network Service" by default and this is the user
who must open the file. Network Service has very few permissions so there's
a good chance it doesn't have permissions to your c:\ directory. Try giving
Network Service permissions for the mdf and ldf files.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"CommDown" <CommDown@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:46218AB1-6D36-4347-8241-E6EBA4D25A58@xxxxxxxxxxxxxxxx
Thank you for the reply you Mean Old DBA! I try to attach the database as
you said, and I get the following error which i cannot find any answers
to...
Any advice you may be able to give would be greatly appreciated. Also,
when
I try to attach the database which is located in MyDocuments\Visual
Studio2005\Websites\WebsiteName\AppData\Database.mdf , it will not let me
navigate to that folder, so I have to copy the database to the c: in order
to
find it, then it looks to the correct path to find and connect to the ldf
file, but claims access denied, and this happens whether I have a sa login
or
use windows authentication.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'PC0005\SQLEXPRESS'.
(Microsoft.SqlServer.Smo)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------

Directory lookup for the file "C:\Documents and Settings\bmcnamara\My
Documents\Visual Studio
2005\WebSites\TimeTracker1\App_Data\TimeTracker_log.ldf" failed with the
operating system error 5(Access is denied.). (Microsoft SQL Server, Error:
5133)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=5133&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

--
CommDown


"MeanOldDBA" wrote:

Have you attached the database yet? That will be the first step. Lookup
attach database in Books Online. You will then be able to access it from
SQL
Server Management Studio. After that, add a login and user (again, you
can
find out details in BOL). Give the user access to the database. Change
your
application connection string to use the proper login.


--
MeanOldDBA
derrickleggett@xxxxxxxxxxx
http://weblogs.sqlteam.com/derrickl

When life gives you a lemon, fire the DBA.


"CommDown" wrote:

I copied a project I am working on from one computer to another
computer for
work at home. I try to access the mdf file that I have for this
project, and
now it tells me that authentication has failed for my windows
authentication
on my system. I am trying to find out how I can change the
authentication
type from windows to sql. When I go back to my work computer, I do not
see
any users datatable or anything where i can add for a sql
authentication. I
tried to access the database through the SQL Server Management studio
and
still get the same issue.

Any help that can be offered would be greatly appreciated.
--
CommDown



.