.NET Core Linked Server SQL not recognized

I am having an issue troubleshooting what is wrong with this linked server that I set up in SQL.

This is what my setup looks like in SSMS

I am able to query things successfully inside SSMS like this

SELECT *
From [96.86.222.9].[8903_Interchange].dbo.Carline

However, when I am trying to run the project inside Visual Studio 2022. I am getting errors like this

So the first thing I did was go and check if the server was inside sys.servers as directed like this select * from sys.sysservers and it does return a result

and the stored procedure in question looks like this

CREATE PROCEDURE [dbo].[spInt_ListMakes]
AS
BEGIN
SELECT * FROM [96.86.222.9].[8903_Interchange].dbo.Manufacturer
END

Any help is appreciated. Thanks in advance