This is a quick blog to help others avoid what I went through while trying to deploy a DB from TFS to SQL Server 2016 with no success.

 

Apart from the usual option of backup/restore there was no other viable way of deploying through source control. Visual Studio would throw an “unable to connect to target server” error despite the connection being successfully tested.

 

 

 

In mid-dec 2015 Microsoft released an update to Visual

Studio 2015 Data Services (link) where it made possible to deploy to SQL SERVER 2016.