Do a tnsping to the sqlserver database and check if it is connecting.
If it is connecting then do a select * from ps_len_tmp@SQLSERVErlink