Click "SQL Server Management Studio" to open the Connect to Server dialog ... Type in the full name of the .MDF file, including the full device and directory path, as the following example ...

How can I open .mdf files( SQL server files) and access the data. I downloaded MSDE software but unable to install it says Strict username and psaaword required . were should i look for that.

The only suggestions I can find to fix this is to use the DBCC CHECKDB command with REPAIR_REBUILD; the problem, of course, is that the SQL Server won't even attach this MDF file in the first ...