Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Login and Session server error

0

001122

Initiate Mage
Joined
Jun 18, 2008
Messages
4
Reaction score
1
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

Apparently its saying MSSQL server dosent exist... but it does. Im using Sql server 2000 Sp4, have set everythign exatcly like the videos, i have downlaoded the release from Silkbotter, im using Windows Xp Pro on VmWare Workstation. heres my session Server config:

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

I have done the SN.txt and Hvae done the ODBC thing, i have Tryed Using Windows Server 2008 with Sql Server 2000 installed and i have even tryed a different Virtualisation program, I have tryed using Different Servers ive Used one released by trane, another by silkbotter and one in a stickie. I have searched for over 3 days now on Forums, such as ragezone and elitepvpers but no one can give me a different answer other than DO SN.TXT or DO ODBC... or change server.... ive tryed every server out there... please would someone help me? My Windows Live Id is Dennysh@msn.com please add me or post in this thread if you can help me?
 
The Best DDoS Protected Servers
R

rylmygame

Newbie Spellweaver
Joined
Jul 29, 2009
Messages
24
Reaction score
0
something wrong in your share folder. not in session .
 
0

001122

Initiate Mage
Joined
Jun 18, 2008
Messages
4
Reaction score
1
Nothign was wrong in my share folder as you can see i posted how i had used 5 different servers....next time read the whole post before posting. How could all of them have somethign wrong in the share folder? Dunno, anyways problem is fixed so no worries.
 
grondinm

grondinm

Newbie Spellweaver
Joined
Aug 10, 2009
Messages
10
Reaction score
0
maybe it's just me but in the server config should you not just put your local ip..or even 127.0.0.1...i would try that...

and this "Japan GameChu Login module loading Fail..." is normal i get it 2 but all works fine
 
Last edited:
alexzzzzz

alexzzzzz

Newbie Spellweaver
Joined
Jan 4, 2009
Messages
31
Reaction score
0
You need to install Service pack 3, then all will be well.

assuming you have done everything else correctly.
 
J

jpxtreme

Newbie Spellweaver
Joined
Jan 19, 2008
Messages
97
Reaction score
2
try this one if it works.

1.use 127.0.0.1 to all configuration on your server except in the login folder.
2.use your hamachi ip on your login ini.
3. start your server and see if it works.
 
W

Warmonger

Banned
Banned
Joined
Apr 29, 2008
Messages
713
Reaction score
264
001122 said:
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

Apparently its saying MSSQL server dosent exist... but it does. Im using Sql server 2000 Sp4, have set everythign exatcly like the videos, i have downlaoded the release from Silkbotter, im using Windows Xp Pro on VmWare Workstation. heres my session Server config:

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

I have done the SN.txt and Hvae done the ODBC thing, i have Tryed Using Windows Server 2008 with Sql Server 2000 installed and i have even tryed a different Virtualisation program, I have tryed using Different Servers ive Used one released by trane, another by silkbotter and one in a stickie. I have searched for over 3 days now on Forums, such as ragezone and elitepvpers but no one can give me a different answer other than DO SN.TXT or DO ODBC... or change server.... ive tryed every server out there... please would someone help me? My Windows Live Id is Dennysh@msn.com please add me or post in this thread if you can help me?
Click to expand...

Never use "sa" as a server file login to SQL. Keep things more secure create a new login for that. :wink:

P.S. Read my tutorial at the bottom and you might understand/fix some of these errors.
 
Last edited:
C

chem02

Newbie Spellweaver
Joined
Mar 9, 2013
Messages
8
Reaction score
0
Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (Connect()). => mssql server ... tcp/ip : use setting
 
iononline

iononline

Newbie Spellweaver
10 Happy Years
Joined
Apr 2, 2012
Messages
94
Reaction score
26
update SQL ***sp4 Lastes
Use master;
Go
EXEC sp_addlinkedserver 'LSV_GHBILL','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRACNT','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRCASH','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRHELION','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRQUNE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSIZ','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRTEST','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRZUTO','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSTA','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRACCOUNT01','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'

exec sp_serveroption 'LSV_GHBILL','rpc out','true'
exec sp_serveroption 'LSV_GHBILL','rpc','true'
exec sp_serveroption 'LSV_DKRACNT','rpc out','true'
exec sp_serveroption 'LSV_DKRACNT','rpc','true'
exec sp_serveroption 'DKRCASH','rpc out','true'
exec sp_serveroption 'DKRCASH','rpc','true'
exec sp_serveroption 'LSV_DKRHELION','rpc out','true'
exec sp_serveroption 'LSV_DKRHELION','rpc','true'
exec sp_serveroption 'LSV_DKRNUNVICE','rpc out','true'
exec sp_serveroption 'LSV_DKRNUNVICE','rpc','true'
exec sp_serveroption 'LSV_DKRQUNE','rpc out','true'
exec sp_serveroption 'LSV_DKRQUNE','rpc','true'
exec sp_serveroption 'LSV_DKRRONDOW','rpc out','true'
exec sp_serveroption 'LSV_DKRRONDOW','rpc','true'
exec sp_serveroption 'LSV_DKRSIZ','rpc out','true'
exec sp_serveroption 'LSV_DKRSIZ','rpc','true'
exec sp_serveroption 'LSV_DKRTEST','rpc out','true'
exec sp_serveroption 'LSV_DKRTEST','rpc','true'
exec sp_serveroption 'LSV_DKRZUTO','rpc out','true'
exec sp_serveroption 'LSV_DKRZUTO','rpc','true'
exec sp_serveroption 'LSV_DKRSTA','rpc out','true'
exec sp_serveroption 'LSV_DKRSTA','rpc','true'
exec sp_serveroption 'DKRACCOUNT01','rpc out','true'
exec sp_serveroption 'DKRACCOUNT01','rpc','true'
Click to expand...
 
You must log in or register to reply here.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
194
Guests online
11,186
Total visitors
11,380
Totals may include hidden visitors.

Forum statistics

Threads
429,153
Messages
4,590,639
Members
280,945
Latest member
sync717
Most visitors online was 11705 , on 26 Apr 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top