How configure a Linked Server in source control for Build artefact with SQL Change Automation?
Scarleth
Posts: 2 New member
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.
Tagged:
Answers
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?
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?