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

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
.