Tag Archives: #sqlserver

Project contains an invalid database reference

October 30, 2016 by Wes MacDonald 0 Comments


If you have multiple developers working in a SQL Server Database Project and not all developers have applied the latest update they may see the following compilation error message for the System Database references: master and msdb. Project ‘[project_name].sqlproj’ contains an invalid database reference: ‘C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\Extensions\SqlServer\120\SqlSchemas\master.dacpac’.  You must update the reference so that […]

Continue reading →
SQL Server, Visual Studio
, , ,

TFS15 RC2 Upgrade with SQL Server 2016 AlwaysOn

October 29, 2016 by Wes MacDonald 1 Comment


Upgrading is very straight forward, improvements were done in .NET 4.6.1 related to the MultisubnetFailover and AlwaysOn.  Here is the section from the .NET team this blog post that is relevant for SQL AlwaysOn.  The connection string in TFS still sets MultisubnetFailover to true but it is no longer required any longer. Improve MultisubnetFailover connection […]

Continue reading →
SQL Server, SQL Server 2012, SQL Server 2014, SQL Server 2016, Team Foundation Server
, , , ,

TFS Install with SQL Server 2016 AlwaysOn

October 24, 2016 by Wes MacDonald 0 Comments


If you’re curious about the steps to install TFS with SQL Server AlwaysOn I will be going through them and it’s really very easy.  This blog post assumes the availability group and listener is already up and running. Windows Server 2016 One new features I loved was I could now use a Cloud Witness as […]

Continue reading →
SQL Server, SQL Server 2016, Team Foundation Server, Windows Azure, Windows Server, Windows Server 2016
, , ,