Connecting to SQL through ASP

From: Ann (williaj_at_rrb.gov)
Date: 04/30/03

  • Next message: Ken Schaefer: "Re: Connecting to SQL through ASP" 
    Date: 29 Apr 2003 21:15:53 -0700

    Guys I need your help.

    I think i have followed the instructions for connecting to SQL Server
    when IIS and SQL are on different machines, but I still get error,
    Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. What am I
    missing?

    IIS 5.0 machine running on win2000 pro
    Anonymous account IUSR_MACHINENAME was given password
    Authentication Method for the web was set to:
    Anonymous is not checked
    Basic is checked
    Integrated is checked

    SQL 7.0 machine running on win2000 pro
    Created local account with same name (IUSR_MACHINENAME) as IIS
    anonymous account and same password
    Gave this account log on locally rights and Access this computer from
    the network rights
    Added new login IUSR_MACHINENAME in SQL Enterprise manager and mapped
    it to the local account I created above
    Added this login to the database I want to access
    My connection string is:
    "Provider=SQLOLEDB.1;Initial Catalog=XXXXXXX;Integrated
    Security=SSPI;Data Source=XXXXXXX"

    Can anyone help????

    Thanks
    Ann

  • Next message: Ken Schaefer: "Re: Connecting to SQL through ASP"

    Relevant Pages

    • Domain user cannot connect with integrated security
      ... We noticed a SQL process on our development SQL server (SQL 2k, ... I asked the user to use integrated security and not the local account - ... The domain user who is connecting is a member of a local group on the ...
      (microsoft.public.sqlserver.security)
    • Re: IIS 6.0 and SQL server
      ... domain account, or it needs to be a local account on both machines with ... should be true both if you are using Windows authentication in SQL, ... if you are using SQL authentication in SQL but the SQL client on the IIS ...
      (microsoft.public.inetserver.iis.security)
    • RE: Which account on SQL 2005 web sync via https
      ... Well - to take a stab in the dark on this one, it seems the account you are ... permissions when you are running in a domain environment. ... Configure a Publication to Allow for Web Synchronization (SQL ... Configure IIS for Web Synchronization ...
      (microsoft.public.sqlserver.replication)
    • Re: kerberos the story so far
      ... I have put the IIS machine into a local group and assigned it owner in the ... One the I have noticed is that running the AuthDiag tool on the SQL box says ... where my IIS front end server could not obtain a kerberos ... > It looks like you registered the SPN for the SQL service user account. ...
      (microsoft.public.win2000.active_directory)
    • Re: IIS & SQL, dedicated user account & GPO
      ... I am setting up a dedicated IIS server for hosting a site that will use data from a SQL DB on the SBS server. ... a dedicated domain user account is the securest way to allow IIS to access SQL without a lot of maintenance. ...
      (microsoft.public.windows.server.sbs)