i wrote the webservice and configured in our server and having access the service through the browser from another system also working fine, But i am trying to access the service through in my application creating the proxy and accessing methods of the webservice,
but it can't get the data from the remote sqlserver through the webservice.
this is for my connection string in web config:
<add key="ConnectionString" value="server=EVEREST;initial catalog=MRMv1;uid=sa;pwd=kk"/>
the following the error was shown to me:
Server was unable to process request. ---> Login failed for user 'sa'
but i can login to sqlserver using 'sa' user in the remote server.
how can i get the data from the remote server.
can you please guide to me.
thanks and regards
View Complete Post