Visual Studio 2010 and SQL Server 2012 server explorer integration

SQL Server 2012 Express is now available to download from this link.

After downloading it and installing it, I tried to integrate it into an existing project in Visual Studio through the Server Explorer, and got the following issue:

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

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

This is apparently a known issue, and happens when you right click on “Data Connections” in Server Explorer, and chose “Create New SQL Server Database”.

The workaround:

The work around is to create your database using Management Studio (Just the DB, not the actual schema).

Once it has been created, you can then “connect” to the database in Visual Studio’s Server Explorer:

Server Explorer Data Connections Add Connection

This will allow you to connect to the database created in Management Studio without any issues.

If you didn’t change it during installation, your instance name will be “.\SQLEXPRESS”.

 

Advertisements

4 comments

  1. I created the 2012 database in Management Studio, and was able to then connect to it in VS2010. However, that was all I could do. Trying to add a table in VS generated the same error as the original attempt to create the database.

    Any idea if there’s going to be a quick hotfix for this?

    • Hi Michael,

      I got the same issue – I’ll update this post when I get home later. I’m not sure if it will be patched anytime soon – bear in mind that VS 2011 is currently in Beta, so it might be that we have to all go over to VS 2011.

      I’ll download the VS 2011 Beta and give it a test later.

  2. Same problem here, I guess I will have to use SQL Management studio every time I want to create/amend a Table. It’s a JOKE.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s