Junior Spellweaver
- Joined
- Dec 29, 2016
- Messages
- 180
- Reaction score
- 101
You must be registered to see links
SoulWorker Server + Client Setup Guide
Revision 3
Author By : Flipend0
Code:
Special Thanks to the following members:
[LEFT]- jivori : Release of the server files
- Darnell : Successfully setting up the server, Added comments to configuration, Helpful Advice on MS-SQL, Providing me a test VM to help make the tutorial
- Rulake : Successfully setting up the server, Helpful Advice on MS-SQL
- Prozaks : Repaired tb_Buff.res, Fixed Dipluce horizon and Grasscover Camp, Ported EN translation to JP Client (with help from the SWHQ Translation Team)
- b_ : Query fix for logging in the channel after character creation[/LEFT]
Introduction
Welcome to the SoulWorker Server + Client Setup Tutorial. In this guide we will learn how to properly setup the server files that was provided
to us. Starting from a Clean Windows installation and ending to a successful client login to play. Due note that this is a very basic guide to setup
the server in a localhost enviroment. If you are expecting to host an actual private server you should know as a server administrator to properly handle
IP and Ports.
Let's begin.
STEP 1 : Required Files
You will need the following files to start.
Windows Server OS 2016 :
You must be registered to see links
Microsoft SQL 2017 Developer Edition :
You must be registered to see links
SoulWorker Server Files- Repack :
You must be registered to see links
SoulWorker DB Files :
You must be registered to see links
SoulWorker Client Files- Repack :
You must be registered to see links
NOTE: You don't have to do it on a clean windows installation, But it is recommended.
After downloading all the files required. Set up your Server OS 2016 and boot up the machine.
STEP 2 : MS-SQL Installation
You must be registered to see links
After you've installed Windows. Launch the SQL 2017 Developer Installation
Select Custom, and proceed to the next field. SQL will now start installing to your system
You must be registered to see links
When it's done, you should recieve the Server Installation Center, proceed to click on the very first selection for the Standalone Installation.
You must be registered to see links
You will now be presented to the SQL Setup Wizard. Proceed to the next fields as normal until you reach to the Feature Selection field.
In here, you will need to check the box for "Database Engine Service", Proceed to click next until you hit the Database Engine Configuration
You must be registered to see links
In this area, select "Mixed Mode" and click on "Add Current User". Input your password for the Database, Please remember your password as it will be needed
later on in the tutorial.
Proceed to click next and finalize the setup wizard.
You must be registered to see links
When the wizard is successfully set up. Find the SQL Configuration Manager and run it.
You must be registered to see links
Search for Protocols for your Server, and highlight the TCP/IP field. Right click on it and Select Properties.
You must be registered to see links
Please ensure that both Enabled and Listen All is set to Yes, Apply.
You must be registered to see links
Now it's time to go back to the Server Installation Center. This time, you must Install the SQL Server Management Tools.
Proceed with the installation as normal. If it tells you to reboot after installation, please do so.
You must be registered to see links
After installation, find the SQL Server Management Tools and run it.
You must be registered to see links
You will be presented to the SQL Server Login.
The server name will be your localhost or IP of choice
the Login ID is usually "sa"
the password is the DB password you set up previously from the Wizard.
Proceed to connect.
You must be registered to see links
After a successful connection. Head over to the Object Explorer and Right click on Databases. You will need to make new databases.
You must be registered to see links
Input the following fields for Database Name and click on OK
The names must be inputted each time :
Code:
[LEFT]AccountDB
CommonDB
GameDB
GMToolDB
LogDB[/LEFT]
You must be registered to see links
For each database, make a new query.
You must be registered to see links
From the DB folder extracted, you'll find the SQL files.
For each database, open the SQL file with Notepad and Copy-Paste the text to the query window.
Press Execute the query after copy-pasting. Perform this for each Database.
NOTE : Is is normal to see errors in Common, Log, and GameDB.
You must be registered to see links
Last but not least, Execute this query here
Code:
EXEC sp_addlinkedserver @[I][B][URL="http://forum.ragezone.com/members/412249.html"]Server[/URL][/B][/I]='LAccountDB',
@srvproduct=N'',
@[I][B][URL="http://forum.ragezone.com/members/524049.html"]Pro[/URL][/B][/I]vider=N'SQLNCLI',
@[I][B][URL="http://forum.ragezone.com/members/2000292918.html"]DaTa[/URL][/B][/I]src=N'127.0.0.1';
exec sp_serveroption @[I][B][URL="http://forum.ragezone.com/members/412249.html"]Server[/URL][/B][/I]='LAccountDB' , @optname= 'rpc', @optvalue ='TRUE'
exec sp_serveroption @[I][B][URL="http://forum.ragezone.com/members/412249.html"]Server[/URL][/B][/I]='LAccountDB' , @optname= 'rpc out', @optvalue='TRUE'
After this, you are now done with the MS-SQL configuration.
STEP 3 : Server Configuration
You must be registered to see links
Now you must navigate to your server files. Head over there and find the config file that's located from the config folder, Edit the file
You must be registered to see links
The instructions are provided here. Please read the instructions closely and properly set up your IPs, Ports, Database user ID and Password.
You must be registered to see links
If done successfully, it should look like this.
You must be registered to see links
Once the config is complete, run sw_server_start.bat
I recommend you take a 15 minute break after running this, it'll take a while for the server to start up...
You must be registered to see links
If done successfully, it should look like this.
NOTE : Is is normal to see missing AI and ActionData files on the GameServer Init.
After this, you are now done with the Server configuration.
STEP 4 : Client Configuration
You must be registered to see links
On your client, there is a file called start_sw.bat.
You may choose to edit the bat file and change the IP and Port if desired to do so
Otherwise, go head and run the bat file, this will start the game client.
You must be registered to see links
The SQL procedure for login is set up to handle Auto-Registration by default.
To perform Auto-Registration, Enter your ID and Pass on the login screen.
Wait for 2 minutes, then proceed to log in again.
You must be registered to see links
If successful, you'll now be at the server select screen.
Currently, there's no way to define the name of the server at the moment. By default it will show the IP instead.
Proceed to log into the server
You must be registered to see links
If everything goes well, you should now be able to play Soulworker.
That's about it. I hope this tutorial explains well enough on how to set up the server.
I expect to see some SoulWorker private servers after this, I'll be interested in trying them out
Good Luck