I have created a linked server and wish to execute a job that queries the linked server and writes the result in a local database.Ihave tested the connection to the linked server and it was fine. I was also able get results by running a query in a new editor window. However, when I run the T-SQL command, it fails with invalid login credentials, why is that?
when creating the linked server, I chose the option of using the current login context to login to the remote server.
Any help would be appreciated.