[Help] Subserver issues (2 PC - 1 DB)

Results 1 to 4 of 4
  1. #1
    RZ's most loyal knight Dios is online now
    ModeratorRank
    Apr 2005 Join Date
    ArgentinaLocation
    5,241Posts

    [Help] Subserver issues (2 PC - 1 DB)

    I rented a second server yesterday as the other one I have is almost full all day long. I installed everything on both computers, installed SQL 2005 on both and created server in one like I always do. This server works like a charm. Now, when I need to create the other server I create the ODBC's and make them point to the other computer, press TEST and its success

    Microsoft SQL Server ODBC Driver Version 03.86.1830
    Running connectivity tests...
    Attempting connection
    Connection established
    Verifying option settings
    Disconnecting from server
    TESTS COMPLETED SUCCESSFULLY!
    The config shows:

    Microsoft SQL Server ODBC Driver Version 03.86.1830
    Data Source Name: MuOnline
    Data Source Description:
    Server: (ip) ^^
    Database: MuOnline
    Language: (Default)
    Translate Character Data: Yes
    Log Long Running Queries: No
    Log Driver Statistics: No
    Use Integrated Security: No
    Use Regional Settings: No
    Prepared Statements Option: Drop temporary procedures on disconnect
    Use Failover Server: No
    Use ANSI Quoted Identifiers: Yes
    Use ANSI Null, Paddings and Warnings: Yes
    Data Encryption: No
    I can see the database from Server 2 if I open SQL Server Management Studio, so the connections are open. I only allowed tcp/ip, should I allow pipes 2?.

    When I run link 1 I get:

    SQLState:'28000' Error de SQL Server:'18456' [Microsoft][ODBC SQL Server Driver][SQL Server]Error de Inicio de Sesion del usuario 'Admin' (Means error loging to the session Admin, the typic not trusted user error)
    but my sql user isnt Admin, its 'sa'!

    When I go to sql error logs I get:

    2007-07-18 19:38:37.84 Login failed for user 'admin'. [CLIENT: (ip)^^]
    2007-07-18 19:38:38.65 Error: 18456, Severity: 14, state: 5.
    I googled and found that State 5 is Invalid userid and I know that "admin" isnt my user. Sa is my user but I cant find a way to change that admin to SA => I cant have a subserver.

    The config is:

    All ips in mu config point to Server 1
    All ODBC Point to server 1

    Any help? I feel pretty depressed. I've being hosting for over 2 years and made several subs but this bitch refuses to work!

    After the sql error I mentioned I get:

    EventDBset ODBC Connect Failed
    GSDBeset ODBC Connect Failed
    Last edited by Dios; 19-07-07 at 05:00 AM.


  2. #2
    Account Upgraded | Title Enabled! nightcor3 is offline
    MemberRank
    May 2007 Join Date
    DenmarkLocation
    710Posts

    Re: [Help] Subserver issues (2 PC - 1 DB)

    Lol, never thought this would happen to you Dios xD

  3. #3
    Rockin lothera is offline
    MemberRank
    Dec 2006 Join Date
    Nvidia.comLocation
    823Posts

    Re: [Help] Subserver issues (2 PC - 1 DB)

    i'm still stuck on the fact that gameserver gives me error, what files you use?

  4. #4
    RZ's most loyal knight Dios is online now
    ModeratorRank
    Apr 2005 Join Date
    ArgentinaLocation
    5,241Posts

    Re: [Help] Subserver issues (2 PC - 1 DB)

    Im using 97+99, please dont hijack my thread xD



Advertisement