Database Connectivity Error

Results 1 to 3 of 3

Thread: Database Connectivity Error

  1. #1
    Join Date
    Dec 1969

    Default Database Connectivity Error

    When Windows NT Authentication is given the site displays expected output BUT When Anonymous access is given in Internet Service Manager to the Default Web Site the Database Connectivity using DSN / PROVIDER for SQL SERVER 7 fails. Username provided as a part of connection string is &#039;SA&#039;.<BR><BR>The Error Message is as under :<BR><BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)<BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user &#039;SYSTEM8IUSR_SYSTEM8&#039;.<BR>/engineering1/engg/Uni_list.asp, line 12<BR><BR>Please mail me the possible modifications required for smooth functioning of the connection.

  2. #2
    Join Date
    Dec 1969

    Default Yes. That *is* an error message.

    But, without seeing the code & connection string you are trying to use - we can&#039;t help.<BR><BR>-Doug

  3. #3
    Join Date
    Dec 1969

    Default RE: Database Connectivity Error

    Well, unless you set it otherwise, IIS lets you see<BR>the Web pages it manages as you was on the machine<BR>(more or less), and logged in as IUSR_MACHINENAME;<BR>that way, you should set IUSR_SYSTEM8 (in your case)<BR>as a valid user of the DB you&#039;re trying to access.<BR><BR>Hope this helps,<BR>Graz

Posting Permissions

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