Please try to reconnect to the server ERROR 0

Sh1nra · 01/28/2013, 22:19

Hey EPvP

My Server was online but then some people can't login they get this Error:

Please try to reconnect to the server ERROR 0

And i don't know what can i do, i tried :

Use other Client
Use other game.exe
Restart root server
deinstall and install server again
execute Item.sql and Cash.sql again
install linked servers again
install mssql / shaiya server files again

It happened all of a sudden, it worked and then i have problems with login..

My Logs:

PS_LOGIN

Spoiler

PS_USERLOG

Spoiler

PS_GAME

Spoiler

PS_SESSION

Spoiler

PS_DBAGENT

Spoiler

PS_GAMELOG

Spoiler

maztoul · 01/28/2013, 22:32

heya Sh1nra .. my friend have like this problem also and we trying to find a solution .. anyway , i see you secceded to start make this server i wish to add me in skype and help me a littel because i got sme problem to making server runing pls tyvm my skype ( magicmagic4222)

Sh1nra · 01/28/2013, 22:50

I added you

Philipp_ · 01/29/2013, 06:52

What is about using the search engine next time? There are tons of threads about this error.

Quote:

Originally Posted by Philipp_

This usually happens if there is a mismatch between client and server files (NPCQuest.SData or Item.SData in example) or your linked servers aren't installed. Run the following query to add linked servers:

Spoiler

Code:

/* Add linked servers */

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game')
BEGIN
	EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='game', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_DEFINEDB')
BEGIN
	EXEC sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_NCASH')
BEGIN
	EXEC sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_NCASH','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_NCASH', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_NCASH', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB')
BEGIN
	EXEC sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_USERDB','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_USERDB', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_USERDB', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_GAMEDB01')
BEGIN
	EXEC sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB01')
BEGIN
	EXEC sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_USERDB01', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_USERDB01', @optname='rpc out', @optvalue='true';

Good Luck

Sh1nra · 01/29/2013, 08:25

Quote:

Originally Posted by Philipp_

What is about using the search engine next time? There are tons of threads about this error.

Good Luck

I used search engine, they all habe problems with linked servers and i reinstall linked servers again too...

The Problem is, i restart server so people can login maybe 30secs. then they get this error:
"Please try to reconnect to the server ERROR 0" . If they are online they can play
but other people can't login and i don't know why.

TeddyBear94 · 01/29/2013, 12:21

ep5 skill fix? did u f°°°°d it maybe up?

Sh1nra · 01/29/2013, 13:57

yes i use ep 5 skill fix, what you mean ö.o

~~orion72956~~ · 02/04/2013, 00:20

Check and make sure that your Items, Mobs, and MobItems are all the same in your server as well as in your client. Also make sure that you have decrypted NpcQuest.Sdata and added it in your PSMClient files where appropriate.

When using the LPH skill fix remember that you have 1min only to execute the CEA. After that, run your vchkoff and nprotect off and you should be fine.

TeddyBear94 · 02/04/2013, 05:56

Quote:

Originally Posted by orion72956

Check and make sure that your Items, Mobs, and MobItems are all the same in your server as well as in your client. Also make sure that you have decrypted NpcQuest.Sdata and added it in your PSMClient files where appropriate.

When using the LPH skill fix remember that you have 1min only to execute the CEA. After that, run your vchkoff and nprotect off and you should be fine.

sry me and shinra forgot to post we fixed the problem

it was placed in his old db. we made a complete new installation and fixed it

JohnHeatz · 02/04/2013, 21:23

Glad to see this got fixed; hence I'll be closing the thread.