MS SQL Account

Results 1 to 4 of 4
  1. #1
    Apprentice mar_tin is offline
    MemberRank
    Jul 2005 Join Date
    SloveniaLocation
    13Posts

    MS SQL Account

    Hi,
    I have a really simple question that's bothering me for the whole day...when I installed MS SQL I chose the windows authentication mode, and if I understood this correctly the login for the MS SQL db are the windows user name and password...but I can't connect to the SQL db via ASP (for registration), I get this error:
    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
    [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '*****'.
    /conn.asp, line 48
    yes I'm using L2ASP for registration. One more thing, when I start L2Log.exe, CacheD.exe...it doesn't ask the 2nd time for the SQL login information and which db should it use...but what if these things change?
    Thank you in advance
    BTW: nice forum, with nice guides ;)


  2. #2
    Valued Member Sundh is offline
    MemberRank
    Jan 2005 Join Date
    swedenLocation
    119Posts
    check so you added right ip's etc in your asp config.

    PS : the l2asp reg page sux, sql injection can be done quite easy, recomend using php reg with sql injection block etc.

  3. #3
    Apprentice mar_tin is offline
    MemberRank
    Jul 2005 Join Date
    SloveniaLocation
    13Posts
    the ip is local 127.0.0.1, I'm trying to run this in LAN, and I know it sux but this is just for testing :P, I'll use a php reg page when I'll finish the testing :)

  4. #4
    Apprentice mar_tin is offline
    MemberRank
    Jul 2005 Join Date
    SloveniaLocation
    13Posts
    hmm that's weird, i haven't changed a thing and now it works...well then nvm



Advertisement