Error from VS2008, requiring SQL Server 2005, refuses to acknowledge SQL 2008
Posted on 2009-04-26
I'm using Visual Studio 2008 SP1, trying to create a Web Project. When I attempt to add a new SQL database (an 'mdf' file), I get the message "Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly."
I have SQL Server 2008 installed. I have set my instance in Tools->Options->Database Tools->Data Connections->SQL Server Instance Name to point to 'newdell1\sqlserver2008'.
I have been all over the web and MSDN to try to find a solution, but I can't seem to find one.
The Server Explorer in VS2008 allows me to work directly with SQL Server 2008. I just can't get the Sql Server database file template to create a SQL Server 2008 mdf.