Login/Password Invalid

Results 1 to 6 of 6
  1. #1
    Apprentice CabalWings is offline
    MemberRank
    Oct 2011 Join Date
    11Posts

    Login/Password Invalid

    Hello people. Im having a touble to enter on my server.

    I'm using: Windows 7, Centos 5.4 TDP 2.8.1, Putty, VMWare 7.1.4, WinSCP .

    All database is CONNECTED SUCCESSFULLY.
    All IP's Changed (Server list, Internal, Maiindex, Language.enc)
    All ip's setup done, I can enter Putty, WinSCP, MSSQL and make configs with no problems.

    But when I try to connect to my server, I type login/password and its says its wrong. I've created 5 Logins, only number, only letters, mix of both. Nothing goes on. I just can't enter on the game.

    I've reconfigured over and over again, but on the end its all the same.
    I even change Centos 4.8 to 5.4 TDP 2.8.1. and no results!

    Can someone help me?


  2. #2
    Banned Yamachi is offline
    BannedRank
    Oct 2006 Join Date
    Jolly EnglandLocation
    3,517Posts

    Re: Login/Password Invalid

    Are you using dbo.cabal_sp_toolRegisterAccount to create an account?

  3. #3
    Apprentice CabalWings is offline
    MemberRank
    Oct 2011 Join Date
    11Posts

    Re: Login/Password Invalid

    No. I'm using this one: exec dbo.cabal_tool_registerAccount.

    Maybe my database is outdate, there is somewhere that I can find new data files?

    Ty for your atention!

  4. #4
    Banned Yamachi is offline
    BannedRank
    Oct 2006 Join Date
    Jolly EnglandLocation
    3,517Posts

    Re: Login/Password Invalid

    Quote Originally Posted by CabalWings View Post
    No. I'm using this one: exec dbo.cabal_tool_registerAccount.

    Maybe my database is outdate, there is somewhere that I can find new data files?

    Ty for your atention!
    That's the one I meant, sorry. I was just pulling the name off of the top of my head. Anyways, make sure that your client is actually connecting to your own server and not someone else's.

  5. #5
    Apprentice CabalWings is offline
    MemberRank
    Oct 2011 Join Date
    11Posts

    Re: Login/Password Invalid

    There is somewhere in the Launcher that I need to change IP? or Ip's just need to be changed on Server list, Internal, Maiindex, Language.enc ?

  6. #6
    The Dinosaur chumpywumpy is offline
    MemberRank
    Jun 2008 Join Date
    /f451/Location
    5,127Posts

    Re: Login/Password Invalid

    It's probably MD5, have I not responded to these types of posts enough times for somebody to know how to check and fix? Sheesh

    Paste this into a query window and run it, tell me the results. Use BuHTuK's fix if the xp_md5.dll check fails.

    Code:
    Declare @insname varchar(25)
    if convert(varchar(25),serverproperty('instancename')) is null
      set @insname='MSSQLSERVER'
    else
      set @insname=convert(varchar(25),serverproperty('instancename'))
      select @insname as 'Instance',
      serverproperty('productversion') as 'Ver', serverproperty('productlevel') as 'SP',
      serverproperty('edition') as 'Edition'
      if @insname<>'MSSQLSERVER'
      begin
        select 'THIS IS BAD! You must reinstall MSSQL. Please follow the guides next time.' as 'MSSQL is a named instance!'
      end
    
      begin
        Declare @inspath varchar(10),@reg varchar(100),@tcpremote as int
        EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
        @key='Software\Microsoft\Microsoft SQL Server\Instance Names\SQL\',
        @value_name=@insname,
        @value=@inspath OUTPUT
        set @reg='Software\Microsoft\Microsoft SQL Server\' + @inspath + '\MSSQLSERVER\SuperSocketNetLib\tcp\'
        EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
        @key=@reg,
        @value_name='Enabled',
        @value=@tcpremote OUTPUT
        select @inspath as 'Instance path',@tcpremote as 'Remote connections enabled?'
        if @tcpremote='0'
          begin
            EXEC master.dbo.xp_regwrite @rootkey='HKEY_LOCAL_MACHINE',
            @key=@reg, @value_name='Enabled', @type='REG_DWORD',@value=1
            select 'I enabled remote connections ! Please reboot !' as 'Remote connections checker'
          end
        else
          begin
            select 'This is good! I have nothing to do :(' as 'Remote connections checker'
          end
        select account.dbo.fn_md5('test') as 'xp_md5.dll check'
      end



Advertisement