{HELP FOR ALL}SetUp GunZServer

Page 1 of 2 12 LastLast
Results 1 to 25 of 26
  1. #1
    Account Upgraded | Title Enabled! Dark Thoot is offline
    MemberRank
    Sep 2005 Join Date
    NapoliLocation
    246Posts

    {HELP FOR ALL}SetUp GunZServer

    Hi all.
    I try to set Up GunZserver.... with no results...
    I use sql2005,than I open GunzDB in server file folder,I think must execute query... ok query executed.... with no error,but nothing append.I try to create Database named "GunzDB",but when I try to load GunzDB.sql i get error (noob tentative).

    Well,my question is:
    -What is the right db name????

    SOME1 Can explain to Ragezone community HOW CAN SETUP this da.mned GunzServer??


    Thanks,this isn't spam.


  2. #2
    Valued Member AaronCooper is offline
    MemberRank
    Dec 2006 Join Date
    144Posts
    Try this...

    Find you GunZDB.sql, open with Microsoft SQL Server Management Studio Express.

    (Do not open SQL Server first.)

    Then Choose Your Database from the list. *shown in image below*
    Then Click Execute.

    That's how i did mine.
    Attached Thumbnails Attached Thumbnails gunzdb.jpg  
    Last edited by AaronCooper; 30-12-06 at 09:24 PM.

  3. #3
    Account Upgraded | Title Enabled! Dark Thoot is offline
    MemberRank
    Sep 2005 Join Date
    NapoliLocation
    246Posts
    Ok.. I got problem.
    When i open IT,I must click on connect or I can do nothing.I click on connect but in the box I don't have "GunZDB",why?
    Other question:
    -Where I must put GunzServerFile??I put it in C:\GunzServer - is right??

  4. #4
    Account Upgraded | Title Enabled! Dark Thoot is offline
    MemberRank
    Sep 2005 Join Date
    NapoliLocation
    246Posts
    Quote Originally Posted by Dark Thoot View Post
    Ok.. I got problem.
    When i open IT,I must click on connect or I can do nothing.I click on connect but in the box I don't have "GunZDB",why?
    Other question:
    -Where I must put GunzServerFile??I put it in C:\GunzServer - is right??
    Ok I done IT.

    Well I put server file in C:\GunzServer,after I have opened SQL Server Management Studio Express, I create Database named "GunzDB",after I opned GunzDB.sql in server file,I select database "GunzDB" created first,and I press execute.
    Tables were created^^

    Thanks AaronCooper.

    Now I continue with set up.

  5. #5
    Account Upgraded | Title Enabled! Dark Thoot is offline
    MemberRank
    Sep 2005 Join Date
    NapoliLocation
    246Posts
    Well,Now We need DNS,som1 have ODBC.reg??Or I must create it?

  6. #6
    Account Upgraded | Title Enabled! noffa is offline
    MemberRank
    Jun 2006 Join Date
    Behind youLocation
    212Posts
    Hi, i'm setting up the srever too, and when i get it to work i'll make a tut ;)

  7. #7
    Account Upgraded | Title Enabled! Dark Thoot is offline
    MemberRank
    Sep 2005 Join Date
    NapoliLocation
    246Posts
    Quote Originally Posted by Dark Thoot View Post
    Ok I done IT.

    Well I put server file in C:\GunzServer,after I have opened SQL Server Management Studio Express, I create Database named "GunzDB",after I opned GunzDB.sql in server file,I select database "GunzDB" created first,and I press execute.
    Tables were created^^

    Thanks AaronCooper.

    Now I continue with set up.
    SOrry for continue post,plsss sorry.

    Ok now we need DNS,also now I got problem.
    I try to open serverkeeper,I see first there is "MatchServer1 e 2" and "Locator".
    I Open Macht server folder,click on file "server" and I cna see DNS,DB name ,pass and soo.
    Now I try to create DNS:
    DNS name "GunzDB"
    Data Origin:I try with SQL Server and SQL Native Cliient,in both case when I go to autenticate I got error,and I can't access.
    Well,I create an account in SQL Server Management Studio Express\Secuiruty\Account Acces,click on New Account,I create it with ID:gunz pass=game like writed in file "server" in gunzserver folder(ID=gunz pass=game)

    )LoL(

    Now I repeate operations to create DNS,but I can't get access also using this new account (It have all permission in all database)

    What I need to do??

    Thanks

  8. #8
    Proficient Member lutchius is offline
    MemberRank
    Oct 2006 Join Date
    199Posts
    you have to crate the odbc manualy, to do so:

    1: go to admin tools and select Data Sources(ODBC)
    2: click add
    3: name your new odbc(normaly GunzDB)
    4: for the server use computername/SQLEXPRESS(FOR COMPUTER NAME PUT THE NAME OF YOUR COMPUTER)
    5: next untill you see finish then click finish.
    6: when the window comes up to test your new data source hit test. if everthing is ok. hit ok and your done.

  9. #9
    Account Upgraded | Title Enabled! smoke18 is offline
    MemberRank
    Mar 2006 Join Date
    Buenos Aires, ArgentinaLocation
    561Posts
    gunz server work with sql files same as lineage server??

  10. #10
    Member spellatra is offline
    MemberRank
    Jun 2006 Join Date
    quebecLocation
    94Posts
    my ODBC work perfectly but the only 1 thing it is my locator i jus dunno how to make it work >_>he jus not open.If some 1 know how to solve plz post it here ^^
    thx in advence

  11. #11
    Account Upgraded | Title Enabled! virustheking is offline
    MemberRank
    Nov 2006 Join Date
    442Posts
    I get these errors, when i push execute:
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    Msg 208, Level 16, State 1, Line 1
    Invalid object name 'sys.objects'.
    please help!
    thanks

    ViRuS

  12. #12
    Member spellatra is offline
    MemberRank
    Jun 2006 Join Date
    quebecLocation
    94Posts
    Yea i got the same thing it is cuz you have SQL 2000 and SQL 2005..you surely have a account for sql 2000 and another 1 for 2005...i sugest that you delete your sql 2000 ^^
    worked for me
    Good luck

    PS:Need help about Locator **my last post plz**
    ty

  13. #13
    restore from this file if you use SQL 2000
    Attached Files Attached Files

  14. #14
    Account Upgraded | Title Enabled! Dark Thoot is offline
    MemberRank
    Sep 2005 Join Date
    NapoliLocation
    246Posts
    Installing Database:

    Quote Originally Posted by Dark Thoot View Post
    Ok I done IT.

    Well I put server file in C:\GunzServer,after I have opened SQL Server Management Studio Express, I create Database named "GunzDB",after I opned GunzDB.sql in server file,I select database "GunzDB" created first,and I press execute.
    Tables were created^^

    Thanks AaronCooper.

    Now I continue with set up.
    Create DNS:

    Quote Originally Posted by lutchius View Post
    you have to crate the odbc manualy, to do so:

    1: go to admin tools and select Data Sources(ODBC)
    2: click add
    3:Selecet SQL Server (Not native Client)
    4: name your new odbc(normaly GunzDB)
    5: for the server use computername/SQLEXPRESS(FOR COMPUTER NAME PUT THE NAME OF YOUR COMPUTER)
    6: next untill you see finish then click finish.
    7: when the window comes up to test your new data source hit test. if everthing is ok. hit ok and your done.
    Pls USE SQL 2005 for setting up GunzOnline Server (SQL 2000 not work)

    Thanks to AaronCooper and lutchius

    Databse Installed correctly.. DNS too... Now the Problem is Locator,when I try to open,It not caming up,not work.
    And we must change Ip??Do u know were??
    Last edited by Dark Thoot; 31-12-06 at 10:09 AM.

  15. #15
    Apprentice black_and_red is offline
    MemberRank
    Aug 2006 Join Date
    sdfsdfsdfsdfdsfLocation
    6Posts
    MatchServer run good, but client can't connect to server
    plz up client and file gunz.exe, thanks

  16. #16
    Account Upgraded | Title Enabled! Dark Thoot is offline
    MemberRank
    Sep 2005 Join Date
    NapoliLocation
    246Posts
    The problem is Locator no Matchserver
    take a look
    ImageShack - Hosting :: locatorbw9.jpg

    U can see Locator not work,not coming up

  17. #17
    Proficient Member lutchius is offline
    MemberRank
    Oct 2006 Join Date
    199Posts
    you dont need the locator to connect and play on the server. just run matcherserver.exe point it to your database, and then launch your client and connect.

  18. #18
    Account Upgraded | Title Enabled! Dark Thoot is offline
    MemberRank
    Sep 2005 Join Date
    NapoliLocation
    246Posts
    Really???But in Server Folder there are many IP,I must change??
    Do u KKnow how can I connet to server?? (need runnable 2005)

  19. #19
    Apprentice XxomerjanxX is offline
    MemberRank
    Dec 2006 Join Date
    18Posts
    lmao!it would be easy if u can make a thread, and hopfully explains everything. from A-Z not like u ppl did.
    u ppl start from A-C and then B-E

  20. #20
    Valued Member AaronCooper is offline
    MemberRank
    Dec 2006 Join Date
    144Posts
    You mean to change the debug so it access's your server ?

    Open your config.xml inside your gunz folder..

    Where it says <IP>0.0.0.0<IP>
    Enter you're server IP
    Then i think it's port 6000

  21. #21
    Member spellatra is offline
    MemberRank
    Jun 2006 Join Date
    quebecLocation
    94Posts
    Ok so how i do for this error....
    see the screen shot
    ty in advence
    Attached Thumbnails Attached Thumbnails match-server-error.jpg  

  22. #22
    Member ohan is offline
    MemberRank
    Sep 2006 Join Date
    70Posts
    ODBC Link not created
    or login/password mssql 2005
    incorrect

  23. #23
    Member spellatra is offline
    MemberRank
    Jun 2006 Join Date
    quebecLocation
    94Posts
    hum ok but i cant login whit my mssql 2005 express account.... I can connect only by windows Authentication...not by sql server Authntication : /
    u know how?

  24. #24
    Account Upgraded | Title Enabled! Dark Thoot is offline
    MemberRank
    Sep 2005 Join Date
    NapoliLocation
    246Posts
    Quote Originally Posted by spellatra View Post
    hum ok but i cant login whit my mssql 2005 express account.... I can connect only by windows Authentication...not by sql server Authntication : /
    u know how?
    Strange,me too can log with Windows Autentichation but my ODBC succesfully created

  25. #25
    Apprentice johngame is offline
    MemberRank
    Jun 2009 Join Date
    16Posts

    Re: {HELP FOR ALL}SetUp GunZServer

    Where do i find GunzDB.sql file?? i know this is a silly question but i m a noob so i wanna know where do i locate the GunzDB.sql



Page 1 of 2 12 LastLast

Advertisement