From: sunil on
Hi murali,

You can change the connection to trusted so that you dont have to use the password or you can create the same login with sysadmin role in the subscriber, that should solve the issue.

Do get back if its solved

Cheers

Sunil

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com