Help! D:

Printable View

05-12-11
ChibaUsagi

Help! D:

Well I've followed the guide from Fiesta Pserver erstellen / machen part 1 Deutsch / German By Panicfeeling - YouTube (It's German, so I just follow the video) and I've run all the servies as admin (Account, AccountLog, etc). Now I go to services.msc, right click on _Account DB Server and clicked on start. Then, there's a pop up "The _Account DB Server service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

Anyway here is the debug message:

Spoiler:

000000 2011-12-05 21:31:51 C:\Users\Home\Desktop\Server\Account
000001 2011-12-05 21:31:51 -------------------------------------------------------
000002 2011-12-05 21:31:51 Launching the server.....
000003 2011-12-05 21:31:51 Local Time 5/12/2011 9:31:51 PM
000004 2011-12-05 21:31:51 System Time(UTC) 5/12/2011 1:31:51 PM
000005 2011-12-05 21:31:51 <SUCCESSED SCRIPTOR READ> config.txt
000006 2011-12-05 21:31:51 <I AM THE _Account DB Server, SERVER_ID_DB_ACCOUNT, WorldNo=0, ZoneNo=0>
000007 2011-12-05 21:31:51 Service start(no parameter)
000008 2011-12-05 21:31:51 <IOCP WORKTHREAD #0 RUNNING>
000009 2011-12-05 21:31:51 <IOCP WORKTHREAD #1 RUNNING>
000010 2011-12-05 21:31:52 <IOCP WORKTHREAD #2 RUNNING>
000011 2011-12-05 21:31:52 <IOCP WORKTHREAD #3 RUNNING>
000012 2011-12-05 21:31:52 <IOCP WORKTHREAD #4 RUNNING>
000013 2011-12-05 21:31:52 <IOCP WORKTHREAD #5 RUNNING>
000014 2011-12-05 21:31:52 <IOCP WORKTHREAD #6 RUNNING>
000015 2011-12-05 21:31:52 <IOCP WORKTHREAD #7 RUNNING>
000016 2011-12-05 21:31:52 <IOCP WORKTHREAD #8 RUNNING>
000017 2011-12-05 21:31:52 <IOCP WORKTHREAD #9 RUNNING>
000018 2011-12-05 21:31:52 <IOCP WORKTHREAD #10 RUNNING>
000019 2011-12-05 21:31:52 <IOCP WORKTHREAD #11 RUNNING>
000020 2011-12-05 21:31:52 <IOCP WORKTHREAD #12 RUNNING>
000021 2011-12-05 21:31:52 <IOCP WORKTHREAD #13 RUNNING>
000022 2011-12-05 21:31:52 <IOCP WORKTHREAD #14 RUNNING>
000023 2011-12-05 21:31:52 <IOCP WORKTHREAD #15 RUNNING>
000024 2011-12-05 21:31:52 <IOCP WORKTHREAD #16 RUNNING>
000025 2011-12-05 21:31:52 <IOCP WORKTHREAD #17 RUNNING>
000026 2011-12-05 21:31:52 <IOCP WORKTHREAD #18 RUNNING>
000027 2011-12-05 21:31:52 <IOCP WORKTHREAD #19 RUNNING>
000028 2011-12-05 21:31:52 <NUMBER OF 20 IOCP WORKTHREAD STARTED, 4 CPU DETECTED>
000029 2011-12-05 21:31:52 DB_Init FAILED = DSN=Account; UID=sa; PWD=yfsf4iyf
000030 2011-12-05 21:31:52 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
000031 2011-12-05 21:31:52 < END OF MAIN = 0 >
000032 2011-12-05 21:31:52 <IOCP WORKTHREAD #0 FREE>
000033 2011-12-05 21:31:52 <IOCP WORKTHREAD #19 FREE>
000034 2011-12-05 21:31:52 <IOCP WORKTHREAD #16 FREE>
000035 2011-12-05 21:31:52 <IOCP WORKTHREAD #15 FREE>
000036 2011-12-05 21:31:52 <IOCP WORKTHREAD #18 FREE>
000037 2011-12-05 21:31:52 <IOCP WORKTHREAD #17 FREE>
000038 2011-12-05 21:31:52 <IOCP WORKTHREAD #14 FREE>
000039 2011-12-05 21:31:52 <IOCP WORKTHREAD #13 FREE>
000040 2011-12-05 21:31:52 <IOCP WORKTHREAD #10 FREE>
000041 2011-12-05 21:31:52 <IOCP WORKTHREAD #12 FREE>
000043 2011-12-05 21:31:52 <IOCP WORKTHREAD #9 FREE>
000042 2011-12-05 21:31:52 <IOCP WORKTHREAD #11 FREE>
000044 2011-12-05 21:31:52 <IOCP WORKTHREAD #6 FREE>
000045 2011-12-05 21:31:52 <IOCP WORKTHREAD #8 FREE>
000046 2011-12-05 21:31:52 <IOCP WORKTHREAD #3 FREE>
000047 2011-12-05 21:31:52 <IOCP WORKTHREAD #2 FREE>
000048 2011-12-05 21:31:52 <IOCP WORKTHREAD #7 FREE>
000049 2011-12-05 21:31:52 <IOCP WORKTHREAD #5 FREE>
000050 2011-12-05 21:31:52 <IOCP WORKTHREAD #4 FREE>
000051 2011-12-05 21:31:52 <IOCP WORKTHREAD #1 FREE>

