RE: Problem With Web Service

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

Please answer few questions below:

Do the web service is implemented in a different project or in the same web
application?

Do you use windows authentication for connecting to the sql server?

Do you use impersonation in the web application?

If the web service is implemented in a different project and you use windows
authentication and impersonation in the web application, check if you have
enabled the impersonation in the web service application.

--
Saravanan K V


"Wayne Wengert" wrote:

> I created a simple web service that returns a dataset containing the city
> and state when the GetZIP function is called with a zip code as the
> parameter. When I test the web service by opening the asmx file I get an
> error "System.Data.SqlClient.SqlException: SQL Server does not exist or
> access denied."
>
> I am using the same database connection string that my aspx pages do and I
> have double checked that it is correct. Is there some special permission
> required for an asmx page to access an sql server?
>
> Wayne
>
>
>
.

Relevant Pages

  • Re: integrated security over vpn
    ... Are you using Windows authentication with SQL Server or SQL Server ... If you are using Windows authentication, then the current app needs to be ... You could create a web service that returns and accepts the ...
    (microsoft.public.dotnet.security)
  • Re: Security issue with win integrated authentication
    ... It's #1 and both web app and web service are using impersonation. ... >> configured in SQL server to access data.this user A doesn't belong to ...
    (microsoft.public.dotnet.security)
  • Re: integrated security over vpn
    ... > SQL 2000 is using Windows Authentication, and I can access tables, Stored ... >> Are you using Windows authentication with SQL Server or SQL Server ... >> easy to do on a home machine scenario as I would expect the home machine ... You could create a web service that returns and accepts the ...
    (microsoft.public.dotnet.security)
  • Re: Getting user ID from Web Service credentials
    ... Windows Authentication in IIS, when Anonymous access is turned off. ... System.Net.CredentialCache.DefaultCredentials on the client side. ... >> any way to get the user name from the Web Services code. ... >> For both the client side caller and the Web Service, ...
    (microsoft.public.dotnet.security)
  • IIS Web Service 401 Error with Integrated Windows Authentication
    ... I built a simple "Hellow World" Web Service that I ... can successfully invoke using IE (regardless of the authentication type ... I can invoke the same Web Service by another client successfully if the ... However, if the Integrated Windows Authentication is ticked, invoking the ...
    (microsoft.public.dotnet.framework.aspnet.security)