Windows Authentication and global.asa

From: Hugh Mungo (hugh_mungo_at_hotmail.com)
Date: 09/21/05

  • Next message: robertcp: "dbo permissions" 
    Date: Wed, 21 Sep 2005 08:48:49 +0100

    Hi

    I have an application written in classic ASP which uses Windows
    Authentication in SQL Server.

    This seems to work fine, except when we try to write to the database in
    Session_OnEnd in Global.asa

    We don't get an error and although logging is enabled in SQL Server, no
    failed logins are reported. Nevertheless, the database is not updated.

    I've tried adding the IWAM_Servername user to SQL Server, but that hasn't
    made any difference.

    Has anyone any thoughts on how to rectify this? At the moment, both SQL
    Server and IIS are running on the same PC, but we need to find a solution
    when they are on different PCs as well.

  • Next message: robertcp: "dbo permissions"

    Relevant Pages

    • Re: Windows Authentication in asp.net 2005 to SQL Server?
      ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
      (microsoft.public.dotnet.framework.aspnet.security)
    • Re: Remote connection failed
      ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
      (microsoft.public.sqlserver.connect)
    • Re: SQL Express MDF file moved from 1 computer to another - auth f
      ... I try to attach the database which is located in MyDocuments\Visual ... Microsoft SQL Server Management Studio ... now it tells me that authentication has failed for my windows ...
      (microsoft.public.sqlserver.connect)
    • Re: SQL Express MDF file moved from 1 computer to another - auth f
      ... I try to attach the database which is located in MyDocuments\Visual ... Microsoft SQL Server Management Studio ... now it tells me that authentication has failed for my windows ...
      (microsoft.public.sqlserver.connect)
    • Re: Changing passwords / Blocking SA login attempts
      ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
      (microsoft.public.sqlserver.security)