Re: accessing database from webservice

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: kenneth fleckenstein nielsen (kennethfleckensteinnielsen_at_discussions.microsoft.com)
Date: 01/07/05


Date: Fri, 7 Jan 2005 01:53:03 -0800

I've enabled IIS's integrated windows authe.. on the specific webservices
directory security, on the customers server and nothing changed. I think that
will affect the connection string as you said it could be, but I'm not
connecting myself i rely on a thirdparty product and that doesn't log on
there.

"Dilip Krishnan" wrote:

> Hello kenneth,
> Check if you are using integrated security in the connection string. That
> would most probably be the problem
>
> HTH
> Regards,
> Dilip Krishnan
> MCAD, MCSD.net
> dkrishnan at geniant dot com
> http://www.geniant.com
>
> > I'm trying to let my webs ervice access a database, from non public
> > site. It
> > works on my local maschin and on a test server i setup. but i doesn't
> > work on
> > the customers machine, when i log on to the database the user is
> > refused. but
> > i can logon with him from gui.
> > I presúme that the problem is the setting up of iis or with the access
> > right
> > to the db, basically i wan't any anonymis user ot have all the rights
> > he
> > wants.
> > What nob's can i turn on to affect the access right to a db from a
> > webservice?
> > the web.config file
> > IIS the directory ?
> > Windows the users ?
>
>
>



Relevant Pages

  • Re: connection sql server with asp.net
    ... On directory security, click ... account is created in Windows by Microsoft .NET Framework. ... To be sure of using the correct connection string syntax, ... To get the udl file to open, create a blank textfile named as ...
    (microsoft.public.sqlserver.connect)
  • Re: Cant connect to DB
    ... Switch off anonymous access on Directory Security tab ... Windows user name and password. ... Sandy ... >have you tried with this connection string? ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • perplexing SQL authentication from ASP.net issue
    ... directory security is set to Integrated Windows Authentication only. ... MS SQL is set to accept both Windows and SQL ... SQL Server connection. ... I then built a connection string from a blank .udl file: ...
    (microsoft.public.sqlserver.security)