Database project deploy fails in Visual Studio 2013

Question

I have a database project in a solution which will not deploy from Visual Studio 2013. It fails with an error message "Unable to connect to target server".

The same project, when opened in Visual Studio 2012 deploys without an issue.

The database is Sql 2012 hosted in a Sql 2014 engine (express)

The deployment settings are thus (with names changed to protect the innocent):

<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="12.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <IncludeCompositeObjects>True</IncludeCompositeObjects>
    <TargetDatabaseName>TestDatabase</TargetDatabaseName>
    <DeployScriptFileName>TestDatabase.Database.sql</DeployScriptFileName>
    <TargetConnectionString>Data Source=.\SQL2014;Integrated Security=True;Pooling=False</TargetConnectionString>
    <ProfileVersionNumber>1</ProfileVersionNumber>
  </PropertyGroup>
</Project>

I have also tried the deployment with using a username and password rather than Integrated security...

Answer 1

Visual Studio 2013 now has an update that adds SQL Server 2014 support under Tools –> Extensions and Updates –> Updates

After installing the update under Help -> About Microsoft Visual Studio I see I now have SQL Server Data Tools 12.0.40403.0

Now SQL Server 2014 is an option in my database project settings and everything works!

---

Original Response:

I have the same problem. It looks like the update for Visual Studio 2013 isn't out yet :(

In the next few days the Visual Studio 2013 download will appear through the Visual Studio update channel (Tools –> Extensions and Updates –> Updates).

http://blogs.msdn.com/b/ssdt/archive/2014/03/25/sql-server-data-tools-for-sql-server-2014-is-available.aspx