{Help Plz} PS_Game Crash

[[ADM]Minxii]

OK i have had my test/creating server running for about a week no issues. now for some reason when i trun on all services all come on but Game quickly returns to pause.

Before you ask for logs they are useless
All i get in the PS_game log is this

2016-05-02 18:36:56 PS_GAME__system log start (Game01) [GERMANY]

so im at a loss. I have done a full reinstall. and "turned it off and on again" to no avail still same issue with no useful logs. Thank you in advance

[treica]

If you are using the EP6 PS_Game cracked one (which i am sure of as your logs are not saved), it is not stable and your game is going to crash once in a while.

But all services returning to pause looks to me like is not connecting to the database, you make sure you haven't enforced the policy for password expiration, try to connect to the DB using the set user and ensure is not prompting you to set a new password, make sure you have the linked servers.

[[ADM]Minxii]

tested all the linked server connections and no password expiration on. its really starting to get to me now. i'm usually pretty good with this stuff

[SkuulCandy]

I had the same problem, and i had to remove db/serverfiles because i didn't know what's the problem.. Now for me this bug is caused by NPCQuest.Sdata (Bin/Data) when i update (not every time)

[killer2p]

what sql are you using

[[ADM]Minxii]

im using 2008r2
Fixed the issue once but i have it again now

[Raziel166]

Originally Posted by [ADM]Minxii

im using 2008r2
Fixed the issue once but i have it again now

What was the last modification that you did last time?

[[ADM]Minxii]

only clientside edits
I have no clue whats going on .. again game goes back to pause and again no logs at all

[Raziel166]

try this and make sure your files are configured properly

 Spoiler

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,'server name','server Password';
END

exec sp_serveroption @='game', @name='rpc', @value='true';
exec sp_serveroption @='game', @name='rpc out', @value='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,'server name','server Password';
END

exec sp_serveroption @='PS_DEFINEDB', @name='rpc', @value='true';
exec sp_serveroption @='PS_DEFINEDB', @name='rpc out', @value='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,'server name','server Password';
END

exec sp_serveroption @='PS_NCASH', @name='rpc', @value='true';
exec sp_serveroption @='PS_NCASH', @name='rpc out', @value='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,'server name','server Password';
END

exec sp_serveroption @='PS_USERDB', @name='rpc', @value='true';
exec sp_serveroption @='PS_USERDB', @name='rpc out', @value='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,'server name','server Password';
END

exec sp_serveroption @='PS_GAMEDB01', @name='rpc', @value='true';
exec sp_serveroption @='PS_GAMEDB01', @name='rpc out', @value='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,'server name','server Password';
END

exec sp_serveroption @='PS_USERDB01', @name='rpc', @value='true';
exec sp_serveroption @='PS_USERDB01', @name='rpc out', @value='true';

[[ADM]Minxii]

tried that doesnt work still the same issue