Hello, I'm having trouble running a query in one SSMS database which sources data from a linked server. The connection to the linked server is functioning, in that I can run the view successfully from within the source. The error I'm getting after a few minutes is 'Could not open a connection to SQL Server '.
I'm assuming that my windows authentication to access the source database is all that's needed or do I have to code this into the query despite it being a functioning linked server?
The code is...
SELECT * FROM OPENQUERY(remoteserver, 'SELECT TOP (10) field
What am I missing?