World Manager Server fails to connect to MSSQL (AccountLog/w00_character)

[xXIkaron]

Hello there.
It'd be very nice if you took your time to read this topic and maybe try to help me with my problem.
I'm having trouble setting up my server on a root (running Microsoft Server 2012 R2).
Everything is working fine, but at the "choose server" screen, the population stays at "high" (Server is full).
I know this can only be caused by crashed zones or an error of the world manager, so I took a look at the logs, and found these entries in World00:

000119 2014-04-09 20:34:52 ERROR - HEARTBEAT OVERTIME, NOW DISSCONNECT WITH UNKNOWN
000120 2014-04-09 20:34:52 <CONNECTING CHAR DB            TO PUBLIC_IP:9100>
000121 2014-04-09 20:34:52 <CONNECTING CHAR DB            TO PUBLIC_IP:9100>
000122 2014-04-09 20:34:53 <CONNECTING CHAR DB            TO PUBLIC_IP:9100>
000123 2014-04-09 20:34:53 <CONNECTING CHAR DB            TO PUBLIC_IP:9100>
000124 2014-04-09 20:34:53 <CONNECTING CHAR DB            TO PUBLIC_IP:9100>
000125 2014-04-09 20:34:53 <CONNECTING CHAR DB            TO PUBLIC_IP:9100>
000126 2014-04-09 20:34:53 <CONNECTING CHAR DB            TO PUBLIC_IP:9100>
000127 2014-04-09 20:34:53 <CONNECTING CHAR DB            TO PUBLIC_IP:9100>
000128 2014-04-09 20:34:53 <CONNECTING CHAR DB            TO PUBLIC_IP:9100>
000129 2014-04-09 20:34:53 <CONNECTING CHAR DB            TO PUBLIC_IP:9100>
000130 2014-04-09 20:34:53 ERROR - HEARTBEAT OVERTIME, NOW DISSCONNECT WITH DB_ACCOUNTLOG
000131 2014-04-09 20:34:53 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000132 2014-04-09 20:34:53 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000133 2014-04-09 20:34:53 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000134 2014-04-09 20:34:53 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000135 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000136 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000137 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000138 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000139 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000140 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000141 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000142 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000143 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000144 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000145 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000146 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000147 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000148 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000149 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000150 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000151 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000152 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000153 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000154 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>
000155 2014-04-09 20:34:54 <CONNECTING ACCOUNTLOGDB    TO PUBLIC_IP:9005>

(PUBLIC_IP is my server's IP)
As you can see, the connection to GameLog etc... is working fine, but it can't connect to AccountLog and w00_character.
I hope someone can help me, thanks for your time!
xXIkaron

[MentaL]

[ImNotSatan]

At first you should make sure fire wall allow's the ports, disabling firewall doesnt work in some cases just saying.

If that doesnt work,
try tings like,
Rebooting, server
Reinstall service
Etc..

[xXIkaron]

All done already.
By the way, in the config, do I have to put the root IP?

[Delius]

If portforward, google whats my ip and if hamachi, hamachi ip
if neither 127.0.0.1
^ Config / .bat, launcher or w/e

[ImNotSatan]

All done already.
By the way, in the config, do I have to put the root IP?

Eehm,
some tips: at HOST u need 127.0.0.1 not ur VPS or HAMACHI ip,
In the config u need to put ALL ip's except OPTOOL's on VPS/DEDI/HAMACHI ip (Optools 127.0.0.1 or also VPS/DEDI/HAMACHI ip)

[xXIkaron]

Thanks for your answers. As I said, it's a root server, so I'd need the public IP. I portforwarded ports 80, 8080, 8081 and 9000-9125. (REST, Apache and Game servers)
I configured the hosts file accordingly. As I said, the REST is working fine, so this can't be an issue.
In the config files, I used the public IP every time (I'm not using OPTool)
Also, the world manager is able to connect to the SERVER_ID_DB_GAMELOG and SERVER_ID_LOGIN. It's only an issue with ACCOUNTLOGDB and CHAR DB.

I'm pretty sure the problem is that the server software is incompatible with Windows 8, and Microsoft Server 2012 R2 shares the same core files, maybe that is the cause.

Thanks for your time,
xXIkaron

[ImNotSatan]

Thanks for your answers. As I said, it's a root server, so I'd need the public IP. I portforwarded ports 80, 8080, 8081 and 9000-9125. (REST, Apache and Game servers)
I configured the hosts file accordingly. As I said, the REST is working fine, so this can't be an issue.
In the config files, I used the public IP every time (I'm not using OPTool)
Also, the world manager is able to connect to the SERVER_ID_DB_GAMELOG and SERVER_ID_LOGIN. It's only an issue with ACCOUNTLOGDB and CHAR DB.
Thanks for your time,
xXIkaron

Well, i have these ports open:

80, 8080, 9000-9127

It seems likeu stopped at 9125...? not sure if it would fix ur problem tough.

~~Imno

[Delius]

Yea, doesn't work on windows 8.
Get 08 webserver

[aqua512]

It can work on win server 2012/Win 8 but you have to make major changes to the config's and you have to add some features to windows and some other things. not gonna explain because it can be a bitch to get working.

[Krum]

Try by deleting your Accounts or Character database, i don't really remember, and restore it again.

[xXIkaron]

It can work on win server 2012/Win 8 but you have to make major changes to the config's and you have to add some features to windows and some other things. not gonna explain because it can be a bitch to get working.

It would be very nice if you could explain it to me or at least link me to a guide for windows 8 - I've been googling for some time now and I haven't found anything yet. I could make a guide out of it that you can post, if you want.
Thanks for your reply,
xXIkaron

[NextIdea]

It has been mentioned that you can't make it work in Windows 8 or Windows Server 2012.
Just use any previous version of Windows.

The problem is that for some reason the services can't allocate memory correctly and due that won't start.

[xXIkaron]

It has been mentioned that you can't make it work in Windows 8 or Windows Server 2012.
Just use any previous version of Windows.

The problem is that for some reason the services can't allocate memory correctly and due that won't start.

Well, they are starting for me, the only problem is that the world managers says that my server is full. All services are running.

[aqua512]

I'll make a tut one of these days (when the working zone to MoePromise gets released).

[ImNotSatan]

Nope Server 20128 or Windows 8 not working

~~ImNo