Yes i am able to connect using Sumit_Test login.

I have also tried using actual value rathe than place holders. Its still the same.

Thanks for a prompt reply.

I have tried using the non 'sa' connection resulting in the error.

This is what i am using as my connection string:

"provider=SQLOLEDB;uid=sa;pwd=sabidev;server= "

I also...