To attach the .mdf file

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

I have the Test.mdf & Test.ldf files in my particular location(D:\DBFolder)

But when I attach that Test.mdf file by attach option then a error msg shown('Attach database failed for Server 'MachineName\SQLEXPRESS'.
(Microsoft.SqlServer.Express.Smo)')

my database userID = sa
my database Password = sa
The Database Service ('SQL Server (SQLEXPRESS)') logon is 'NT AUTHORITY\NETWORKSERVICE'

My OS is XP serpack 2 & No set password & OS System UserName is 'Machine\User'

How will i solve above problem?????
Please Please help me any instruction.......

Posted 8-Aug-12 22:26pm

Member 7678194

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aarti Meswania · Answer 1 · 2012-08-09T00:39:00

there could be no. of reasons for failure of database attachment
Like

1. mdf file is made in upgrated virsion than your sql server's version
   e.g. database was created in 2008 and you are trying to attach in sql-2005
2. Login 'sa' have not enough rights/permissions to perform database attachment.
3. this Name is already exist in history of database names.

etc...

please describe error details if it is possible.

Happy Coding!
:)

ujju.1 · Answer 2 · 2012-08-09T00:05:00

Solution 1

first you need to stop the server then attach the files.

Posted 9-Aug-12 0:05am

ujju.1

To attach the .mdf file

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

To attach the .mdf file

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us