Yes, but what is the login that you are using in the SQL Server registration properties in the EM?
Is that different to the one that you use when you use the Query Analyser?
Can you execute 'osql' to execute your tests and get an error? osql uses an ODBC connection, whereas the EM uses OLE DB.
Regards
Simon