- Joined
- Mar 12, 2009
- Messages
- 487
- Reaction score
- 67
Hey everyone,
I've made this thread after answering a help thread about this.
In all the guides to make a FlyFF server there is reference to MSSQL 2005. It will do the job but, there is much better version out nowadays.
I will name the reasons why you can better take MSSQL 2012 (SP1).
Since the 2012 release, Microsoft has changed it's limit policy for the Express versions of MSSQL. In all versions BEFORE 2012 there was a connection limit to the server of 500. Thus making it impossible to have much characters connecting at the same time.
All 2012 versions have a new policy, instead of 500 connections, it now has a max of 1GB of active memory. Since the flyff database is lightweight (it uses approx 38mb clean) there is no chance, even with thousands of players to actively reach 1GB of memory usage from the MSSQL engine. This is a very good advantage since it allows us to run professional servers on the express version.
Besides the better express limitation it's more efficient and secure. It functions better (and is made for) windows 7/8 server 2008 and up, than the older 2005 version.
So to conclude, if you see 1 of these guides:
- Dell Honne's Server setup
- Thrinaria's Server setup
Than follow the tutorial, but instead of downloading and installing MSSQL 2005, use 2012 SP1 instead.
You can download it here:
-
Please choose your preffered Language and than choose 1 of the following files:
- SQLEXPRADV_x86_ENU.exe
- SQLEXPRADV_x64_ENU.exe
NOTE: Please choose the version wich suit your Operating Systems architecture. This is either 32bit (x86) or 64bit. You can check it in the System Info.
Enjoy your server.
Worf
I've made this thread after answering a help thread about this.
In all the guides to make a FlyFF server there is reference to MSSQL 2005. It will do the job but, there is much better version out nowadays.
I will name the reasons why you can better take MSSQL 2012 (SP1).
Since the 2012 release, Microsoft has changed it's limit policy for the Express versions of MSSQL. In all versions BEFORE 2012 there was a connection limit to the server of 500. Thus making it impossible to have much characters connecting at the same time.
All 2012 versions have a new policy, instead of 500 connections, it now has a max of 1GB of active memory. Since the flyff database is lightweight (it uses approx 38mb clean) there is no chance, even with thousands of players to actively reach 1GB of memory usage from the MSSQL engine. This is a very good advantage since it allows us to run professional servers on the express version.
Besides the better express limitation it's more efficient and secure. It functions better (and is made for) windows 7/8 server 2008 and up, than the older 2005 version.
So to conclude, if you see 1 of these guides:
- Dell Honne's Server setup
- Thrinaria's Server setup
Than follow the tutorial, but instead of downloading and installing MSSQL 2005, use 2012 SP1 instead.
You can download it here:
-
You must be registered to see links
Please choose your preffered Language and than choose 1 of the following files:
- SQLEXPRADV_x86_ENU.exe
- SQLEXPRADV_x64_ENU.exe
NOTE: Please choose the version wich suit your Operating Systems architecture. This is either 32bit (x86) or 64bit. You can check it in the System Info.
Enjoy your server.
Worf
Last edited: