I'm almost throwing this computer out the window by now. I've tried everything I could find here and everything I knew. This is the issue:
"You're using the wrong DB. Get Emisand's DB."Code:Load XML from memory : strings.xml(0x0037) - SUCCESSLoad XML from memory : cserror.xml(0x0037) - SUCCESS [08/31/12 21:57:20] DBMS connected [08/31/12 21:57:20] MMatchDBMgr::ExceptionHandler ErrSQL( {CALL spUpdateServerInfo (1000, 'TheDuelZ', 1)} ), ErrCode( -1 ) ErrMsg - Could not find stored procedure 'spUpdateServerInfo'. State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server] [08/31/12 21:57:20] Command registeration completed [08/31/12 21:57:20] MMatchDBMgr::ExceptionHandler ErrSQL( {CALL spGetGambleItemList} ), ErrCode( -1 ) ErrMsg - Could not find stored procedure 'spGetGambleItemList'. State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server] init gamble machine fail. [08/31/12 21:57:21] MMatchDBMgr::ExceptionHandler ErrSQL( {CALL spGetSurvivalGroupRanking} ), ErrCode( -1 ) ErrMsg - Could not find stored procedure 'spGetSurvivalGroupRanking'. State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
No, I'm not. I'm using his DB already.
"Try using the .bak and restore your DB to the original file."
Done. Twice. With a 2005 build and the original 2008 one.
"Check the username and password at server.ini"
Checked and correct.
"Is the ODBC set up correctly?"
I think so... I followed this tutorial: http://forum.ragezone.com/f497/1-5-s...7/#post7106327
Now, another guy in one of the threads I searched for had the same problem and he managed to fix it. He said the problem was with permissions, that the MatchServer was not able to get to the procedure. So I went on "Properties" at the DB, Procedure and server, checked my own user and "public" and changed the Permissions to "Grant". It didn't change anything, in fact, after I did this the MatchServer crashed faster, God knows why.
Then I just restored again from another file someone out here made for a kid, a 2005 build of Emisand's DB. I did that because it worked for this guy. But it didn't for me.
Should I just delete SQL 2012 and get 2005? I really hope there's another way around it because it takes forever to reinstall this bitch.
Thanks in advance.
EDIT: Oh, God damn it. It's the tutorial's fault. After filling out username and password for the SQL connection, you're supposed to change the DB in the first field to GunzDB and not leave it at "master". My MServer is running. I kept changing files and stuff for nothing. Ugh. You can close this now, mod.


Reply With Quote

