[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 10111
  • Last Modified:

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?
0
bhorlings
Asked:
bhorlings
  • 4
  • 3
1 Solution
 
SQL_SERVER_DBACommented:
search the drive for intranet.mdf and then attach it from the location you find it.
0
 
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
 
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now