Services Problem

[Elinee]

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>

[MentaL]

[Elinee]

Can someone help me =(

[Myth]

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.

[Tronic]

DB_Init FAILED = DSN=AccountLog; UID=sa; PWD=sa

Probably Password is Wrong

[Yeikel]

Make sure that your ODBC have this format :

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

[aqua512]

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.

[Myth]

You can use 1 ODBC if you'd like, it won't matter, it's just a connector.

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:

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.

[Elinee]

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?

[Myth]

Google shall be your friend on that front.

[Alsm97]

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

[Elinee]

Add me on skype: alexander_vassiliou

I added you.

[fiestanerd69]

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.

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. :)