Wednesday, December 31, 2008

Connection to SQL file *.MDF requires SQL Server 2005 to function properly.

PROBLEM DESCRIPTION
============================================
Getting below error message while trying to add Data from SQL Express 2008 DB through Visual studio 2008

ERROR MESSAGES:
============================================
Connection to SQL file *.MDF requires SQL Server 2005 to function properly.

Environment:
============
64 bit SQL Server
64 bit OS
32 bit Visual studio

Reference Links
============================================
http://blogs.msdn.com/sqlexpress/archive/2008/10/02/faq-error-creating-a-service-based-database-in-visual-studio-2008-sp1.aspx
http://support.microsoft.com/KB/957944

Resolution:
=============
Apply the hot fix mentioned in this KB http://support.microsoft.com/KB/957944