Results 1 to 2 of 2
  1. #1
    Join Date
    May 2015
    Posts
    1

    Unanswered: Cannot open mdf file in Microsoft SQL Server Management Studio Express 2005

    I had Microsoft SQL Server Express 2005 installed already. I just

    installed the Microsoft SQL Server Management Studio Express 2005 and

    tried to open my mdf file. I get an error message that says:

    There is no editor available for 'C:\Inetpub\wwwroot\intranet\app_data

    \intranet.mdf).
    Make sure the application for the file type (.mdf) is installed.

    Did I do something wrong? I just clicked through the defaults in the

    Management Studio Express install.

    How can I get this to work?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I would recommend that you copy the MDF and associated LDF files to the location where the other files are on your system. If these are on the C: drive, that is Ok for a development workstation but it is a really bad idea for a production server.

    Once you have the MDF and LDF files where you need them, right click on the "databases" drop down in SSMS (SQL Server Management Studio), and select the Attach menu option. Fill in the dialog box, and things usually go smoothly.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •