-
Apprentice
[Help] Problem with sql at Login server
Well i have server with running KOCP and all otcher stuff but like from few days i have the bug with the Login server :/ there is much shit at the login server log about SQL server and after a while it close sql and close server :< do you have idea how i can fix that?
-
-
Member
Re: [Help] Problem with sql at Login server
I think somebody crashing your server with buggy engine or other tool just put md5 check true in conifg , first find out working files engine, config.pk, e.pk and protect.dll then check md5 hash for each file, add in config and thats it i think.
And disable remote connections to MS SQL, install firewall too if you can.
-
Apprentice
Well all the md5 checksums are added and kick players that dont have the right ones
And how to disable the remote connections?
-
Member
Re: [Help] Problem with sql at Login server
If you are using SQL 2000 check the tools on Programs menu i forgot how its called, anyway it can be done in Manager too, if you using MS SQL 2005 find on Programs menu on Microsoft SQL Server 2005 program SQL Server 2005 Surface Area Configuration click it, now when its open click on Surface Area Configuration for Services and Connections, then click on Remote connections now you will see Local Connections only and Local and Remote connections (if you have web site outside, not hosted on same computer you dont need to shutdown remote connections because site wont be able or any other program to connect to database), now click Local connections only and restart SQL Server. Thats it.