web service using asp.net problem
-
hi, i created a web service application and i added a web method on my .asmx file(this file will execute a sql command and will return a dataset). i also created a client where the dataset will be displayed in a datagrid my big problem is i don't know how to fix this error: An unhandled exception of type 'System.Web.Services.Protocols.SoapException' occurred in system.web.services.dll Additional information: Server was unable to process request. --> Login failed for user 'mycomputername\ASPNET'. can anyone tell me how to fix this? thanks!
-
hi, i created a web service application and i added a web method on my .asmx file(this file will execute a sql command and will return a dataset). i also created a client where the dataset will be displayed in a datagrid my big problem is i don't know how to fix this error: An unhandled exception of type 'System.Web.Services.Protocols.SoapException' occurred in system.web.services.dll Additional information: Server was unable to process request. --> Login failed for user 'mycomputername\ASPNET'. can anyone tell me how to fix this? thanks!
Hi This is because of Authentication problem.Do u have your service application and client appliction in the same machine? Please check all security properties of your Service application in IIS. M.Sendilkumar
-
hi, i created a web service application and i added a web method on my .asmx file(this file will execute a sql command and will return a dataset). i also created a client where the dataset will be displayed in a datagrid my big problem is i don't know how to fix this error: An unhandled exception of type 'System.Web.Services.Protocols.SoapException' occurred in system.web.services.dll Additional information: Server was unable to process request. --> Login failed for user 'mycomputername\ASPNET'. can anyone tell me how to fix this? thanks!
Hi there, IMO, the exception is originally thrown from the code of the web service when your service was trying to connect the SQl database. Here, perhaps you are using a trusted connection to connect to DB from the web service, and that can be the cause. There are a couple of ways to fix the error, for example you can use the SQL authentication instead by providing the username/password in the connection string, you can take a look at this KB[^] for more information. Also, another way to figure out what is actually happening is to look inside the inner exception of the SoapException, this document may help you out when developing web services: Debugging ASP.NET Web Services[^]
-
Hi there, IMO, the exception is originally thrown from the code of the web service when your service was trying to connect the SQl database. Here, perhaps you are using a trusted connection to connect to DB from the web service, and that can be the cause. There are a couple of ways to fix the error, for example you can use the SQL authentication instead by providing the username/password in the connection string, you can take a look at this KB[^] for more information. Also, another way to figure out what is actually happening is to look inside the inner exception of the SoapException, this document may help you out when developing web services: Debugging ASP.NET Web Services[^]
ahh...thank you so much! that helped me alot:laugh:
-
Hi This is because of Authentication problem.Do u have your service application and client appliction in the same machine? Please check all security properties of your Service application in IIS. M.Sendilkumar
yes i'm running my client and server on the same machine...yeah i think i have a problem connecting to my web service to my sql database. thank you!