Re: SQL server acess from ASP.NET

From: Som (Somsubhra_ghosh@satyam.com)
Date: 09/13/02 

From: "Som" <Somsubhra_ghosh@satyam.com>
Date: Fri, 13 Sep 2002 12:26:08 +0530

Greetings.
I understand you have completed the steps indicated by Mark.

1> Have you set the Impersonation = True in the Web.config
<authentication mode="Windows" />

<identity impersonate="true" />

and check if
2> in the machine.config the comImpersonationLevel is attribute is set to
"Impersonate"

 <processModel
            enable="true"
            timeout="Infinite"
            idleTimeout="Infinite"
            shutdownTimeout="0:00:05"
            requestLimit="Infinite"
            requestQueueLimit="5000"
            restartQueueLimit="10"
            memoryLimit="60"
            webGarden="false"
            cpuMask="0xffffffff"
            userName="system"
            password="Autogenerate"
            logLevel="Errors"
            clientConnectedCheck="0:00:05"
            comAuthenticationLevel="Connect"
            comImpersonationLevel="Impersonate"
            responseRestartDeadlockInterval="00:09:00"
            responseDeadlockInterval="00:03:00"
            maxWorkerThreads="25"
            maxIoThreads="25"
        />

"Eugene N Agafonov" <gollum@zmail.ru> wrote in message
news:ednAWluWCHA.1976@tkmsftngp11...
> Greetings!
>
> Well situation has become more clear: when i put my application on same
> machine with SQL server, It works ok. So the problem appears, when SQL and
> asp.net application are on different machines. How to pass impersonation
to
> the remote computer? I would appreciate _any_ hints much.
>
> WBR,
> Eugene
>
>

Relevant Pages

  • IIS / SQL Server impersonation
    ... I am attempting to implement impersonation from a windows application ... I have configured the host virtual directory in IIS to require windows ... the database permits Windows Authentication. ... When I try and open a connection to SQL Server: ...
    (microsoft.public.dotnet.security)
  • Re: Login failed for user NT AUTHORITYANONYMOUS LOGON
    ... Is the SQL server box in the same domain as the web server (or do they have ... went wrong with your impersonation. ... > I have a local webservice and I was to use to access a SQL server on their ... > of the domain user in the web.config. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Permission required to execute a DTS package from ASP.NET applicatio?!!
    ... Yes,I've enabled impersonation in my application and that's why it is under ... > does SQL server is on the same server as your ASP.net application? ... >> I'm calling a DTS package from my asp.net application.Apparently because ... >> of the current security context and it is my Domian user name and I'm ...
    (microsoft.public.sqlserver.dts)
  • RE: Connect to database after windows impersonation.
    ... I would turn on Profiler with a filter to look at the particular database. ... > has admin rights on the SQL server box and the SQL Server itself. ... > //do the impersonation by calling am method in the class Impersonation I ... > specify a SQL Login in the connectioon string, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Login failed for user MachineNameASPNET
    ... > Or is your SQL Server not on the same network? ... > Really impersonation is the best way, but I do remember a Visual Studio ... >> windows authentication to log into the site, ... >> programmatically override asp.net from providing the MachineName\ASPNET ...
    (microsoft.public.dotnet.framework.aspnet)