Well I don't really know what's wrong with the log, so please help!
05-12-11
Sairy

Re: Help! D:

I had the same problem. Can you post a screenshot of your ODBC? You might have made an error with that.
05-12-11
ChibaUsagi

Re: Help! D:

Sure, http://i44.tinypic.com/1498ntj.jpg
Well do you have Skype? I think it might be easier if we can chat on Skype o3o
My Skype is bloom9334

Edit: I've added you in Skype, please accept it.

Edit: Never mind, I think I solve it. "If your running on a 64 bit computer. Then open run and type in or browse to
"%SystemRoot%\sysWOW64\odbcad32.exe" "
I typed in that and it doesn't work with run. Then I click Browse, it worked.

Another problem pops up now.
How to create an account? e.o
"INSERT INTO tUser (sUserID, sUserPW, sUserName) VALUES ('user', 'passwd', 'user')"
I don't know where to put that in. Account DB? Where? o.O
05-12-11
Orochimaroo

Re: Help! D:

Hellow,

Open your Sql server management studio and then click on the "New Query" button. Paste your sql code there but remember to replace the user/passwd/user values with your own values. After doing so, click on the "Execute" button. Once you do that, the query will be executed. You may close the New Query window which will ask you if you want to save the query, you needn't do that as the query has already been executed. You may save it for future uses though, so you'll have to simply open that saved query, replace the values and that'll allow you to quickly create more users.

I hope I was of any help. I recommend you read some MSSQL ebooks though.

Regards :)
05-12-11
ChibaUsagi

Re: Help! D:

Quote:

Originally Posted by Orochimaroo

Hellow,

Open your Sql server management studio and then click on the "New Query" button. Paste your sql code there but remember to replace the user/passwd/user values with your own values. After doing so, click on the "Execute" button. Once you do that, the query will be executed. You may close the New Query window which will ask you if you want to save the query, you needn't do that as the query has already been executed. You may save it for future uses though, so you'll have to simply open that saved query, replace the values and that'll allow you to quickly create more users.

I hope I was of any help. I recommend you read some MSSQL ebooks though.

Regards :)

Oh ok thanks, registration solved btw XD
Now one problem. When I open the bat file, it says cannot connect to the server... I put my ip address as 127.0.0.1. Help please! D:

Edit: Well I did not put Operator Tool bak file in Restore Database as well as ODBC, cause' I got an error while adding it... Help!
This is the error I got while trying to restore OperatorTool.bak

Spoiler:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'Home-HP\SQLSERVER'. (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The operating system returned the error '5(failed to retrieve text for this error. Reason: 15105)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\OperatorTool.mdf'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdN...)&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------