connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly

hello,

i've installed SQL server 2005 express and Visual web developper 2005 express.

when i whant to create a database in VWD the following error occures:

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/ linkId=49251

i searched the internet but can't find the solution, i already reinstalled my complete workstation but the problem stays.

please help!



Answer this question

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly

  • Saraav

    go to database explorer-data connections.

    right click your mdf database and click "modify connection"...

    click the advanced button

    search for the "data source" string

    change the string from .\sqlexpress to .\sqlexpress2005

    that worked for me. that's because you installed sql express 2005 as a named instance while the connection string referred it as the default one.


  • connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly