Archive for December, 2011

Tips on Sbot and Auto Quest SP farming in Temple

Friday, December 30th, 2011
There has been a lot of talk about how sbot lack the option of doing auto quest sp farming in temple. An option is deliberately left out for personal reasons by Shiva.
Go to the temple, go to the NPC and take the quests you want. Usually you can take 3 at a time. Go to ‘Auto quest’ and add the quests you have taken.
Remember to choose ‘Deliver directly’ and ‘Rep’ in the settings, as shown. Go further in the cave and find your botting spot and save it. Remember to use ‘auto walk’. Save your shirt and start bot and enjoy.
You could even get more than 200k SP per day if you have full 8/8 PT and a pick-up pet. But, if you’re a Hunter, be ready for Thieves to jump-in and vice-versa.

There has been a lot of talk about how sbot lack the option of doing auto quest sp farming in temple. An option is deliberately left out for personal reasons by Shiva.
Go to the temple, go to the NPC and take the quests you want. Usually you can take 3 at a time. Go to ‘Auto quest’ and add the quests you have taken.
Remember to choose ‘Deliver directly’ and ‘Rep’ in the settings, as shown. Go further in the cave and find your botting spot and save it. Remember to use ‘auto walk’. Save your shirt and start bot and enjoy.
You could even get more than 200k SP per day if you have full 8/8 PT and a pick-up pet. But, if you’re a Hunter, be ready for Thieves to jump-in and vice-versa.

How to Change the Avatar Dress

Friday, December 30th, 2011
This occurs when you edit weapon with the same name as European weapon.
Take the shield for example. So you need to import the file manually.
First open Pk2Editor On the “manual single file import”. Browse for the renamed .bsr/.ddj file on the Entry name: type the name of the file.
Then on the Entry Path, type the path where the file will be imported. Press import!
After you have done this, check on the notice if the importing is successful.

This occurs when you edit weapon with the same name as European weapon.Take the shield for example. So you need to import the file manually.
First open Pk2Editor On the “manual single file import”. Browse for the renamed .bsr/.ddj file on the Entry name: type the name of the file.
Then on the Entry Path, type the path where the file will be imported. Press import!
After you have done this, check on the notice if the importing is successful.

Solution to “2 files were detected error”

Friday, December 30th, 2011
This occurs when you edit weapon with the same name as European weapon.
Take the shield for example. So you need to import the file manually.
First open Pk2Editor On the “manual single file import”. Browse for the renamed .bsr/.ddj file on the Entry name: type the name of the file.
Then on the Entry Path, type the path where the file will be imported. Press import!
After you have done this, check on the notice if the importing is successful.
Tips on Sbot and Auto Quest SP farming in Temple
There has been a lot of talk about how sbot lack the option of doing auto quest sp farming in temple. An option is deliberately left out for personal reasons by Shiva.
Go to the temple, go to the NPC and take the quests you want. Usually you can take 3 at a time. Go to ‘Auto quest’ and add the quests you have taken.
Remember to choose ‘Deliver directly’ and ‘Rep’ in the settings, as shown. Go further in the cave and find your botting spot and save it. Remember to use ‘auto walk’. Save your shirt and start bot and enjoy.
You could even get more than 200k SP per day if you have full 8/8 PT and a pick-up pet. But, if you’re a Hunter, be ready for Thieves to jump-in and vice-versa.

This occurs when you edit weapon with the same name as European weapon.Take the shield for example. So you need to import the file manually.
First open Pk2Editor On the “manual single file import”. Browse for the renamed .bsr/.ddj file on the Entry name: type the name of the file.
Then on the Entry Path, type the path where the file will be imported. Press import!
After you have done this, check on the notice if the importing is successful.

Tips on Sbot and Auto Quest SP farming in Temple
There has been a lot of talk about how sbot lack the option of doing auto quest sp farming in temple. An option is deliberately left out for personal reasons by Shiva.
Go to the temple, go to the NPC and take the quests you want. Usually you can take 3 at a time. Go to ‘Auto quest’ and add the quests you have taken.
Remember to choose ‘Deliver directly’ and ‘Rep’ in the settings, as shown. Go further in the cave and find your botting spot and save it. Remember to use ‘auto walk’. Save your shirt and start bot and enjoy.
You could even get more than 200k SP per day if you have full 8/8 PT and a pick-up pet. But, if you’re a Hunter, be ready for Thieves to jump-in and vice-versa.

Ways of pk2 editing your weapon

Thursday, December 29th, 2011
When editing using a hex editor, your edited weapon will return to normal every time joymax patch their media.pk2/add a new item. But with this way, the item you edited will remain that way until you decided to return it to normal.
For example, edit my 5th degree spear to 8th degree spear.
First you need the Pk2 tools by drew Benton of 0×33. Run Pk2 Extractor. This picture has been resized. Click this bar to view the full picture. The original picture is sized 822×305. Open Knowledge.pk2.Once, knowledge.pk2 is opened find “res” & expands it. Then expand “item” —> “china”—> “weapon”. This picture has been resized. Click this bar to view the full picture. The original picture is sized 823×316. Then find spear_05.bsr & spear_08.bsr & extract them. This picture has been resized. Click this bar to view the full picture. The original picture is sized 823×292. This picture has been resized. Click this bar to view the full picture. The original picture is sized 824×301. A notice will say that the extraction is a success. This picture has been resized. Click this bar to view the full picture. The original picture is sized 823×185.
Close the pk2 extractor & go to ur pk2 tools folder. There you will discover a folder name “Data”. Then, open knowledge folder then res–>item–>china–>weapon. In the weapon folder, u will find the extracted .bsr’s. Cut spear_08.bsr & paste it anywhere in your hard disk. Then rename spear_05.bsr to spear_08.bsr. Run pk2 editor. Open Knowledge.pk2. In the automatic single file update click on select file & open data/res/item/china/weapon. Select spear_08.bsr & hit OK. After pressing OK, hit Import. A notice will tell you that the import is a success.
After you are completed, you can now play silkroad. Alter the icon of the weapon and editing the way it looks is the same. Run pk2 extractor. Open media.pk2. Expand “icon”. Then expand item–>china–>weapon. Extract spear_05.ddj and spear_08.ddj. In the pk2 tools folder u will discover a folder named “Media”. Do the same as what u did in editing your weapon. Go inside media/icon/item/china/weapon/. Cut spear_08.ddj and paste it somewhere else. Rename spear_05.ddj to spear_08.ddj. Run Pk2 editor. Open media.pk2. Do the same as what you did in importing your renamed spear_08.bsr when you edit your weapon. Restore it.
Restoring is done when you want to return the weapon’s looks to normal. Copy and paste your back up. Paste it back to its original folder. Import it using Pk2 extractor.

When editing using a hex editor, your edited weapon will return to normal every time joymax patch their media.pk2/add a new item. But with this way, the item you edited will remain that way until you decided to return it to normal.
For example, edit my 5th degree spear to 8th degree spear.
First you need the Pk2 tools by drew Benton of 0×33. Run Pk2 Extractor. This picture has been resized. Click this bar to view the full picture. The original picture is sized 822×305. Open Knowledge.pk2.Once, knowledge.pk2 is opened find “res” & expands it. Then expand “item” —> “china”—> “weapon”. This picture has been resized. Click this bar to view the full picture. The original picture is sized 823×316. Then find spear_05.bsr & spear_08.bsr & extract them. This picture has been resized. Click this bar to view the full picture. The original picture is sized 823×292. This picture has been resized. Click this bar to view the full picture. The original picture is sized 824×301. A notice will say that the extraction is a success. This picture has been resized. Click this bar to view the full picture. The original picture is sized 823×185.
Close the pk2 extractor & go to ur pk2 tools folder. There you will discover a folder name “Data”. Then, open knowledge folder then res–>item–>china–>weapon. In the weapon folder, u will find the extracted .bsr’s. Cut spear_08.bsr & paste it anywhere in your hard disk. Then rename spear_05.bsr to spear_08.bsr. Run pk2 editor. Open Knowledge.pk2. In the automatic single file update click on select file & open data/res/item/china/weapon. Select spear_08.bsr & hit OK. After pressing OK, hit Import. A notice will tell you that the import is a success.
After you are completed, you can now play silkroad. Alter the icon of the weapon and editing the way it looks is the same. Run pk2 extractor. Open media.pk2. Expand “icon”. Then expand item–>china–>weapon. Extract spear_05.ddj and spear_08.ddj. In the pk2 tools folder u will discover a folder named “Media”. Do the same as what u did in editing your weapon. Go inside media/icon/item/china/weapon/. Cut spear_08.ddj and paste it somewhere else. Rename spear_05.ddj to spear_08.ddj. Run Pk2 editor. Open media.pk2. Do the same as what you did in importing your renamed spear_08.bsr when you edit your weapon. Restore it.
Restoring is done when you want to return the weapon’s looks to normal. Copy and paste your back up. Paste it back to its original folder. Import it using Pk2 extractor.

How to Secure a Multiple Machine Server

Thursday, December 29th, 2011
The exploit is a basic misunderstanding of any of the server exes that can be connected to the DB – including the Certification manager & w/e you created or added to your network. By simple connection to any of them you can manage to get DB access & do whatever you need. So the issue is the connection that can be created to any of the exes from outside programs.
To fix it, first enable the Firewall. Any of the machines that have access to the DB should have their Firewall enabled. – This purely blocks any unwanted program from connecting to any of your programs/exes.
Then block the default settings of the executables. Block out any of the server exes from accepting outside connection on all of the machines you are using. This will stop any connection to them. This way no one even you will be able to launch anything that connects to them successfully.
Then permit the machines they need to connect to our DB. You ought to now permit your other machines to connect to your DB. This is due to that the Game Server for example must have a DB connection. So at the current moment you are allowing any computer to be able to connect to your DB. To generate a Scope of computers that ought to be allowed to do that you ought to enter them to the Scope tab of the rule. Now you ought to be able to run properly all of your machines with all of their executables, but at that point no will be able to connect to your server since you have blocked the login & game server ports.
Then permit the computers they need to connect. Now since they blocked all of the connections they ought to add the computers they need to permit to connect to us. Now you have created a rule for of your exes. This ought to be done for each & every specific exe that you need to run. Now it is time to add the computers they need to permit to connect to this exe. This is a must to any of the exes jogging in case you need to be able to make use of them. This ought to be done on all of the jogging machines to make definite you have secured any probable hole in the security.
Permit players to connect. This is done on the same principle as above, but this time you ought to enter the ports of your Login & Game Servers & you ought to not generate a scope of computers but leave the rule allowing any connection to these ports.
If you have done this right your server should be secure enough. At this point no one will be able to connect to anything but the Login and Game Servers.

The exploit is a basic misunderstanding of any of the server exes that can be connected to the DB – including the Certification manager & w/e you created or added to your network. By simple connection to any of them you can manage to get DB access & do whatever you need. So the issue is the connection that can be created to any of the exes from outside programs.
To fix it, first enable the Firewall. Any of the machines that have access to the DB should have their Firewall enabled. – This purely blocks any unwanted program from connecting to any of your programs/exes.
Then block the default settings of the executables. Block out any of the server exes from accepting outside connection on all of the machines you are using. This will stop any connection to them. This way no one even you will be able to launch anything that connects to them successfully.
Then permit the machines they need to connect to our DB. You ought to now permit your other machines to connect to your DB. This is due to that the Game Server for example must have a DB connection. So at the current moment you are allowing any computer to be able to connect to your DB. To generate a Scope of computers that ought to be allowed to do that you ought to enter them to the Scope tab of the rule. Now you ought to be able to run properly all of your machines with all of their executables, but at that point no will be able to connect to your server since you have blocked the login & game server ports.
Then permit the computers they need to connect. Now since they blocked all of the connections they ought to add the computers they need to permit to connect to us. Now you have created a rule for of your exes. This ought to be done for each & every specific exe that you need to run. Now it is time to add the computers they need to permit to connect to this exe. This is a must to any of the exes jogging in case you need to be able to make use of them. This ought to be done on all of the jogging machines to make definite you have secured any probable hole in the security.
Permit players to connect. This is done on the same principle as above, but this time you ought to enter the ports of your Login & Game Servers & you ought to not generate a scope of computers but leave the rule allowing any connection to these ports.
If you have done this right your server should be secure enough. At this point no one will be able to connect to anything but the Login and Game Servers.

