Server's migration problem

[DarkAngel71]

Hey there ...

Since some months, I'm hosting a shaiya server for friends and I on my own comp using hamachi ....
Some hours ago, I bought a dedicated server, to get a better configuration/network bandwich ..

So I began to install all of the server files / DBs / and so on ....
Following primaries "how to" like I did before ...

Now I'm here :
- All servers status in PSM_srv_mgr are on a green arrow (so I guess both ServerFiles and DBs are working well the one with the other)
- I modified (opened/closed safe/bad ports - following HowTo's)
- I modified my game.exe to the new IP

But : When I launch the client, I can connect to the server and enter my game account's infos .... But when I try to launch the selected server name, It crashes ! And I get this error I've never seen before : "Please try to reconnect to the server ... ERROR 0"

I've tryed many things like checking ports, firewall restrictions, and so on ... No good answer ...

So please, do some of you have an idea on what's happening ?

Thx by advance ... And Happy New Year everybody

[thetruestarr1337]

You edited the Linked Servers aswell?

[DarkAngel71]

Thx for ur quick answer, but what u mean by "linked server" ... I guess many servers in server's list ? I only have and ever had one !

Got a question btw .. related to the sql script I've seen on a HowTo "New SQL Installation.sql", giving shaiya admin's account to some DB tables ..
I can't find this script anymore ... but I used it for the first install ...
So : as I simply uploaded my actual DBs on the dedicated server, and as I also changed the master password (both in servers .inis and in MsSql account) ... Do I need to launch this .sql request with new password ? And can this be related to my problem ? And if so, where can I find this .sql please (had to format one of my HDDs - containing original files - some weeks ago :s) ?

[EDIT] Well ... Thx thetruestarr1337
You helped me asking this !
I didn't edit the linked servers for the new shaiya master account's password !

So I used this : Posted by Omega !

/request to close this thread as the problem is now fixed :=)