Can u tell us what security options you discovered after upgrading from 2k to 2003. Coz when u will be having a distributed transactions having sql2005 in the os. it...
Please check for the @@servername for the server u are going to connect. Many times it is happeneing that the servername is null in the system but you anc login...