Login and Session server error!!!help!!

mynats · 12/23/2009, 19:34

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

Diablo2404 · 12/23/2009, 19:49

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

mynats · 12/23/2009, 20:02

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?????

janvier123 · 12/24/2009, 00:55

*JayKay* · 12/24/2009, 01:17

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.

mynats · 12/24/2009, 02:11

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

naruto820 · 12/24/2009, 07:04

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

mynats · 12/24/2009, 08:22

Quote:

Originally Posted by naruto820

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

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

janvier123 · 12/24/2009, 09:20

if

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

all tutorials how to installed mssql the right way

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

mynats · 12/25/2009, 04:41

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