first try to do test connection through right click on linked server and test connection ... i think this problem come's because of wrong setting of connection