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
In mid-dec 2015 Microsoft released an update to Visual
Studio 2015 Data Services (link) where it made possible to deploy to SQL SERVER