Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Location
    London
    Posts
    3

    Unanswered: Logging on with SA account!!

    I am attempting to connect to SQL7.0 via the SA account via an ASP page and having the message:

    Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'WRIGHT\IUSR_WRIGHT'.

    Any ideas?

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    This is the anonymous login that IIS uses. Right click on default web site under Internet Services Manager. Click on properties -> Directory Security tab -> Click Edit under the Anonymous access-> Click Edit under the Anonymous access -- you will see this user name.

  3. #3
    Join Date
    Jan 2002
    Location
    London
    Posts
    3
    Thanks very much...

    so simple when you know how!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •