How can we help you today? How can we help you today?

How configure a Linked Server in source control for Build artefact with SQL Change Automation?

RedGate.Versioning.Automation.Shared.Errors.TerminatingException: 40 batches failed. The first error is 'Could not find server '' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.' ---> System.AggregateException: 40 batches failed. The first error is 'Could not find server '' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.' ---> System.Data.SqlClient.SqlException: Could not find server '' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Scarleth
0

Comments

1 comment

Sort by
  • DanC
    Hi @Scarleth

    Sorry to see you're getting an issue with SQL Change Automation!

    Can I ask are you using -TemporaryDatabaseServer that has the linked servers setup?
    DanC
    0

Add comment

Please sign in to leave a comment.