How to fix Visual Studio's error "This server version is not supported..." for SQL Server 2012

Question

I recently installed Visual Studio 2010 and SQL Server 2012 on a Windows Server 2008 R2 machine - (including all updates/Service Packs).

When attempting to work on a SQL Server database from within Visual Studio, VS throws the following error:

This server version is not supported. Only servers up to Microsoft SQL Server 2008 are supported

I recall getting this same error a while back (on a different computer) when I updated a SQL Server 2008 instance to SQL Server 2008 R2. The fix, back then, was to install (or reinstall) Visual Studio 2010 SP1.

Now that I'm receiving this error again (on a new computer), I thought it reasonable to reinstall VS SP1 just like I did a while back. However, doing so did not fix the problem.

It appears as though Visual Studio may need another update to support SQL Server 2012 instances.

For clarity, here are the steps that I did to produce the error: (using VS 2010sp1 and SQL2012)

1. Using VS, create a Windows Forms application
2. Right-click the project and choose, Add > New Item
3. Select "Service-based Database"
4. Cancel out of the "Data Source Configuration Wizard"
5. A Database will appear under your Project in Solution Explorer. Double-click the new database
6. The Database will be added to Server Explorer's list of Data Connections
7. In Server Explorer, open the database, right-click the Tables directory, then select "Add New Table"
8. The error "This server version is not supported...." is thrown

Screenshots for whatever its worth..

My question is, is there a fix for this? If so, what is it?

Solution 1

Maybe get SQL Server Data Tools, which work with SQL Server 2012? I believe there are some good tutorials and other materials in the Developer Training Kit. I don't think there are any tricks yet to make an older version of Visual Studio / Data Dude compatible with SQL Server 2012.

Solution 2

My problem was that I couldn't get VS2012 to work right with SQL Server 2012. I installed the latter product first, but after installing VS2012 and attempting to open an existing project, my existing data file just would not work. I know the software is supposed to automatically take you through a wizard to update your database in the project, but that didn't happen, and I couldn't find a way to make it happen. I'm on the point now of getting rid of SQL Server 2012 and going back to 2008. I'd rather use the most current releases, but I can't spend any more time on configuration issues.