What are the challenges you face when working across database platforms? Take the survey

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

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?



  • Options

    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,
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.