How to Set up FTP with Guild Emblem

Wednesday, December 28th, 2011
First of all, you need to download both Filezilla client, and server.
After installing Filezilla server run it with interface. Login with its default settings.
Then Click “User”. Click “Add”. Fill in the box with your desired username. Give your account a password.
Now give your account a directory to manage/access. Now your FTP server is up, and ready to go you can now run FileZilla client, and login using your account, host_IP:username:password:port. Port is always 21 unless you change it. You can also access the files through web browser by using the following link: ftp: //You_IP/. It will ask for a login.
Now correctly configure FTP for Guild Emblems. Create a new folder name “SRO_CREST” at C:\ (Your Computer >> Local Disk). Now Start Filezilla Server with Interface (Start >> Filezilla server >> Filezilla server with interface). User >> Shared Folders >> Add >> Navigate to C:\SRO_CREST >> ok >> check all the boxes at the top right and apply.
Run Pk2Extractor navigate to Media.pk2 and open it. Now select Type.txt, and click extract.

First of all, you need to download both Filezilla client, and server. After installing Filezilla server run it with interface. Login with its default settings.Then Click “User”. Click “Add”. Fill in the box with your desired username. Give your account a password.
Now give your account a directory to manage/access. Now your FTP server is up, and ready to go you can now run FileZilla client, and login using your account, host_IP:username:password:port. Port is always 21 unless you change it. You can also access the files through web browser by using the following link: ftp: //You_IP/. It will ask for a login.
Now correctly configure FTP for Guild Emblems. Create a new folder name “SRO_CREST” at C:\ (Your Computer >> Local Disk). Now Start Filezilla Server with Interface (Start >> Filezilla server >> Filezilla server with interface). User >> Shared Folders >> Add >> Navigate to C:\SRO_CREST >> ok >> check all the boxes at the top right and apply.
Run Pk2Extractor navigate to Media.pk2 and open it. Now select Type.txt, and click extract.

Farming SP with kills or not

Wednesday, December 28th, 2011
Do skills have a big impact on farming SP? If you go light never ever max it. It’s a waste of sp after level 80/90, you’ll get shit for the amount of sp it costs.
It is said that you will gain much more from ice. 2nd imbue/ice wall/phy def/snow shield. Light gives you speed/phantom and parry, but speed can be fixed by pots/scrolls or a bard mate. Phantom is fun but with speed not that needed and parry can be fixed with alchemy and ice takes care of it.
Bow has crits and nice 1v one chance of survival with the back to back knockback at higher levels of coursework. Glaive has increased hp and badass weapons which hurt ALOT when you land a crit. Blader is the final tanker with the shield, def buffs, kd. At higher levels they get stats which actually also make them nice killing machines.
It’s really up to you, out of the three an archer will level the fastest and blader the slowest. Pick what you like and don’t let other people tell you what to pick.

Do skills have a big impact on farming SP? If you go light never ever max it. It’s a waste of sp after level 80/90, you’ll get shit for the amount of sp it costs.
It is said that you will gain much more from ice. 2nd imbue/ice wall/phy def/snow shield. Light gives you speed/phantom and parry, but speed can be fixed by pots/scrolls or a bard mate. Phantom is fun but with speed not that needed and parry can be fixed with alchemy and ice takes care of it.
Bow has crits and nice 1v one chance of survival with the back to back knockback at higher levels of coursework. Glaive has increased hp and badass weapons which hurt ALOT when you land a crit. Blader is the final tanker with the shield, def buffs, kd. At higher levels they get stats which actually also make them nice killing machines.
It’s really up to you, out of the three an archer will level the fastest and blader the slowest. Pick what you like and don’t let other people tell you what to pick.

