I had Microsoft SQL Server Express 2012 installed already. I just installed the Microsoft SQL Server Management Studio Express 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?
If the file doesn't open you can try to open it using a [mdf tool]. just to avoid any possible confusion: in sql management studio, connect to your instance, and open the databases folder. in the context menu of that folder, choose "attach database". :