SR_GameServer SQL Connection

[Mr.Awesome1337]

Hello, I've been trying to use 2x gameserver on 1 machine, rn I have only one issue, when I use ForceBindIP *** 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.

[XxGhostSpiriTxX]

How are you running the second gameserver?

[Mr.Awesome1337]

Originally Posted by esteve458

How are you running the second gameserver?

ForceBindIP -i 192.168.1.110 SR_GameServer_2.exe

First IP is 192.168.1.100

[NorseGodTyr]

Originally Posted by Mr.Awesome1337

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

@ 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

[Mr.Awesome1337]

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.

[mphamduy]

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.

[vietnguyen09]

Originally Posted by Mr.Awesome1337

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.

[XxGhostSpiriTxX]

Originally Posted by vietnguyen09

So how do you solved that? I'm stuck like yours now.

add me discord and I will help you

[WolfgangNeverDie]

Originally Posted by NorseGodTyr

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

@ 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?

[NorseGodTyr]

Originally Posted by WolfgangNeverDie

Ok. it's woking fine. But how do you running filter?

Use a filter that Supported 2 Agent Server

[vietnguyen09]

Originally Posted by esteve458

add me discord and I will help you

I can't, Discord say your discord does not exist, skype get that problem too.