[Help]Start PSMServer

SoulsSoon · 01/22/2016, 18:14

Good day faced with the problem of launching "GSMServer" after mnogokratonoy setting all configuration component server, I have a problem when you press the "Start All Server Service" all the checkboxes appear, then abruptly "Session", sometimes it does not run is stopped and the track the rest through two minutes.

What you need to ask important to make it easier to find and fix the problem.

p.s Sorry for my English.

Here, Game Log and PS game

Spoiler

That's when you run a query in SQL Server 2008 bug.
Request New SQL Installation

Spoiler

Thank you.

killer2p · 01/22/2016, 18:58

you can delete the bottom part of NEW SQL install where it inserts user into database
Please Make sure that you are using linked servers and the databases are properly attached aswelll as please post the rest of the logs

SoulsSoon · 01/23/2016, 08:55

Quote:

Originally Posted by killer2p

you can delete the bottom part of NEW SQL install where it inserts user into database
Please Make sure that you are using linked servers and the databases are properly attached aswelll as please post the rest of the logs

I'm using the standard file Omega File, and also tried it with many others, almost all, are always the same answer when omega I ran Install_Server, all was well before the command line to try to execute the query "New SQL Installation" mistake was that I wrote as a command line as well as for manual execution. And to remove the 9-line?
Then just added uses.
Here are all the log
PS_DBAGENT__charsave

Spoiler

PS_DBAGENT__system

Spoiler

PS_GAME__system

Spoiler

PS_GAMELOG__system

Spoiler

PS_LOGIN__system

Spoiler

PS_SESSION__system

Spoiler

PS_USERLOG__system

Spoiler

I understand that I have the server can not connect to the database, but I have to correct that just did, and probably in the wrong direction.

killer2p · 01/23/2016, 09:42

All you need is this really Replace the info with your info

Spoiler

SoulsSoon · 01/23/2016, 15:21

Quote:

Originally Posted by killer2p

All you need is this really Replace the info with your info

Spoiler

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,'LIDA9493Mm','1502SI2806mM '

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,'LIDA9493Mm','1502SI2806m M'

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,'LIDA9493Mm','1502SI280 6mM'

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,'LIDA9493Mm','1502SI280 6mM'

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,'LIDA9493Mm','1502SI280 6mM'

Well, tomorrow I enter the query in SQL Server, further I will tell how and what was going on.Thank

Quote:

Originally Posted by killer2p

All you need is this really Replace the info with your info

Spoiler

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,'LIDA9493Mm','1502SI2806mM '

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,'LIDA9493Mm','1502SI2806m M'

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,'LIDA9493Mm','1502SI280 6mM'

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,'LIDA9493Mm','1502SI280 6mM'

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,'LIDA9493Mm','1502SI280 6mM'

All well , as I described in the beginning, it does not run, the query is executed .