[FIX] If your Services at Server Patch Config Stay at Pause Read This.

[hamscer]

Im sick of seeing posts about this,Ive spent like 3 hours trying to figure out the issue and this is what i did to fix the problem.



Go to your managment studio and connect to the database useing SQL authotication in the server name put "127.0.0.1" (without quote marks) after that use the Username Shaiya and the password Shaiya123 if all connects and everything is fine right click on the server and select "New Query" a new window will open inside the managment studio insert there the following query :

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,'Shaiya','Shaiya123'

and click execute,after that try connecting the "Server patch Config" again,this worked for me...

Credits to the query too : yn126

If when you type 127.0.0.1 at the server name and click connect it gives you an error do the next thing...Click Start>All Programms>Microsoft SQL Server>Configuratioon Tools>SQL Server Surface Area Configuration a new window shall open,Click on Surface Area Configuration For Services and Connections On the left youll see an explore window Click on Remote Connections then tick the Local And Remote connections and select "Useing Both TCP/IP and Named Pipes option Click ok and try again.
Hope this helps.

[Bаne]

Needs to be moved to the "development section"

[mabe140]

I tryed to put that query in, but the msg I got was

Msg 15028, Level 16, State 1, Procedure sp_addlinkedserver, Line 82
The server 'game' already exists.

Then I opened Server Patch Config and tryed to "Start all server service", but my marks are still standing on pause only. The pause is green, but has never gone over to "play" green. I've had this problem for a couple days now, but I just can't figure out why theese pause green ones, wont change to play.

[STIV123]

Would you read the error please kind sir?

'Game' Already exist. Change that. Change the Server Name there and in the INI files and Server Patch Configer and u're done

[zarazagan]

sry i changed and query has been completed successfully. But idk why things still stay Paused.

ps_dbagent.ini:

[SERVER]
ServerName=DBAgent01
ServerPort=
MaxConnection=
[DB]
GameData=127.0.0.1, PS_GameData, Shaiya, 5DF59870228E618AD213434D5607805F4B12780FB64F364914 7635F3FCE26CE5A5F9984F1C30D7CB26E18F4BE33CE12A7736 E92E39500F711DAB9FC6A01D863F416B0B719C23511BED7529 93915E02BF5DB6B859A35AAEC93E87F8E217D6220F4F5043AC B5BE5BD5760D2B3B5B309AEA27258E17BF71A82CF4E221992A 813686
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000


ps_game.ini:

[SERVER]
ServerName=Game01
ServerPort=
MaxConnection=10
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
DBAgent=127.0.0.1
GameLog=127.0.0.1
[DB]
GameDef=127.0.0.1, PS_GameDefs, Shaiya, 6C8DB9E6855CDB4C67CDDAA53E2F9E24E096AE76F1178383C3 1C5AD7E1A819B2AB5323A2BFBC34153590D10370F3EC6DE1A4 B0EE1F473B7887045A04AD7AFA276F91D36D85DA282826FC7B 78A5A174EE0A3C2AD5E3A022E4F4BAAF2B077C9430EC698710 5493948106A51108C2435E58F045A0C806B4A248F03D0A2D77 800A91
GameData=127.0.0.1, PS_GameData, Shaiya, BF7D69A385D01E5DE337ED047256087C7E740061C7283316F6 1E7ABC2C53985D1E40C72C788DC81A42A141DF49DA648825EF 7B4069BD7CAB7C86AD7CCC434BAD05399C31BFD3686A1B11D2 AEF062628CF9D612C59CACF7B6FF245BB24E65E78DF33718C5 4E7D2463D2201172FFF07E41C8292F308B990EC931A7E0FB20 3EC5B6
[GAMEINFO]
GameName=Pepper2
GamePublicIP=127.0.0.1
GameVersion=0x08022100
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

ps_gamelog:

[SERVER]
ServerName=UserLog01
ServerPort=
MaxConnection=
[DB]
DBCount=1
DBGame01=127.0.0.1, PS_GameLog, Shaiya, 1A3FDDCF30829F3A71792BE5B1E304A69785B9CD328F7733D1 44D4C97869E3203C52C01A9FD1E2241817799E66E7455449B2 0663531CAC9DA89163BB3ABED90A7E5F7F689EE163EBD5880D 205EBA3107A65101F94BEC8539AE0ECB4E4AE76385261CC222 1167913BA34880B19AD0263577C9F7E8CEFBC27A1894ABB91D 9F06A3
DBChat01=127.0.0.1, PS_GameLog, Shaiya, 06D7585AC02E89711B74480F6FDCEE80826836655AEC3530F5 914DB2ED2E23D0C5325FA6EFDFA5FBB37933FC2C30E05A67DE 4F722D0AAA45ED523528F1F9B99E069EC10A4780223919EF02 48B41F10DBDD5915A1E72DC7BEFC03064B6A1EB28BDC7767DE DE80E2C49EDF27F331598B63341C3A6E1D0950E37B94C81AB0 F629B5
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001


ps_login.ini:

[SERVER]
ServerName=Login01
ServerPort=
MaxConnection=10
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
[DB]
UserData=127.0.0.1, PS_UserData, Shaiya, CF4DF9120680DD8A3DF05E1504F7366994F844D8590D6AE522 2D841D4D572F6408DD836DCDF05E357F5A55CE24955F3C0EAE 136E4CFAB0141C6D9499623526304D5223C5C9F88F1630ACC3 44420F252FC01FC1BC2C7C673F01BBA1C404B8B7B5B1CBE486 72CC0B48DDB6D9AF0626B9D25C63EDD893B96A88EDC5420B84 C5F1B2
[GAMESERVERS]
// Game01 = name, Mapping ServerID, Mapping DB ID(use prev server id)
GameServerCount=1
Game01=Game, 1

[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

ps_sessions.ini:

[SERVER]
ServerName=Session
ServerPort=
MaxConnection=

[CONNECTION]
UserLog=127.0.0.1

[GAMESERVERS]
GameServerCount=1
Game01=Pepper2

[LOGFILE]
Replace=0
Append=1

[MONITOR]
Enable=0
Port=50000

ps_userlog.ini:

[SERVER]
ServerName=UserLog
ServerPort=
MaxConnection=
[DB]
UserLog=127.0.0.1, PS_UserData, Shaiya, 7427BE8A8A278E266ACBF05DF33B823012CC3A1F129615165E 1C26FAE7CE50C127D1041F0795BDAE71956EDCD6044EB5BA27 2ED083DAAC1F9BAD221379229037242AADACE62A520AC68DDD F84B36E718C2D2F2EF655440E5DBA039AA6D4455797EBAD2DF 93819D82108FC6314F9A2C23585BDAF558F0140AE4B1814A31 19745B
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001




i think error is inhere,,,,,,probally many mystakes in those ini files and like tht any1 help me with them. Game in Server patch config has been changed to Pepper2 too. Plz answer and ty!