Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

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

database

This topic has been archived. This means that you cannot reply to this topic.
1 reply to this topic

#1 calebclark

calebclark

    CC Lurker

  • Just Joined
  • Pip
  • 1 posts

Posted 27 May 2015 - 05:15 AM

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 WingedPanther73

WingedPanther73

    A spammer's worst nightmare

  • Moderator
  • 17757 posts

Posted 27 May 2015 - 05:31 AM

You'll need to open SQL Server Management Studio, then from there attach your database. Once you've done that, you'll be able to connect to the database, run queries, etc.

 

You are NOT dealing with something like Access, where you just double-click and play around.


Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

My MineCraft server site: http://banishedwings.enjin.com/