Sign in
 
Microsoft Developer Network > Forums Home > Visual Studio Archives (Older Beta or Preview forums) Forums > Visual Studio 2008 SP1 (Beta) > Unable to create .MDF file within Visual Studio 2008 SP1 RTM/SQL Server Express 2008
Ask a questionAsk a question
Search Forums:
 

Proposed AnswerUnable to create .MDF file within Visual Studio 2008 SP1 RTM/SQL Server Express 2008

  • Sunday, August 24, 2008 6:25 PMclatini Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    After installing the new Sql Server Express 2008 with tools and removing Sql Server Express 2005 i'm unable to create a new MDF file with 'Add/New Item.../SQL Database in the project 'App_Data folder'. The error is:

     

    "Connections to SQl Server files (*.mdf) require SQL Server Express 2005 to function properly...."

     

    Any ideas?

     

All Replies

  • Monday, September 01, 2008 4:02 PMStanley33 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Proposed Answer
    Sign In to Vote
    0
    Sign In to Vote
    I don't know if this will work for you but it worked for me. I opened Visual studio. Went to tools from the file menu then clicked options.Then from th options menu i checked show all settings and scrolled down the list to Database tools. Expanded it and click Data connections. I renamed the SQL Server Instance Name to the one i created when I installed SQL server 2008. Then click ok.

     

    • Proposed As Answer bysfdgdghrsef Sunday, March 15, 2009 8:41 PM
    •  
     
  • Sunday, March 15, 2009 8:43 PMsfdgdghrsef Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Stanley33 said:

    I don't know if this will work for you but it worked for me. I opened Visual studio. Went to tools from the file menu then clicked options.Then from th options menu i checked show all settings and scrolled down the list to Database tools. Expanded it and click Data connections. I renamed the SQL Server Instance Name to the one i created when I installed SQL server 2008. Then click ok.

     



    This works for me. I had installed my SQL Server 2008 Express instance as "SQLEXPRESS2008", so I guess Visual Studio could not find it until the above was set.