SR_GameServer SQL Connection

01/21/2020 21:07 Mr.Awesome1337#1
Hello, I've been trying to use 2x gameserver on 1 machine, rn I have only one issue, when I use ForceBindIP xxx SR_GameServer_2.exe, trying to open the 2nd gameserver after opening the 2nd machinemanager I get an error on gameserver saying
"Could not connect to DB
======================================
sql::connect() -> EXCEPTION 28000 [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user '_DEFAULT_'.DEBUG -> failed to execute query [_DEFAULT_]"
I made sure that SQL TCP IP enabled, I tried to connect to it through programs and through SQL Management Studio itself, I have 2x IPv4 on my "Ethernet" adapter, even I tried to use a loopback adapter, it didn't work too, I asked some people but they didn't want to help unless I buy the service from them.

Note: if even I tried to run the 1st gameserver using ForceBindIP and used the normal first IP, it gives me the same error, dunno why.

Note2: I have a small tool that changes the modules IP hard-coding it.
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
01/21/2020 21:43 XxGhostSpiriTxX#2
How are you running the second gameserver?
01/21/2020 22:05 Mr.Awesome1337#3
Quote:
Originally Posted by esteve458 View Post
How are you running the second gameserver?
ForceBindIP -i 192.168.1.110 SR_GameServer_2.exe

First IP is 192.168.1.100
01/22/2020 09:16 NorseGodTyr#4
Quote:
Originally Posted by Mr.Awesome1337 View Post
ForceBindIP -i 192.168.1.110 SR_GameServer_2.exe

First IP is 192.168.1.100
create a .bat file and start like so if not work is something in cert wrong or you setup it wrong like i sayed in discord but edit the folder red marked

@[Only registered and activated users can see links. Click Here To Register...] off
cd C:\Server
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.110 GlobalManager_1.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.110 GatewayServer_1.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.110 DownloadServer_1.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.110 FarmManager_1.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.110 SR_ShardManager_1.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.110 AgentServer_1.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.110 SR_GameServer_1.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.110 MachineManager_1.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.111 SR_ShardManager_2.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.111 AgentServer_2.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.111 SR_GameServer_2.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.111 MachineManager_2.exe
01/22/2020 11:00 Mr.Awesome1337#5
I believe that it should be a problem with cert but I don't know, I'm using CertGen, is there any alternative should I use?

EDIT: its fixed now, there are no errors but now it replaces the old one, if i run first modules and they all loaded if i try to run the 2nd gameserver, it replaces the 1st gameserver on the smc like i just restarted the first gameserver and so on, same with AgentServer.
04/08/2020 10:01 mphamduy#6
Has anyone solved this problem yet, I got the same error, when turning on gamesv2, it did not connect to cert, and machine2 was connected normally.
06/20/2020 13:21 vietnguyen09#7
Quote:
Originally Posted by Mr.Awesome1337 View Post
I believe that it should be a problem with cert but I don't know, I'm using CertGen, is there any alternative should I use?

EDIT: its fixed now, there are no errors but now it replaces the old one, if i run first modules and they all loaded if i try to run the 2nd gameserver, it replaces the 1st gameserver on the smc like i just restarted the first gameserver and so on, same with AgentServer.
So how do you solved that? I'm stuck like yours now.
06/20/2020 19:56 XxGhostSpiriTxX#8
Quote:
Originally Posted by vietnguyen09 View Post
So how do you solved that? I'm stuck like yours now.
add me discord and I will help you
06/20/2020 21:18 WolfgangNeverDie#9
Quote:
Originally Posted by NorseGodTyr View Post
create a .bat file and start like so if not work is something in cert wrong or you setup it wrong like i sayed in discord but edit the folder red marked

@[Only registered and activated users can see links. Click Here To Register...] off
cd C:\Server
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.110 GlobalManager_1.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.110 GatewayServer_1.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.110 DownloadServer_1.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.110 FarmManager_1.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.110 SR_ShardManager_1.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.110 AgentServer_1.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.110 SR_GameServer_1.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.110 MachineManager_1.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.111 SR_ShardManager_2.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.111 AgentServer_2.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.111 SR_GameServer_2.exe
timeout 2
start C:\Windows\SysWOW64\ForceBindIP.exe 192.168.1.111 MachineManager_2.exe
Ok. it's woking fine. But how do you running filter?
06/20/2020 21:37 NorseGodTyr#10
Quote:
Originally Posted by WolfgangNeverDie View Post
Ok. it's woking fine. But how do you running filter?
Use a filter that Supported 2 Agent Server
06/21/2020 05:57 vietnguyen09#11
Quote:
Originally Posted by esteve458 View Post
add me discord and I will help you
I can't, Discord say your discord does not exist, skype get that problem too.