Build Error on TFS “The server was not found or was not accessible.” using Redgate for CI and CD int

yfrancisco

I am learning about how to integrate the databases in the continuous integration and deployment. I followed the examples on this two tutorials: Tutorial from Redgate Website, and this: Write Cool Code Blog, I created a simple project for test and I am working with a very simple script for the migrations that just add a new column to the table. When I run the Build I am getting the following error:

C:\Program Files (x86)\MSBuild\ReadyRoll\ReadyRoll.Data.Schema.SSDT.targets(146,5): Error : An error occurred while attempting to verify your deployment scripts: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Can someone help me with this problem? How can I fix this error?

Thanks.

Sergio R

Hi,

As the connection error is occurring during "attempting to verify your deployment scripts" it looks like the connection is failing to connect to the shadow database

Thank you,