In SQL Server Enterprise Manager, I attempted to create new server
registration under SQL Server Group, and connect to a remote SQL Server, but
it had connection error. It says the user id and password problem.

When I use SQL Server DTS, it had the same problem.

However, when I used SQL Query Analyzer, I was able to connect to the remote
SQL Server.

Any ideas?? Setting problems in Enterprise Manager and DTS??

Please advise. Thanks!

Matthew,

What is the exact error you are getting?

Rand
This posting is provided "as is" with no warranties and confers no rights.