We NAILED the issue,it was a simple one.The problem was that the SQL Server DB user was not provided with EXECUTE priviledges beacuse of which it was throwing exeception...
Lowell, I really appreciate that you have shared your experience.But,as put in my post I am able to execute the query and on Offshore environment but the same is not...