Error while trying to use the web service

  • Thread starter Thread starter Newto Testing via .NET 247
  • Start date Start date
N

Newto Testing via .NET 247

(Type your message here)
I got the following error:

System.Web.Services.Protocols.SoapException occurred in system.web.services.dll.

Additional Information: System.Web.Services.Protocols.SoapException: Server was unable to process request. --> System.Data.SqlClient.SqlException: Login failed for user 'administartor'.

Can anyone please help?
 
Calling from a web application? If so, you either need to:

A. Completely destroy security in your system by allowing the ASP.NET user
(either Network Service (Win 2003) or IUSR_ComputerName) access to your
database server. I am not fond of this approach, although I have seen plenty
of people who love this approach, as it is easy (at least when the web app is
on the same server).

B. Force users to log in by removing anonymous access. This forces a windows
login. A good choice for all but Internet applications.

C. Switch to a connection string that using SQL login. This is not as
secure, but is not dumb like A.

D. Place your data access layer into a container that allows assignment of a
user account, like COM+.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
 
Back
Top