Please reconnect to server ERROR 0

[andya78]

fixed

[bham666]

would be nice If you shared the fix please

[VirtuozZ]

depends on what's the error.
If the error appears when you are on the select server screen edit and run this query

IF NOT EXISTS (SELECT [name] FROM master.dbo.syslogins WHERE name = 'Shaiya')
BEGIN
	EXEC sp_addlogin 'your-db-username', 'your-db-userpassword', 'PS_GameDefs';
END	
EXEC sp_addsrvrolemember 'your-db-username', 'sysadmin';

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='game') 
begin
exec sp_dropserver 'game','droplogins'
end
exec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'game','false',null,'your-db-username','your-db-userpassword'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_NCASH') 
begin
exec sp_dropserver 'PS_NCASH','droplogins'
end
exec sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_NCASH','false',null,'your-db-username','your-db-userpassword'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_USERDB') 
begin
exec sp_dropserver 'PS_USERDB','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB','false',null,'your-db-username','your-db-userpassword'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_USERDB01') 
begin
exec sp_dropserver 'PS_USERDB01','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'your-db-username','your-db-userpassword'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_DEFINEDB') 
begin
exec sp_dropserver 'PS_DEFINEDB','droplogins'
end
exec sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'your-db-username','your-db-userpassword'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_GAMEDB01') 
begin
exec sp_dropserver 'PS_GAMEDB01','droplogins'
end
exec sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'your-db-username','your-db-userpassword'

[VIAT]

Originally Posted by VirtuozZ

depends on what's the error.
If the error appears when you are on the select server screen edit and run this query

IF NOT EXISTS (SELECT [name] FROM master.dbo.syslogins WHERE name = 'Shaiya')
BEGIN
	EXEC sp_addlogin 'your-db-username', 'your-db-userpassword', 'PS_GameDefs';
END	
EXEC sp_addsrvrolemember 'your-db-username', 'sysadmin';

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='game') 
begin
exec sp_dropserver 'game','droplogins'
end
exec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'game','false',null,'your-db-username','your-db-userpassword'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_NCASH') 
begin
exec sp_dropserver 'PS_NCASH','droplogins'
end
exec sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_NCASH','false',null,'your-db-username','your-db-userpassword'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_USERDB') 
begin
exec sp_dropserver 'PS_USERDB','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB','false',null,'your-db-username','your-db-userpassword'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_USERDB01') 
begin
exec sp_dropserver 'PS_USERDB01','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'your-db-username','your-db-userpassword'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_DEFINEDB') 
begin
exec sp_dropserver 'PS_DEFINEDB','droplogins'
end
exec sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'your-db-username','your-db-userpassword'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_GAMEDB01') 
begin
exec sp_dropserver 'PS_GAMEDB01','droplogins'
end
exec sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'your-db-username','your-db-userpassword'

Hey its the query from the shaiya ep7 server file lol

[VirtuozZ]

yes it is, just edited 2 things for (if server already runned) don't loose infos about existing accounts

[[ADM]BLooM]

Hello guys i have some problem with the same error but is it after i choise my toon and i click on Game Start ! Someone can leave me a message what is wrong ?

[JohnHeatz]

That would be because of a mismatch between client and server, fix that and you shouldn't have this issue, as well check on your logs, there you will find the exact issue.

[[ADM]BLooM]

Ok but the problem cant resolve it by myself i just asked here for know what to say to the Dev when he`s come on .... cuz isnt my server already is almost 8h when i try to log on game and i cant cuz i get always this error ... >.> .... i will try to talk with him to see what is happen !!!!

[andya78]

rather late to reply to this but bloom i found it was one of my sdata files that was double encrypted so just used lph's data tool to extract and decrypted each one 2-3 times till it gave me an error then re encrypted them one at a time