Re: Webservice SQL logon fails on production IIS server

From: Martin Kulov (kulov_at_bezbokluk.abv.bg)
Date: 02/15/05

  • Next message: mjf: "Re: Error in XML document" 
    Date: Tue, 15 Feb 2005 23:17:16 +0200

    "Tim Baley" <TimBaley@discussions.microsoft.com> wrote in message
    news:06349AFC-1E99-4015-97A2-13E80230462F@microsoft.com...
    > Hi Martin,
    >
    > Yes, I can open any of the SQL Servers w/ Win integrated authentication in
    > Query Analyzer. The stored procedures I'm trying to expose are all
    > production code currently accessed (w/Win authentication) from an Access
    > frontend.

    Hi Tim,
    Strange but I may have missed something. In my first post I suggested to set
    an account for Anonymous access. My intent was actually to point out that
    the web service is running under account that has no rights to call the SQL
    server. When you are using Windows Authentication you just specify the way
    to access the IIS. It has nothing to do with the account under web services
    run at. Open Task Manager and see it for yourself. On WinXP it should be
    aspnet_iis.exe process which is running under ASP_NET account. On Win2003 -
    w3wp.exe under NETWORK_SERVICE. Both accounts do not have access to network
    resources by default. You can specify the account for the web services in
    the machine.config file using <processModel> tag and username and password
    attributes. Or if you are using Windows2003 you can create new application
    pool and specify account that has enough rights to access network resources.

    HTH, 

    -- 
Martin Kulov
http://www.codeattest.com
MCAD Charter Member
MCSD.NET Early Achiever
MCSD
  • Next message: mjf: "Re: Error in XML document"

    Relevant Pages