Grab the Latest SGW Server Files over here.
Grab the Latest SGW Client Patch here.

Prerequisites:

• x64 Windows OS (THIS WILL NOT WORK ON AN x86/32 bit PC, MUST BE x64)
  
• x64 Python 3.4. Download it here.
  
• Postgres, version 9.2 or 9.3. It can be grabbed here
  
• MSVC 2013 x64 (Microsoft VC redist package). Can be found here
  
• Navicat 10 Lite. Grab the link here
  
• Alternatively pgadmin or psql could be used also, however for this I'll be sticking to navicat lite.
• .rar software to extract the server rar
• Stargate Worlds QA client is properly configured (only works with QA Build). Click here on how to configure the client.

Once these programs have been downloaded, you are ready to set everything up.

Instructions:

1. Installations: We'll start off by installing postgres.

• When installing you'll be asked to enter a password, enter anything you want. However remember this password as it'll need to be used later on. Next it'll ask you for a port number if you know what you're doing and want to change it go ahead, if not leave it. Locale, leave it [Default locale]. The setup will then begin and finish.
• Now that postgres is installed, you must install navicat lite. Run the exe supplied, accept the agreements, leave default directories and click Install.
• Extract the server rar, to a directory. Can be wherever.
• Install Microsoft VC redist package, Python 3.4 64-bit. Both are simple installers, leave default directory, then click Install.

2. Setting Up / Configuring: Open Navicat, we'll be creating a configuring the server.

• Open Navicat and click the top left button "connection" and then select PostgresSQL.

Filling out the details, you must remember/write down these details.

• Connection Name: can be whatever you like. This doesn't really matter.
• Host Name/ IP Address: If you are running postgres on a seperate machine, change the IP if not, leave as localhost
• Port: leave as is, or change if you know what you're doing
• User Name: postgres, leave it
• Password: This is where you input your password from before when we installed postgres
• TEST CONNECTION: Test the connection using the button in the bottom left of the window. If successful move on, if not go back and repeat steps.
• Accept: Click OK to add the connection.

2.1 Creating new database & running SQL files to create tables.

• You should now have an 'SGW' (or whatever you named the connection) on the left panel in the program under 'Connections'. Double click it and then double click postgres so they are both expanded and their icons are coloured. Next right click on the "postgres" field and select new database. A window will then pop up telling you to specify the database name, encoding and a few other fields. Database Name field can be whatever you like (This name will be referenced later on in config files). and encoding must be UTF-8 and the other fields should be left blank. Finally click OK and it will create the new database.
• Next double click the database you just created to expand it, then doubleclick 'public' until you can see its contents and the icon next to 'public' is coloured.
• Once "public" is expanded and it's icon is coloured and not greyed out (coloured means the connection is open), right click public and click "Execute SQL File.."
• Click the button next to file and goto your server directory (where you unzipped the server files) and goto the "db" folder and select the resources.sql file.
• Leave the encoding as UTF-8 and click start. This step *may* take some time. After it's completed close the window.
• Right click again on 'public' and go back to the same folder however this time select and run 'sgw.sql', using the same settings as before such as UTF-8.

2.2 Configuring server to work & run with your machine.

• Open your unzippped server and head to the config folder.
• You're going to have to edit each .config file in this folder with notepad or a text editor of your choice, there are 3 .config files to edit (AuthenticationService.config , BaseService.config, CellService.config)
• In each .config file you must find the line that has "<db_connection_string>"
• Leave the value after 'host=' as localhost unless you're hosting a postgres on another machine.
• change the value after 'user=' from w-testing to postgres
• change the value after 'password=' from w-testing to whatever you specified before as the password during the postgres installation
• change the value after 'dbname=' to sgw to whatever you specified the as the new database name in Navicat.
• After changing these values, save the files and close them.

3. Running the server

Now to run the server, navigate to the bin64 folder in the server folder and execute the .exe files in this order:

• First run the 'AuthenticationServer' wait 5 seconds.
• Next run the 'BaseApp', wait 5 seconds
• Finally run the 'CellApp'..
• If you followed this tutorial correctly, this should all run and work. Congrats' your server is now up!

*Note you may see some yellow and red errors, this is normal - however unless the program crashes or says "database 'servernamehere' does not exist", then you should be fine. If the server still doesn't work, leave a post explaining your error in one of the forums here.

Finally in order to connect to a server or your server you must change a file within the SGW client, in case you didn't do this before, read how to do it here.