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