Need some help with SQL.

Djordyy · 01/24/2015, 20:28

All you need to do is look at the screenshot, And say me if there is a fix for it and how. I always get this error with SQL

I basicly have tryed like 20-30+ Names, They all wont work. ;[

Using google translate for this:

"There is a network error or copy specific gout occurred while establishing a connection to SQL Server.
Verify that the instance name is correct and that allowed remote connections in SQL server settings"

And then it also says something with a error 40..

[Screenshot]

xKeRnx · 01/24/2015, 20:44

have you tried to login with
Server Name: .\SQLEXPRESS
And Authentication: Windows Authentication

Djordyy · 01/24/2015, 20:55

Quote:

Originally Posted by xKeRnx

have you tried to login with
Server Name: .\SQLEXPRESS
And Authentication: Windows Authentication

You kidding me right,
Would have never thought of this one XD
Thanks it works now.

Also, Do you know why it wont let me start the services?
I have done everything like in the videos you see on youtube xD But it still wont let me start the services.

This might give some help:

000028 2015-01-24 23:10:15 <NUMBER OF 20 IOCP WORKTHREAD STARTED, 4 CPU DETECTED>
000029 2015-01-24 23:10:15 DB_Init FAILED = DSN=AccountLog; UID=sa; PWD=(Private)
000030 2015-01-24 23:10:15 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
000031 2015-01-24 23:10:15 < END OF MAIN = 0 >

Alright that one is fixed, For most of them.

I only cant start _OdinRestServer atm....

I get this, (Google Translated) :P My english isnt that good.

"Can not start the _OdinRestServer service on Local Computer
Error 1053 : The service has the start or control request not answer correctly ."

Also fixed lol, Now it wont connect me.

ah, Thanks for helping me.
Im giving it up XD Deleted everything, Might try a other game

Im back to trying it, XD And im stuck again at this part:
_AccountLog DB Server is giving me this error.

000028 2015-01-24 23:10:15 <NUMBER OF 20 IOCP WORKTHREAD STARTED, 4 CPU DETECTED>
000029 2015-01-24 23:10:15 DB_Init FAILED = DSN=AccountLog; UID=sa; PWD=(Private)
000030 2015-01-24 23:10:15 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
000031 2015-01-24 23:10:15 < END OF MAIN = 0 >

And the thing is that only _AccountLog DB Server if giving the error, The others start like its supposed to be.
Any fix for it? And srry that i ask for so much :P

xSadistic · 01/30/2015, 15:36

Quote:

Originally Posted by Djordyy

000028 2015-01-24 23:10:15 <NUMBER OF 20 IOCP WORKTHREAD STARTED, 4 CPU DETECTED>
000029 2015-01-24 23:10:15 DB_Init FAILED = DSN=AccountLog; UID=sa; PWD=(Private)
000030 2015-01-24 23:10:15 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
000031 2015-01-24 23:10:15 < END OF MAIN = 0 >

Sounds like ODBC.
Maybe you're using the false ODBC-Version or you
didn't connect ODBC with the Database.
You've to login with your Database user on ODBC.

Like that:

Spoiler

You should also check if the name, you used in ODBC
is the same as it stands in the ServerInfo file.

Sour! · 01/30/2015, 20:16

Quote:

Originally Posted by Djordyy

_AccountLog DB Server is giving me this error.

000028 2015-01-24 23:10:15 <NUMBER OF 20 IOCP WORKTHREAD STARTED, 4 CPU DETECTED>
000029 2015-01-24 23:10:15 DB_Init FAILED = DSN=AccountLog; UID=sa; PWD=(Private)
000030 2015-01-24 23:10:15 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
000031 2015-01-24 23:10:15 < END OF MAIN = 0 >

In noob language again: It couldn't find the name "AccountLog" in your ODBC^^
How to fix it: ODBC's accountlog name must be the same as the config.txt's
in your ServerInfo folder^^

xSadistic · 01/30/2015, 21:23

Quote:

Originally Posted by Sour!

In noob language again: It couldn't find the name "AccountLog" in your ODBC^^
How to fix it: ODBC's accountlog name must be the same as the config.txt's in your ServerInfo folder^^

'You should also check if the name, you used in ODBC
is the same as it stands in the ServerInfo file.'
I think that's understandable.

Sour! · 01/30/2015, 23:35

Mal davon abgesehen das irgendwie 2 Wörter bei mir nicht angezeigt werden & mein Satz trotz schlechtem stil grammatikalisch richtig ist, ist dein Englisch ein lachkick hahahahahahahhah bitte lies was du geschrieben hast hahahah

хαrvα · 01/31/2015, 00:22

How to do it:
Go in your ServerConfig, scroll down to the top, and look for "AccountLog"
My Entrie:

Code:

ODBC_INFO "[COLOR="red"]AccountLog[/COLOR]",  1,    0, "DSN=[COLOR="Red"]AccountLog[/COLOR];	UID=sa; PWD=***", "USE[COLOR="red"] AccountLog[/COLOR]; SET LOCK_TIMEOUT 5000" ;world

The Red marked = your ODBC Name.
You can change it to any other name, but it must match.

Djordyy · 02/01/2015, 01:52

Thanks for helping

I have everything started, But yet i get another problem when opening the client.
It's giving me a error.
It happens when its loading to game

Sour! · 02/01/2015, 09:31

Something is missing or broken in your ressystem^^ try a default ressystem and then put all the relevant shns from your shine folder in your ressystem

xSadistic · 02/01/2015, 11:16

You should also check if you're using the correct .exe-file.

Djordyy · 02/01/2015, 12:08

Quote:

Originally Posted by Sour!

Something is missing or broken in your ressystem^^ try a default ressystem and then put all the relevant shns from your shine folder in your ressystem

A friend send me the default ressystem, It still didn't fix it

Quote:

Originally Posted by xSadistic

You should also check if you're using the correct .exe-file.

I am using the right .exe,
It's named Game(.exe)

xSadistic · 02/01/2015, 13:12

Quote:

Originally Posted by Djordyy

A friend send me the default ressystem, It still didn't fix it
I am using the right .exe,
It's named Game(.exe)

Reinstall your Client.

Djordyy · 02/01/2015, 13:26

Quote:

Originally Posted by xSadistic

Reinstall your Client.

Yea i did, Now it's working.