Reitse Eskens troubleshoots a linked server error:
This morning started with a bit of a nuisance. I got a message from one of our customers that a night job failed with an error.
First thing i checked after logging in was if the database and table exist on the server. Because the error states that de table doesn’t exist on the database or that there are insufficient rights. The table exists and the user to connect to the database has the rights to do so.
That didn’t do the job, so read on to see what the cause and solution were.