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

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)

About these ads

SQL SERVER – Fix : SQL Server 2008 Developer Edition Install fail due to .NET Framework 3.5 missing

It goes without saying that computer running slow is a common problem we all face, a pestering one indeed! Last week, I had to format my computer as it was running at an annoyingly tortoise pace. After formatting it, I installed Visual Studio 2008. When tested Visual Studio 2008 worked all fine. However, when I attempted to install SQL Server 2008, I was confronted with an error.

SQL Server 2008 Developer Edition Install fail due to .NET Framework 3.5 missing

For a couple of seconds, I was in a state of surprise, as I had Visual Studio 2008 and it worked absolutely fine; without .NET Framework 3.5 VS 2008 should have not worked. I had a hard time wrapping my head around this idea. I searched online for the solution and successfully found the following link, which clearly gave explanation to my probing mind. As CSS SQL Server Engineers have already explained it perfectly I will be not talking about the same again, but I recommend this as a good read.

SQL Server 2008, Visual Studio 2008 SP1, and .Net Framework 3.5 SP1 explained

If you have installed VS 2008, install VS 2008 SP1 as well.

Reference : Pinal Dave (http://blog.SQLAuthority.com)