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!