Login and Session server error!!!help!!

12/23/2009 19:34 mynats#1

i have problem with my Login and Session server...
i'm using win xp pro sp2...
I would like to know if someone could help me, Everytime i run the Session Server i get an Error and then it Auto closes, its the same error seen here:

Code:

552: Session Server Ready
552: Provider::initialize()
Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (Connect()).
]SQL Server does not exist or access denied.
552: >> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL
552: File: .\Config\Provider.cpp, Line: 79

Code:

DATABASE_ADDRESS	= MY HAMACHI IP,1433
DATABASE_DATABASE	= CHARACTER
DATABASE_ACCOUNT	= sa
DATABASE_PASSWORD	= PASSWORD I SET TO SA
SESSION_SERVER_ID	= 1100

LOG_PATH		        = ..\LogFiles\
BILLING			= 0
NO_CHARGE_CODE	= NODATA

Before this Error im also getting an Error in my Login Server i think its related and one is cause the other.

Heres the Error:

Code:

1112: Japan GameChu Login module loading Fail...
1112: <------------- Login Server Started ------------>
516: Provider::initialize()
Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (Connect()).
]SQL Server does not exist or access denied.
516: [CRITICAL ERROR] SP_GUILD_SERVER_ID_SET SUCCESS

This is My Login Server Config:

Code:

SESSION_COUNT		= 1
SESSION_NO1_IP			= MY HAMACHI IP
SESSION_NO1_PORT		= 10000
SESSION_NO1_FLAG		= 1
SESSION_NO1_INDEX		= 1100
;
Korea				= LOWER
Korea_CP			= DEFAULT
Japan_Netmarble		= DEFAULT
Japan_GameChu		= LOWER
USA_Acclaim		= DEFAULT

12/23/2009 19:49 Diablo2404#2

This is My Login Server Config:

Code:

SESSION_COUNT		= 1
SESSION_NO1_IP			= MY HAMACHI IP
SESSION_NO1_PORT		= 10000
SESSION_NO1_FLAG		= 1
SESSION_NO1_INDEX		= 1100
;
Korea				= LOWER
Korea_CP			= DEFAULT
Japan_Netmarble		= DEFAULT
Japan_GameChu		= LOWER
USA_Acclaim		= DEFAULT

There is ur problem right there.. the line where it says:
SESSION_NO1_IP = MY HAMACHI IP... my hamachi ip means, input your IP there of your hamachi. you have to do the same at all the other txt files that came with the server files..

12/23/2009 20:02 mynats#3

Quote:
Originally Posted by Diablo2404
This is My Login Server Config:
Code:
SESSION_COUNT		= 1
SESSION_NO1_IP			= MY HAMACHI IP
SESSION_NO1_PORT		= 10000
SESSION_NO1_FLAG		= 1
SESSION_NO1_INDEX		= 1100
;
Korea				= LOWER
Korea_CP			= DEFAULT
Japan_Netmarble		= DEFAULT
Japan_GameChu		= LOWER
USA_Acclaim		= DEFAULT
There is ur problem right there.. the line where it says:
SESSION_NO1_IP = MY HAMACHI IP... my hamachi ip means, input your IP there of your hamachi. you have to do the same at all the other txt files that came with the server files..

emm..i'm alredy put my Hamachi Ip there..but login and session =ERROR....someone know how to know my own port?????

12/24/2009 00:55 janvier123#4

[Only registered and activated users can see links. Click Here To Register...]

12/24/2009 01:17 *JayKay*#5

Quote:

Originally Posted by mynats

emm..i'm alredy put my Hamachi Ip there..but login and session =ERROR....someone know how to know my own port?????

PHP Code:


			
DATABASE_ADDRESS    = X.XXX.X.XXX,1433 ------->ip hamachi and port 1433

DATABASE_DATABASE    = CHARACTER

DATABASE_ACCOUNT    = XX  ---------------------->account SQL

DATABASE_PASSWORD    = XXXXXXX  ----------------Password SQL

SESSION_SERVER_ID    = 1100



LOG_PATH        = ..\LogFiles\

BILLING            = 0

NO_CHARGE_CODE    = NODATA

or install netframework 3.5.

12/24/2009 02:11 mynats#6

Quote:

Originally Posted by arthurvalenca

PHP Code:

DATABASE_ADDRESS = X.XXX.X.XXX,1433 ------->ip hamachi and port 1433 DATABASE_DATABASE = CHARACTER DATABASE_ACCOUNT = XX ---------------------->account SQL DATABASE_PASSWORD = XXXXXXX ----------------Password SQL SESSION_SERVER_ID = 1100 LOG_PATH = ..\LogFiles\ BILLING = 0 NO_CHARGE_CODE = NODATA

or install netframework 3.5.

ok...i'm try now...btw...wht should i do after my download done??????I mean after I install the Netframework...thx

12/24/2009 07:04 naruto820#7

did u do the queires in sn? is ur sql installed as default?

12/24/2009 08:22 mynats#8

Quote:

Originally Posted by naruto820

did u do the queires in sn? is ur sql installed as default?

yes...already..my sql as default.....

12/24/2009 09:20 janvier123#9

if [Only registered and activated users can see links. Click Here To Register...] dont work you installed MSSQL the wrong way !
i had the same with some other guy.... that means you did not follow the tutorial like it should be
we (and iam talking about the whole EPVP 2moons/dekaron community) can write about 500 video tutorials and about 600 guides how to installed it and some ppl still get it wrong ...

we even made 2 1click servers and still ...
about 50% about all posts in epvp are just mistakes that ppl do when they dont follow tutorials
so iam asking you to follow [Only registered and activated users can see links. Click Here To Register...] all tutorials how to installed mssql the right way

maybe a "premium" install service will fix the problem ?

12/25/2009 04:41 mynats#10

emm...maybe i'm wrong install my MSSQL.....i'll reinstall then follow the video tut.....thx...if i have same problem..mybe my laptop is the problem...:)
can i make server with my laptop???i just wanna try make server with laptop 1st..
accer asprie 5570
...:)