SQL SERVER – Fix Visual Studio Error : Connections 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
Posted
by pinaldave
on SQL Authority
See other posts from SQL Authority
or by pinaldave
Published on Fri, 30 Nov 2012 01:30:47 +0000
Indexed on
2012/11/30
5:15 UTC
Read the original article
Hit count: 279
PostADay
|sql
|SQL Authority
|SQL Error Messages
|SQL Query
|SQL Server
|SQL Tips and Tricks
|T SQL
|Technology
|sqlcmd
|Visual Studio
In one of the virtual environment while I was trying to add SQL Server Database (.mdf) file to asp.net project I encountered following error:
Connections 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:
For a long time I am using SQL Server 2012 but this error was a bit interesting to me. I realize that there should not be any need of the SQL Server 2005 installation. I quickly figured out that I can remove this error if I do as mentioned below:
- Open Microsoft Visual Studio
- Select Tools >> Options >> Database Tools >> Data Connections
- Enter the name of an installed instance in “SQL Server Instance Name” field.
- Click OK
If you do not know the instance name, you can follow either of the options.
1) Use the command line sqlcmd utility
2) Using SQL Server Management Studio
Is there any other way to resolve this error?
Reference: Pinal Dave (http://blog.SQLAuthority.com)
Filed under: PostADay, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology Tagged: sqlcmd, Visual Studio
© SQL Authority or respective owner
