Results 1 to 4 of 4

Thread: SQL server problem need help ---

  1. Feb 20th, 2003, 02:27 AM #1
    mylene_vbasic6
    mylene_vbasic6 is offline

    Thread Starter
    Member mylene_vbasic6's Avatar
    Join Date
    Jan 2002
    Posts
    61

    Smile SQL server problem need help ---

    hi guys,

    I'm using window2000 advance server with service pack 1... and SQL server.. my IIS is running ok...

    I already created a database in SQL server... and i have already created ASP pages..

    I already put the DSN in the ODBC.. but everytime i run it on my browser i kept getting this error..

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'TEST-WEBSERVER\IUSR_TEST-WEBSERVER'.

    test-webserver is the name of my server.. the connection is ok too that only problem i've got that errror everytime i run my ASP pages...

    but those program that i used acccess is running properly..

    hope someone can help me....
    Reply With Quote Reply With Quote
  2. Feb 20th, 2003, 03:55 AM #2
    swatty
    swatty is offline
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478
    Check how you connect to it through the asp pages.

    You need to give a known user and password to connect to the DB.

    Or add a user to the users on SQL server with the name of the webserver.
    Code:
    If Question = Incomplete Then
   AnswerNextOne
Else
   ReplyIfKnown
End If
    cu Swatty
    Reply With Quote Reply With Quote
  3. Feb 20th, 2003, 04:53 AM #3
    mylene_vbasic6
    mylene_vbasic6 is offline

    Thread Starter
    Member mylene_vbasic6's Avatar
    Join Date
    Jan 2002
    Posts
    61
    i'm running it on the server itself..
    Reply With Quote Reply With Quote
  4. Feb 20th, 2003, 05:14 AM #4
    swatty
    swatty is offline
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478
    This could be.

    I geuss the dsn is created with trusted connection to the server.
    So the nt user must be known in the sql-server .
    If a user is not known on the SQL side than the connection is restricted and this user cannot log in to the DB.

    I'd suggest you apply the user and password to the connection through code.

    If this sounds a bit to loose you could have a seperate dll which gets the name and password from some encrypted file and opens and closes the connection for you.
    Code:
    If Question = Incomplete Then
   AnswerNextOne
Else
   ReplyIfKnown
End If
    cu Swatty
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width