Login problem

Results 1 to 4 of 4
  1. #1
    Newbie piratenaapje is offline
    MemberRank
    Jul 2010 Join Date
    16Posts

    Login problem

    I'm having some troubles running the Login server: it asks me for a username and password. Whatever combination I try, it won't accept it. I've tried using sa with blank password, sa together with the password I used to install mysql (which does work in ODBC), and my windows login. All to no avail.

    I'm at a loss here, what should I be trying next? For reference: I'm using windows 7 64-bit and mssql 2000.
    http://imgur.com/BpK7o.png
    http://imgur.com/iSOFj.png
    http://imgur.com/Jq05j.png

    EDIT:

    DIAG [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application (0)

    Is what I get when I try to login... (this is what's written in the SQL.log file when I turn logging on) So I guess the problem is mssql2000. Any suggestions and what mssql versions work with windows 7 64-bit?
    Last edited by piratenaapje; 02-07-10 at 01:28 AM.


  2. #2
    Infraction Banned 207Kal is offline
    MemberRank
    Jun 2010 Join Date
    12Posts

    Re: Login problem

    2000 is fine.. reinstall sql add password, and remember it

  3. #3
    Newbie piratenaapje is offline
    MemberRank
    Jul 2010 Join Date
    16Posts

    Re: Login problem

    Quote Originally Posted by 207Kal View Post
    2000 is fine.. reinstall sql add password, and remember it
    You seem to be unable to read, the problem was 64-bit ODBC in combination with a 32-bit application. Using the 32-bit ODBC version fixed it.

  4. #4
    Banned EvolutionKal is offline
    BannedRank
    Sep 2007 Join Date
    SpaceLocation
    525Posts

    Re: Login problem

    dint use a 64-bit wersion but on 32 if u install u server and dint put a pass the login id is sa and the server for mssql 2000 is localhost
    but beter use msql2005 and 32bit pc and put a pass for server wen u install ;)



Advertisement