Junior Spellweaver
- Joined
- Dec 29, 2016
- Messages
- 188
- Reaction score
- 132
To view the content, you need to sign in or register
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 :
To view the content, you need to sign in or register
Microsoft SQL 2017 Developer Edition :
To view the content, you need to sign in or register
SoulWorker Server Files- Repack :
To view the content, you need to sign in or register
SoulWorker DB Files :
To view the content, you need to sign in or register
SoulWorker Client Files- Repack :
To view the content, you need to sign in or register
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
To view the content, you need to sign in or register
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
To view the content, you need to sign in or register
When it's done, you should recieve the Server Installation Center, proceed to click on the very first selection for the Standalone Installation.
To view the content, you need to sign in or register
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
To view the content, you need to sign in or register
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.
To view the content, you need to sign in or register
When the wizard is successfully set up. Find the SQL Configuration Manager and run it.
To view the content, you need to sign in or register
Search for Protocols for your Server, and highlight the TCP/IP field. Right click on it and Select Properties.
To view the content, you need to sign in or register
Please ensure that both Enabled and Listen All is set to Yes, Apply.
To view the content, you need to sign in or register
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.
To view the content, you need to sign in or register
After installation, find the SQL Server Management Tools and run it.
To view the content, you need to sign in or register
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.
To view the content, you need to sign in or register
After a successful connection. Head over to the Object Explorer and Right click on Databases. You will need to make new databases.
To view the content, you need to sign in or register
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]
To view the content, you need to sign in or register
For each database, make a new query.
To view the content, you need to sign in or register
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.
To view the content, you need to sign in or register
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
To view the content, you need to sign in or register
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
To view the content, you need to sign in or register
The instructions are provided here. Please read the instructions closely and properly set up your IPs, Ports, Database user ID and Password.
To view the content, you need to sign in or register
If done successfully, it should look like this.
To view the content, you need to sign in or register
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...
To view the content, you need to sign in or register
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
To view the content, you need to sign in or register
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.
To view the content, you need to sign in or register
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.
To view the content, you need to sign in or register
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
To view the content, you need to sign in or register
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
![Flipend0 - [Tutorial] Soul Worker Server + Client Setup Guide - RaGEZONE Forums](https://media.discordapp.net/attachments/792578545494392862/793427192499273748/unknown.png?width=551&height=413 "Flipend0 - [Tutorial] Soul Worker Server + Client Setup Guide - RaGEZONE Forums")
![Captur - [Tutorial] Soul Worker Server + Client Setup Guide - RaGEZONE Forums](/data/attachments/108/108396-84145520737aa3d3d03c1f20c177f97a.jpg?hash=Cvxin3WvN0)
