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

Scarleth

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.

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?