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?
LVL 1
bhorlingsAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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".
that will open a form, that will look like this:
http://www.webpartner.com/images/SQLServerAttachDatabase.jpg
<the screenshot is sql 2000, but quite similar>

full procedure explained here also:
http://msdn2.microsoft.com/en-us/library/ms190209.aspx
0
 
SQL_SERVER_DBACommented:
search the drive for intranet.mdf and then attach it from the location you find it.
0
 
bhorlingsAuthor Commented:
I am not trying to connect to it in SQL Management Studio. I am trying to do it in the Express edition. I tried the suggested solution of connecting to an instance first and then opening it but I still get the same error.
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>I am not trying to connect to it in SQL Management Studio. I am trying to do it in the Express edition.
management studio is the management interface for sql 2005 database instance, it does not matter if you have Express, Standard or enterprise Edition.

>and then opening it
so you did not try to attach it, did you?

0
 
bhorlingsAuthor Commented:
I opened the managament studio. Then I attached my sqlexpress instance of the database. After that I tried to open a file (intranet.mdf) and receive the no editor error.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>After that I tried to open a file
can you describe the EXACT steps, menus you click, buttons etc...

0
 
bhorlingsAuthor Commented:
1. Open Microsoft SQL Management Studio Express
2. Click the Connect button to connect to the Data Engine with Server Name: tech\sqlexpress
3. After it connects, File > Open > File
4. The Open File windows pops up
5. Browse out to C:\i netpub\wwwroot\intranet\app_data\intranet.mdf
6. Click Open
7. Error window pops up and says:

There is no editor available for 'C:\i netpub\wwwroot\intranet\app_data\intranet.mdf'
Make sure the application type for file (.mdf) is installed.

Coincidently, when I try to open the database in Visual Web Developer I get an error message that says:

Generated user instances is disabled. Use sp_configure 'user instances enabled' to generate user instances
0
 
bhorlingsAuthor Commented:
I figured it out. I did not attach the mdf file to my database instance. If I would have read what you said in the first post instead of reading what I thought you said I would have gotten there a lot sooner. Thanks for the help. On a side note... The other error went away when I reinstalled SQL Server Express. Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.