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?
Attach the files to your SQL server instance using for example the SQL management Studio and change your connectionstring to connect into this database.
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.
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
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?
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?
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
dotNet_Stude...
Member
386 Points
156 Posts
connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.
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?
smiling4ever
All-Star
15825 Points
3123 Posts
Re: connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.
Jun 10, 2007 04:44 PM|LINK
Hello,
Attach the files to your SQL server instance using for example the SQL management Studio and change your connectionstring to connect into this database.
dotNet_Stude...
Member
386 Points
156 Posts
Re: connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.
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.
Nai-Dong Jin...
All-Star
41630 Points
3558 Posts
Re: connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.
Jun 12, 2007 09:16 AM|LINK
Hi,
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" />
Thanks.
SidC
Member
44 Points
141 Posts
Re: connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.
Mar 18, 2008 04:36 AM|LINK
<
add name="LocalSqlServer" connectionString="data source=.\MSSQLSERVER;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" /></
connectionStrings>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?
Thanks,
Sid
sid@webdbapps.net
elephanted
Member
49 Points
19 Posts
Re: connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.
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?
Thanks.
priyab@s
Member
2 Points
1 Post
Re: connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.
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
azpoulton
Member
3 Points
4 Posts
Re: connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.
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.
bnsp4u
Member
4 Points
1 Post
Re: connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.
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..
mark4asp
Member
167 Points
232 Posts
Re: connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.
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.