Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Services Problem

Banned
Banned
Joined
Jan 23, 2013
Messages
65
Reaction score
8
Hello Everyone

I just made my server and tryed to start the services and some of them wont start or they stop automatically. This is what it say:

"The _Account DB Server services on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs."


I have the problems by the following services;

_AccountLog DB Server
_Character DB Server0
_GameLog DB Server0

Im really new to make a server, maybe its a stupid error but i can't find it sorry :(

A Log & sorry for my bad english:

000018 2013-01-26 02:08:39 <NUMBER OF 10 IOCP WORKTHREAD STARTED, 2 CPU DETECTED>
000019 2013-01-26 02:08:39 DB_Init FAILED = DSN=AccountLog; UID=sa; PWD=sa
000020 2013-01-26 02:08:39 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
000021 2013-01-26 02:08:39 < END OF MAIN = 0 >
000022 2013-01-26 02:08:39 <IOCP WORKTHREAD #8 FREE>
000023 2013-01-26 02:08:39 <IOCP WORKTHREAD #9 FREE>
000024 2013-01-26 02:08:39 <IOCP WORKTHREAD #7 FREE>
000025 2013-01-26 02:08:39 <IOCP WORKTHREAD #6 FREE>
000026 2013-01-26 02:08:39 <IOCP WORKTHREAD #4 FREE>
000027 2013-01-26 02:08:39 <IOCP WORKTHREAD #5 FREE>
000028 2013-01-26 02:08:39 <IOCP WORKTHREAD #3 FREE>
000029 2013-01-26 02:08:39 <IOCP WORKTHREAD #1 FREE>
000030 2013-01-26 02:08:39 <IOCP WORKTHREAD #2 FREE>
 
Last edited:
Skilled Illusionist
Joined
Jan 24, 2012
Messages
364
Reaction score
169
It's related to your database.

000019 2013-01-26 02:08:39 DB_Init FAILED = DSN=AccountLog; UID=sa; PWD=sa
000020 2013-01-26 02:08:39 <SESSION WORKER #0 INIT DB FAILED - STOP ******>

Check your ODBC's/check your database that it's running and/or check that you're able to connect to your mssql instance via management studio.
 
Junior Spellweaver
Joined
May 23, 2009
Messages
176
Reaction score
46
Make sure that your ODBC have this format :

-Account
-AccountLog
-Character
-GameLog
-OPTool
-Statistics

94Hsfgq - Services Problem - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Master Summoner
Joined
Nov 11, 2012
Messages
573
Reaction score
137
000019 2013-01-26 02:08:39 DB_Init FAILED = DSN=AccountLog; UID=sa; PWD=sa<-------
Your Password is wrong. Check your SQL settings, enter in the proper log in information and try again.
 
Skilled Illusionist
Joined
Jan 24, 2012
Messages
364
Reaction score
169
You can use 1 ODBC if you'd like, it won't matter, it's just a connector.
Code:
ODBC_INFO "Account",	 0,	0,	"DSN=Account;		UID=sa;	PWD=******", "USE Account; SET LOCK_TIMEOUT 5000"
ODBC_INFO "AccountLog",	 1,	0,	"DSN=AccountLog;	UID=sa;	PWD=******", "USE AccountLog; SET LOCK_TIMEOUT 5000"
ODBC_INFO "Statistics",	 2,	0,	"DSN=Statistics;	UID=sa;	PWD=******", "USE StatisticsData; SET LOCK_TIMEOUT 5000"
ODBC_INFO "OPTool",	 3,	0,	"DSN=OPTool;		UID=sa;	PWD=******", "USE OperatorTool; SET LOCK_TIMEOUT 5000"

ODBC_INFO "Character",	10,	0,	"DSN=Character;		UID=sa;	PWD=******", "USE World00_Character; SET LOCK_TIMEOUT 5000"
ODBC_INFO "GameLog",	11,	0,	"DSN=GameLog;		UID=sa;	PWD=******", "USE World00_GameLog; SET LOCK_TIMEOUT 5000"

Will do the same as:
Code:
ODBC_INFO "Account",	 0,	0,	"DSN=YourOneODBC;		UID=sa;	PWD=******", "USE Account; SET LOCK_TIMEOUT 5000"
ODBC_INFO "AccountLog",	 1,	0,	"DSN=YourOneODBC;		UID=sa;	PWD=******", "USE AccountLog; SET LOCK_TIMEOUT 5000"
ODBC_INFO "Statistics",	 2,	0,	"DSN=YourOneODBC;		UID=sa;	PWD=******", "USE StatisticsData; SET LOCK_TIMEOUT 5000"
ODBC_INFO "OPTool",	 3,	0,	"DSN=YourOneODBC;		UID=sa;	PWD=******", "USE OperatorTool; SET LOCK_TIMEOUT 5000"

ODBC_INFO "Character",	10,	0,	"DSN=YourOneODBC;		UID=sa;	PWD=******", "USE World00_Character; SET LOCK_TIMEOUT 5000"
ODBC_INFO "GameLog",	11,	0,	"DSN=YourOneODBC;		UID=sa;	PWD=******", "USE World00_GameLog; SET LOCK_TIMEOUT 5000"

Once you've rectified that connecting via MSSQL Management Studio is suffice, use the same info used (sa/whateverpassword) in your configuration .txt, also, be sure your instance allows both windows authentication and user authentication.
 
Banned
Banned
Joined
Jan 23, 2013
Messages
65
Reaction score
8
Thanks for the help ! I'm gonna try it now :)

Edit: Their is nothing wrong in my ODBC it looks the same on that screen.

But i have 1 problem Q.Q I never putted a pw in SQL? can i change the password of the sa login?
 
Last edited:
Experienced Elementalist
Joined
Oct 31, 2010
Messages
202
Reaction score
36
Thanks for the help ! I'm gonna try it now :)

Edit: Their is nothing wrong in my ODBC it looks the same on that screen.

But i have 1 problem Q.Q I never putted a pw in SQL? can i change the password of the sa login?

Add me on skype: alexander_vassiliou

I'll gladly help you out. But only the setup, I'm not deving anything for ya... :p
 
Joined
Jun 5, 2009
Messages
958
Reaction score
235
I did this before and I managed to get it working without any problems but this time I am getting the same error. The OBDC is fine and the password + username is correct. I have no idea what it could be?

I followed chubby's guide exactly and used the correct OBDC names.

Code:
000048 2013-01-27 18:57:44 <NUMBER OF 40 IOCP WORKTHREAD STARTED, 8 CPU DETECTED>
000049 2013-01-27 18:57:44 DB_Init FAILED = DSN=w00_GameLog;	UID=sa; PWD=123
000050 2013-01-27 18:57:44 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
000051 2013-01-27 18:57:44 < END OF MAIN = 0 >
000052 2013-01-27 18:57:44 <IOCP WORKTHREAD #0 FREE>

EDIT: I found out that I had added the OBDC stuff in the wrong part but now that I have added it to the correct place the only one that doesn't work is account log?

EDIT: Never mind I fixed it. Thanks. :)
 
Last edited:
Back
Top