This may or may not be relevant. But...

Glancing through the error message it appears your are attempting to link to server "(null)", this is in the error message twice.

Are you adding the linked server through SSMS or script?

SSMS - [Server Objects] - [Linked Servers] - [Providers]

good luck