20

I downloaded MS SQL Server 2014 Enterprise Edition from MSDN. I want to do a server backend in C# and MS SQL, but the problem is, whenever I want to do something with DB in Visual Studio 2013 Ultimate it just tells me this

===================================

An incompatible SQL Server version was detected. (Microsoft.VisualStudio.Data.Tools.SqlEditor)
------------------------------
Program Location:

   at Microsoft.VisualStudio.Data.Tools.SqlEditor.DataModel.SqlConnectionStrategy.ValidateConnectionForEditor(UIConnectionInfo ci, IServerType server)
   at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Honestly, I don't know what is going on, or why tells me that VS is incompatible with SQL server.

C Perkins
  • 3,572
  • 3
  • 23
  • 34
Citrus
  • 1,162
  • 1
  • 15
  • 37

4 Answers4

44

You should update SSDT to 2014, you can download it here:http://msdn.microsoft.com/en-us/data/hh297027

Read more about support for SQL Server 2014 on this blog: SQL Server Data Tools for SQL Server 2014 is available

From the post:

For Visual Studio 2013 download check the Visual Studio update channel (Tools –> Extensions and Updates –> Updates) for this update.

Hope this helps

Milica Medic Kiralj
  • 3,540
  • 28
  • 30
12

I'm guessing that your VS2013 isn't fully updated and that you need to update the database tooling component (SSDT) for SQL2014. I posted an answer on this a couple of days ago with some instructions.

Look at the Extensions and Updates in VS2013 and there should be an update available for SQL Server Data Tools.

Community
  • 1
  • 1
jpw
  • 43,521
  • 6
  • 61
  • 82
3

SSDT didn't have support for SQL Server 2014 until a release in Oct2013.

Update your SSDT here http://msdn.microsoft.com/en-au/data/tools.aspx

g2server
  • 4,727
  • 3
  • 27
  • 36
2

Until late January only SQL Server 2014 CTP was available (Community Technology Preview) and not as a RTM; which was not supported by tools like Visual Studio.

But now new Data tools are available, you can download the same and upgrade to it.

Get it from here http://msdn.microsoft.com/en-us/data/hh297027

Rahul
  • 73,987
  • 13
  • 62
  • 116