I'm in the process of moving our database from SQL Server 2000 to a
new server running SQL Server 2008. During the transition, I need to
EXEC SQL commands on the new server from the old one.
On my WinXP workstation, I can run this command without a hitch:
isql -E -S NEWSERVER -d SANITIZED -Q "EXEC importation_FI"
However, running the same command on our old 2000 server gives me this
error:
isql -E -S NEWSERVER -d SANITIZED -Q "EXEC importation_FI"
Msg 18452, Level 14, State 1, Server MAESTROII, Line 1
+chec de la connexion. La connexion provient d'un domaine non approuvÚ
et ne
peut pas Ûtre utilisÚe avec l'authentification Windows.
DB-Library: Login incorrect.
Both isql are version 2000.80.194.0.
I was suspecting that the trusted connection was not working on the
old server so I made a mapped drive to the new server, but that didn't
change a thing. After an afternoon of googling for the solution, I'm
stuck!

Hopefully one of you might be able to point me in the right
direction...