Tips on setting up a server based on VSRO server files

Tuesday, December 27th, 2011
What you need are one serve (Windows XP/2003 Server/Windows 7/Windows 2008 Server/Windows 2008 Server r2), Microsoft .NET framework 3.5+, Microsoft SQL Server 2000/2005/2008/2008 r2, and Microsoft SQL Server Management Studio. For handling 1000 players with all regions working, you will need 2 machines. One of the machines must have at least core i5 processor, and 6 – 8 GB of RAM, second might be slower a bit.
You can get MSSQL 2008 express edition from official Microsoft website same as SSMS.  Anyway, after installing mssql server, get Server Files. Save all that files in a same folder on your hard disk, and extract them.
After you are done with setting up a mssql server, and restoring databases (i consider, database names will be SRO_VT_ACCOUNT, SRO_VT_SHARD, SRO_VT_SHARDLOG), you have to create 3 ODBC sources. Specify “SQL Server” as ODBC driver. Default language must be English for all databases.
Don’t forget to edit _Shard Service table, and change Shard ID to 64 in SRO_VT_ACCOUNT database.
After you are done with ODBC, you must configure your custom certification server to work with your database server. Just run 1 – Decompile file in its folder. It will decompile current packt.dat file, and save .ini files at “ini” folder. Open it and you will see few files, which you have to replace with those which you downloaded in another archive. After you are done, open your “srGlobalService.ini”, and configure it to work with your database server. Don’t forget, by default, mssql 2005 and 2008 does not bind on port 1433, they uses ODBC. You shouldn’t put “, 1433”, after your server hostname.
Do not make server capacity more than 1000 for now (i will tell why a bit later). Then you will have to change the IP addresses for binding certification server. For this, open srNoteType.ini, and change “wip” to your WAN ip, and “nip” to your local ip. After you are done with your common certification configs, run “2 – Compile.bat” file in order to make a new “packt.dat” file. After you are done with it, start third batch file.
Now, if the certification window starts, and shows a message, that says server successfully bound on port 32000, you are ready to begin configuring server.cfg in your main server files folder. If it doesn’t, you should be done something wrong (it should be IP in 99% of cases).
If you succeeded, open your server.cfg file in the main server files folder, and change all “Certification” IP addresses to your one. Take a look at SR_ShardManager and SR_GameServer configuration.
As you can see, there is a billing url at shard settings, which you will have to set up by installing a IIS server, and creating a website instance on some unused port running. Files you should put on your IIS website are in the beginning of post. Also, don’t forget to enable asp support in your IIS server; otherwise, it will not work.
You have to edit DBConnect.asp file with your MSSQL server security information. Don’t forget to edit your billing server url in your server.cfg. After you are done, you might try to start your server.
If you got everything running fine, you might try to start the service. For doing it, you have to download SMC, create a new server developer account, and log in using SMC.
For doing it, open your SSMSE, go to SRO_VT_ACCOUNT database, open TB_User table, and a new row with your account info there. For giving account a rights to access through SMC, you will have to change its “sec_primary” to 1, same as “sec_content”. Also, for connecting to SMC you will have to add your IP address to official IP ranges list.
For doing it, you have to edit _PrivilegedIP table in SRO_VT_ACCOUNT database (by default, it uses reverse integer “encryption”, but you can modify it to use normal IP ranges.
After you are done, restart your GatewayServer, if it was running while you were doing it.  Now you will have to edit your client side, you have to edit it with XVI32, Hex Workshop, or some other hexadecimal editor.

What you need are one serve (Windows XP/2003 Server/Windows 7/Windows 2008 Server/Windows 2008 Server r2), Microsoft .NET framework 3.5+, Microsoft SQL Server 2000/2005/2008/2008 r2, and Microsoft SQL Server Management Studio. For handling 1000 players with all regions working, you will need 2 machines. One of the machines must have at least core i5 processor, and 6 – 8 GB of RAM, second might be slower a bit.
You can get MSSQL 2008 express edition from official Microsoft website same as SSMS.  Anyway, after installing mssql server, get Server Files. Save all that files in a same folder on your hard disk, and extract them.
After you are done with setting up a mssql server, and restoring databases (i consider, database names will be SRO_VT_ACCOUNT, SRO_VT_SHARD, SRO_VT_SHARDLOG), you have to create 3 ODBC sources. Specify “SQL Server” as ODBC driver. Default language must be English for all databases.
Don’t forget to edit _Shard Service table, and change Shard ID to 64 in SRO_VT_ACCOUNT database.
After you are done with ODBC, you must configure your custom certification server to work with your database server. Just run 1 – Decompile file in its folder. It will decompile current packt.dat file, and save .ini files at “ini” folder. Open it and you will see few files, which you have to replace with those which you downloaded in another archive. After you are done, open your “srGlobalService.ini”, and configure it to work with your database server. Don’t forget, by default, mssql 2005 and 2008 does not bind on port 1433, they uses ODBC. You shouldn’t put “, 1433”, after your server hostname.
Do not make server capacity more than 1000 for now (i will tell why a bit later). Then you will have to change the IP addresses for binding certification server. For this, open srNoteType.ini, and change “wip” to your WAN ip, and “nip” to your local ip. After you are done with your common certification configs, run “2 – Compile.bat” file in order to make a new “packt.dat” file. After you are done with it, start third batch file.
Now, if the certification window starts, and shows a message, that says server successfully bound on port 32000, you are ready to begin configuring server.cfg in your main server files folder. If it doesn’t, you should be done something wrong (it should be IP in 99% of cases).
If you succeeded, open your server.cfg file in the main server files folder, and change all “Certification” IP addresses to your one. Take a look at SR_ShardManager and SR_GameServer configuration.
As you can see, there is a billing url at shard settings, which you will have to set up by installing a IIS server, and creating a website instance on some unused port running. Files you should put on your IIS website are in the beginning of post. Also, don’t forget to enable asp support in your IIS server; otherwise, it will not work.
You have to edit DBConnect.asp file with your MSSQL server security information. Don’t forget to edit your billing server url in your server.cfg. After you are done, you might try to start your server.
If you got everything running fine, you might try to start the service. For doing it, you have to download SMC, create a new server developer account, and log in using SMC.
For doing it, open your SSMSE, go to SRO_VT_ACCOUNT database, open TB_User table, and a new row with your account info there. For giving account a rights to access through SMC, you will have to change its “sec_primary” to 1, same as “sec_content”. Also, for connecting to SMC you will have to add your IP address to official IP ranges list.
For doing it, you have to edit _PrivilegedIP table in SRO_VT_ACCOUNT database (by default, it uses reverse integer “encryption”, but you can modify it to use normal IP ranges.
After you are done, restart your GatewayServer, if it was running while you were doing it.  Now you will have to edit your client side, you have to edit it with XVI32, Hex Workshop, or some other hexadecimal editor.

How to Change Loading Screens

Tuesday, December 27th, 2011
To do this, you need Pk2 Editor, Password for www.RageZone.com, DDJ_DDS Converter and Adobe Photoshop Plugin for DDS.
Extract the files you downloaded in somewhere on your Drive then go Open Pk2 Extractor and open your Media.pk2. Make a backup before modifying.
Go and Expand “Interface” and Click “Loading” and Extract all and all the files in Loading. It will Extracted to where your PK2 Extractor is located. Then you need to keep start_loading_02.ddj till start_loading_10.ddj. Then Delete the other files we don’t need it.
Now you got the DDJ Files then. Open DDJ and DDS Converter Click on “Directory”, then click on the three dots “[...]” and select the folder where your DDJ Files are located. Click on convert and there are your DDS files.
Now install the plugin for Photoshop so you can edit the DDS files. Once you did that, you can just edit the files (start_loading_02.ddj till start_loading_10.ddj) and save them again as DDS. After Editing the DDS Files then convert it back to DDJ. Then import them to the media.pk2. Open PK2 Editor and open your media.pk2. Use the Manual Single File import to make sure the files will get on the place you want. Click File -> Close.
After Successfully Edited/Modify Then Close the Pk2 Editor and Play and see your Edited Loading Screens. Credit goes to their Respected Owners.

To do this, you need Pk2 Editor, Password for www.RageZone.com, DDJ_DDS Converter and Adobe Photoshop Plugin for DDS.
Extract the files you downloaded in somewhere on your Drive then go Open Pk2 Extractor and open your Media.pk2. Make a backup before modifying.
Go and Expand “Interface” and Click “Loading” and Extract all and all the files in Loading. It will Extracted to where your PK2 Extractor is located. Then you need to keep start_loading_02.ddj till start_loading_10.ddj. Then Delete the other files we don’t need it.
Now you got the DDJ Files then. Open DDJ and DDS Converter Click on “Directory”, then click on the three dots “[...]” and select the folder where your DDJ Files are located. Click on convert and there are your DDS files.
Now install the plugin for Photoshop so you can edit the DDS files. Once you did that, you can just edit the files (start_loading_02.ddj till start_loading_10.ddj) and save them again as DDS. After Editing the DDS Files then convert it back to DDJ. Then import them to the media.pk2. Open PK2 Editor and open your media.pk2. Use the Manual Single File import to make sure the files will get on the place you want. Click File -> Close.
After Successfully Edited/Modify Then Close the Pk2 Editor and Play and see your Edited Loading Screens. Credit goes to their Respected Owners.

Tips on Securing Your Server

Monday, December 26th, 2011
It is difficult to secure the servers. Here are some tips which help you with this problem.
In this post we will take Windows RC2 for example but you can still probably get the same idea working on windows or Linux or Mac or whatever the hell you use to run your server on!
First Turn on your windows firewall. Run mmc.exe. Click on New Rule and then Choose Protocols and Ports. Then Click Next, TCP, and Specific Local Ports. Then Type 15880, 15882, 15885, 15883, 32000, 8080, 1433, 3306. Then Click Next to Block the Connection. Then Click Next to where you can put a Name and description. After putting the Name and description, then Click Finish. So now you closed down all the ports that are open to public, you can verify this by using an online port scanner! Checker verifies that all these ports are closed! You don’t ever need a reason to have them open in the first place
The Make your SQL Connection Local. Run SqlSAC.exe. Then Click on Surface Area Configuration for services and connections, then Remote Connections and finally OK. This will pretty much make your remote connection local, so if anyone knows your database username or password you will never be hacked because they can’t do shit with it anyways as your sql/port are all local host. This is only for 2005 express not 2008 rc2.
Finally Make your ODBC Connection Local. Run odbcad32.exe. This will make your ODBC connection local, so there are methods where it was easy to just open your certificate and get the connection information of your odbc/sql data but this should help fix that!

It is difficult to secure the servers. Here are some tips which help you with this problem.
In this post we will take Windows RC2 for example but you can still probably get the same idea working on windows or Linux or Mac or whatever the hell you use to run your server on!
First Turn on your windows firewall. Run mmc.exe. Click on New Rule and then Choose Protocols and Ports. Then Click Next, TCP, and Specific Local Ports. Then Type 15880, 15882, 15885, 15883, 32000, 8080, 1433, 3306. Then Click Next to Block the Connection. Then Click Next to where you can put a Name and description. After putting the Name and description, then Click Finish. So now you closed down all the ports that are open to public, you can verify this by using an online port scanner! Checker verifies that all these ports are closed! You don’t ever need a reason to have them open in the first place
The Make your SQL Connection Local. Run SqlSAC.exe. Then Click on Surface Area Configuration for services and connections, then Remote Connections and finally OK. This will pretty much make your remote connection local, so if anyone knows your database username or password you will never be hacked because they can’t do shit with it anyways as your sql/port are all local host. This is only for 2005 express not 2008 rc2.
Finally Make your ODBC Connection Local. Run odbcad32.exe. This will make your ODBC connection local, so there are methods where it was easy to just open your certificate and get the connection information of your odbc/sql data but this should help fix that!