I have problem with my Private Server

01/14/2011 16:32 delight-b#1
I created a Shaiya PServer in dedicated server Vista 7!
But the problem is when i choose a server to join in game it shows an error

! Error:
Connection with server has been disconnected
ERROR
0

who know where is the problem to improves it ??
01/14/2011 19:32 [GM]Zero#2
There are several things I could think of that pertains to this issue that I've seen or heard about in the past:

1. You forgot to put in the /nprotectoff command in while starting up your server (in Server Patch Config, right-click "Game" and choose "Command" then type in that command in the box)

2. The IP's and/or DB connection info in your Configuration ini files are incorrect. You can find them in PSM_Client\bin\Log

3. Your game.exe isn't the correct episode configuration and/or encryption. I've always run into problems trying to run an EP5 game.exe on an EP4 server in my tests. The same goes for trying to run an encrypted game.exe with decrypted .SData files in the data.saf

4. Your SQL Linked Server Objects weren't configured correctly, or are missing entirely. Here is the SQL query you need to get them (credit goes respectfully to the original developers: )

Code:
/* Add server link, and Shaiya username */
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';

TRUNCATE TABLE PS_UserData.dbo.Users_Master;
TRUNCATE TABLE OMG_GameWEB.dbo.GameAccountTBL;
TRUNCATE TABLE PS_UserData.dbo.Users_Detail;
	
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'
You will need to replace "your-db-username" with your SQL admin login name (For most servers, it's "Shaiya") and "your-db-userpassword" for the password that correlates with it. You will also need to change "127.0.0.1" to your server's IP address.

Hope this helps!
08/18/2011 03:46 shaiyabrasil#3
GM pls help me.. i creat one serve. and i creat a toon.. name exist =/// help me plss
08/18/2011 05:44 Bаne#4
Quote:
Originally Posted by delight-b View Post
I created a Shaiya PServer in dedicated server Vista 7!
But the problem is when i choose a server to join in game it shows an error

! Error:
Connection with server has been disconnected
ERROR
0

who know where is the problem to improves it ??

What is Vista 7??? o.o
08/30/2011 17:34 shaiyabrasil#5
Hello guys i need help

just error

Name Already in use

ty
08/30/2011 23:02 JohnHeatz#6
Use the search engine, i'll point you out (just because I am tired of people asking the same question over and over again) check on ShaiyaOmega's sticky thread on how to make a server; on the last 10 pages of that thread there is a post with the SQL Query to fix that
12/10/2011 11:09 -FeaRs-#7
i have problem with logg server cannot find server ;( any can help?
12/10/2011 22:28 Bаne#8
If you could give us some infrormation on the bug, we probably can.