SQL Job failing when one of the steps attempts to connect to another server
I have created a job where step 1 calls for the deletion of data from table1 on server "ucpdapps2". Step 2 calls to pull data from table5 on server "archive" and place it in table1 on server "ucpdapps2". When I run the job step 1 works but step 2 fails with the error 
I don't even have a user called UCPDAPPS2.
I think I figured it out. It kept bothering me the error kept showing the user as ucpdapps2$ and that no such user existed. So after some reading, the server creates itself as a user. So seeing how the job is run under that server I figured maybe that is the user name that must have rights in the archive server even though I linked the two servers to talk to one another. So I just added that user under the security/login tab under the archive server.
- Function vs. Stored Procedure in SQL Server
- How to correctly join two tables that each have Start Date and Stop Date columns?
- PHP XAMPP Config
- SQL select distinct with condition
- To get the previous record which is less than the given date and time
- Create OBJECT with column values as Key in Snowflake
- How to load multiline csv feature into MySQL
- SQL copying data with new foreign keys
- An arithmetic expression with a DATETIME value is invalid while using PreparedStatement with Arithmetic calculation in sql later
- space is not allowed after parameter prefix ':' in SpEL support in Spring Data JPA @Query definitions
- SQLAlchemy - Get query results in same order as IN clause
- SQL Grouping and Nested Concatenation
- Extract weekday, millisecond, microsecond, nanosecond from a date in Postgres
- How can I refer to a variable in postgresql dynamic SQL?
- How to pull width & height out of string?
- Add new columns without using Alter
- Get columns of index on DB2
- Athena Query - "NOT IN" slow performance
- SQL one to one relationship vs. single table
- How can I number the instance of a duplicate record?
- How to fix SQL for AWS Athena
- SQL SELECT query not working in mysql
- How can i insert/ select into a table and delete copied records from original table?
- How to convert oracle regex pattern into Databricks compatible version?
- Select min or max based on where duplicate value exists
- Incorrect syntax near '1'. Expecting ID, QUOTED_ID, or '.' Error with SQL Pivot
- WHERE clause pulling incorrect values
- Sql select all conversation by group
- Create an inline SQL table on the fly (for an excluding left join)
- How to execute raw SQL in Flask-SQLAlchemy app