Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 20, 2013 03:53 PM by juanfelipecaro77
Jun 10, 2007 04:16 PM|LINK
I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.
I have two SQL Server instances installed.
1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)
But when i try to add a database to my VS website project I get the following error:
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=4925
I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)
and changed the "SQLEXPRESS" to "USERLT\SQL2005".
But I still get the same error message. Any ideas how i can resolve this issue?
Jun 10, 2007 04:44 PM|LINK
Attach the files to your SQL server instance using for example the SQL management Studio and change your connectionstring to connect into this database.
Jun 10, 2007 05:00 PM|LINK
Well the thing is that I dont have a database created yet. I am trying to create a new database. If i create a database in SQL 2005 then my connectionstring will point to the database on sql server. I need the database to reside in the VS project like a
stand alone .mdf file so that I can deply the database with my project.
Does that make sense? Thanks for your help.
Jun 12, 2007 09:16 AM|LINK
You may open your Machine.Config file (the file is in %SystemRoot%\Microsoft.NET\Framework\ver. number\CONFIG ). Try to find the ConnectionString node, modify the setting and make it look like
<add name="LocalSqlServer" connectionString="data source=UserLT\SQL2005;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" />
Mar 18, 2008 04:36 AM|LINK
Pasted above is the connectionStrings portion of my machine.config file. I changed data source=.\MSSQLSERVER from SQLExperess. However, I still cannot fix my issue. Am I using incorrect syntax?
Apr 30, 2008 03:54 PM|LINK
Hello, I just had SQL Server 2005 installed over my old SQL 2000 , and I am experiencing the same problem when I try to create a new mdf file in my App_Data. I am curious if anyone has the solution to this problem?
Aug 13, 2008 03:55 PM|LINK
no i couldn and still having the same problem. In fact it says "connections to SQL server files(*.mdf) requires sql server express 2005 to function properly. Please verify the installation of the component or download from the url:
http://go.microsoft.com/fwlink/?linkId=49251" .And i am using sql management studio 2005
Oct 03, 2008 04:18 AM|LINK
As far as i know a .mdf file is not supported by SQL Server 2005 only SQL Server Express.
Nov 03, 2008 08:53 PM|LINK
I tryed in Tools>Options>DataBase tools>Data Connection>Sql Server Instance Name as blank i.e, (blank for default)
And worked me fine..
Mar 15, 2009 11:38 AM|LINK
Replacing the entry in Machine.Config didn't work.
I found two copies of machine.config on drive c:\ I modified both entries by changing the server name. I still get exactly the same error.
Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly.
Of course, I also replaced the server name in the projects web.config file.
This is just bizarre. PS. The server I want to use is a SQL 2008 developer instance. All my *.config files refer to that.