OK so I see a lot of asks on here for a new guide to install a Shaiya Server.
Really there is no difference in how to do it. Its been virtually the same all these years. However, it is a good idea to have something fairly new, in a way so... here you go :)
[EDIT]: I used EP4 Database and files for this tutorial.
First you need to install SQL obviously. 2008 is the preferred choice. but you can use a newer version. There are a few key steps to installing SQL, so read carefully.
Security Tip : TURN OFF FIREWALL
1. Run SQL Setup and choose New Installation. Follow the step until you get to Feature Selection. Make sure to Select all, then hit Next.
[Only registered and activated users can see links. Click Here To Register...]
2. Keep going until you see Instance Configuration. You NEED to select Default Instance so the Instance ID reads MSSQLSERVER
[Only registered and activated users can see links. Click Here To Register...]
3. Continue on to Database Engine Configuration. Click on Mixed Mode Authentication, and enter a password to use for your Shaiya Server. (REMEMBER THIS PASSWORD)
[Only registered and activated users can see links. Click Here To Register...]
4. Next step is Reporting Services Configuration. If you don't have this option, that is fine, just go to the next step.
For this one I clicked Install but not Configure. I don't really think it matters anyway.
[Only registered and activated users can see links. Click Here To Register...]
5. Let the Installation complete. Once its finished, open SQL Configuration Manager. Expand the columns and click each one to view. The ones that are disabled, need to be enabled... All of them.
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
6. Once all are enabled, go back to Protocols for MSSQLSERVER, right click TCP/IP and go to properties.
Click the IP Addresses tab, scroll down until you find the local IP (127.0.0.1) and enable it. The Port should be 1433.
[Only registered and activated users can see links. Click Here To Register...]
WARNING: DO NOT CHANGE ANYTHING ELSE IN HERE OR YOU WILL INSTANTLY SCREW UP YOUR SERVER
Click OK.
7. Go to the top and click SQL Server Services. Now right click SQL Server (MSSQLSERVER) and restart.
[Only registered and activated users can see links. Click Here To Register...]
Wait for the service to Stop.
Wait for the service to Start.
Close SQL Configuration Manager.
8. Create a shortcut to SQL Server Management Studio on the Desktop, it will help, trust me. Then right click it and go to the Compatibility tab. Tick the box which reads Run as administrator. Click OK
[Only registered and activated users can see links. Click Here To Register...]
NEXT STEP : Database Setup
Now the easiest part - we will get the Database attached and setup.
1. Open SQL Server Management Studio. Login with Windows Authentication.
2. On the left pane, Right click on Databases, then click Attach.
[Only registered and activated users can see links. Click Here To Register...]
3. Click Add.
[Only registered and activated users can see links. Click Here To Register...]
4. Go to the Database Folder Location, and select all the databases you need. You will need to open them 1 at a time.
[Only registered and activated users can see links. Click Here To Register...]
5. Once you have them all in the list, Click OK to start the attach process.
[Only registered and activated users can see links. Click Here To Register...]
6. Now your Database is attached.
[Only registered and activated users can see links. Click Here To Register...]
If your Database won't attach and you get an error, go back to the top of this tut and read carefully. You should have no issues what-so-ever if you follow this tut step by step.
[EDIT]: You might need to attach Billing to SQL. I don't use Billing with my DB at all.
NEXT STEP : Server Setup
To setup the Server we need to do a few things.
1. Lets go to the C Drive. You should have the server files already, if not, use the search. The main folder is called ShaiyaServer (no spaces)
Inside here are 2 more Folders we need to focus on. PSM_Client and PSM_Server.
[Only registered and activated users can see links. Click Here To Register...]
2. Lets go to PSM_Server. in here you have a file called ps_passwordEnc
Open it.
[Only registered and activated users can see links. Click Here To Register...]
3. Enter your SQL Password we created earlier in the top box. Then highlight (select) all the long text in the bottom box. Copy it, we need this.
[Only registered and activated users can see links. Click Here To Register...]
4. Back to the ShaiyaServer Folder, lets go ahead and open PSM_Client.
Then open Bin, Open Config. In here you should have 6 INI files. If you have a 7th one, its gamewar and you most likely wont need it.
[Only registered and activated users can see links. Click Here To Register...]
5. Open each one and make your changes. The long text we copied, needs to replace the ones currently in the INIs.
[Only registered and activated users can see links. Click Here To Register...]
You may change the GameName= in ps_game and ps_session INIs to your Server Name.
For ps_game, If you are running this server local, the GamePublicIP= needs to stay 127.0.0.1. If you are running this as a public Server, put YOUR IP ADDRESS.
6. Once you edit all 6 INIs, saving each one upon close, we will head back to PSM_Client. In here you will see PSM_AgentInstall. Run it.
[Only registered and activated users can see links. Click Here To Register...]
7. Click OK.
[Only registered and activated users can see links. Click Here To Register...]
Now Click Apply Windows Registry, then Click OK. Don't restart the machine.
[Only registered and activated users can see links. Click Here To Register...]
8. Go back to PSM_Server and locate PSMServer_AgentInstall and run it.
[Only registered and activated users can see links. Click Here To Register...]
Same as before, Click OK.
[Only registered and activated users can see links. Click Here To Register...]
9. To launch the Server Manager, open PSMServer_Mgr from PSM_Server folder.
[Only registered and activated users can see links. Click Here To Register...]
NEXT STEP : Server Manager Setup
If you have followed the first 3 steps correctly, when you open Server Manager, you should see Green X's
[Only registered and activated users can see links. Click Here To Register...]
To turn on the server all you need to do it the following:
1. Click Server Setup menu up the top, and click Service Install All.
[Only registered and activated users can see links. Click Here To Register...]
Click Yes.
[Only registered and activated users can see links. Click Here To Register...]
The services will turn to Green Pause icons.
[Only registered and activated users can see links. Click Here To Register...]
2. Next we click Control Service menu and then click Start All Server Service.
[Only registered and activated users can see links. Click Here To Register...]
Yes again.
[Only registered and activated users can see links. Click Here To Register...]
And your Server should now have green arrows, meaning your server is up and running.
[Only registered and activated users can see links. Click Here To Register...]
Hit the Thank you Button if this was helpful to you.
If you do have any issues along the way, its most likely because you have missed something. Read the tut again and see what you forgot. If you still have issues, reply here and I will help out when I can :)
Thank you for reading. Happy Developing :)
Really there is no difference in how to do it. Its been virtually the same all these years. However, it is a good idea to have something fairly new, in a way so... here you go :)
[EDIT]: I used EP4 Database and files for this tutorial.
First you need to install SQL obviously. 2008 is the preferred choice. but you can use a newer version. There are a few key steps to installing SQL, so read carefully.
Security Tip : TURN OFF FIREWALL
1. Run SQL Setup and choose New Installation. Follow the step until you get to Feature Selection. Make sure to Select all, then hit Next.
[Only registered and activated users can see links. Click Here To Register...]
2. Keep going until you see Instance Configuration. You NEED to select Default Instance so the Instance ID reads MSSQLSERVER
[Only registered and activated users can see links. Click Here To Register...]
3. Continue on to Database Engine Configuration. Click on Mixed Mode Authentication, and enter a password to use for your Shaiya Server. (REMEMBER THIS PASSWORD)
[Only registered and activated users can see links. Click Here To Register...]
4. Next step is Reporting Services Configuration. If you don't have this option, that is fine, just go to the next step.
For this one I clicked Install but not Configure. I don't really think it matters anyway.
[Only registered and activated users can see links. Click Here To Register...]
5. Let the Installation complete. Once its finished, open SQL Configuration Manager. Expand the columns and click each one to view. The ones that are disabled, need to be enabled... All of them.
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
6. Once all are enabled, go back to Protocols for MSSQLSERVER, right click TCP/IP and go to properties.
Click the IP Addresses tab, scroll down until you find the local IP (127.0.0.1) and enable it. The Port should be 1433.
[Only registered and activated users can see links. Click Here To Register...]
WARNING: DO NOT CHANGE ANYTHING ELSE IN HERE OR YOU WILL INSTANTLY SCREW UP YOUR SERVER
Click OK.
7. Go to the top and click SQL Server Services. Now right click SQL Server (MSSQLSERVER) and restart.
[Only registered and activated users can see links. Click Here To Register...]
Wait for the service to Stop.
Wait for the service to Start.
Close SQL Configuration Manager.
8. Create a shortcut to SQL Server Management Studio on the Desktop, it will help, trust me. Then right click it and go to the Compatibility tab. Tick the box which reads Run as administrator. Click OK
[Only registered and activated users can see links. Click Here To Register...]
NEXT STEP : Database Setup
Now the easiest part - we will get the Database attached and setup.
1. Open SQL Server Management Studio. Login with Windows Authentication.
2. On the left pane, Right click on Databases, then click Attach.
[Only registered and activated users can see links. Click Here To Register...]
3. Click Add.
[Only registered and activated users can see links. Click Here To Register...]
4. Go to the Database Folder Location, and select all the databases you need. You will need to open them 1 at a time.
[Only registered and activated users can see links. Click Here To Register...]
5. Once you have them all in the list, Click OK to start the attach process.
[Only registered and activated users can see links. Click Here To Register...]
6. Now your Database is attached.
[Only registered and activated users can see links. Click Here To Register...]
If your Database won't attach and you get an error, go back to the top of this tut and read carefully. You should have no issues what-so-ever if you follow this tut step by step.
[EDIT]: You might need to attach Billing to SQL. I don't use Billing with my DB at all.
NEXT STEP : Server Setup
To setup the Server we need to do a few things.
1. Lets go to the C Drive. You should have the server files already, if not, use the search. The main folder is called ShaiyaServer (no spaces)
Inside here are 2 more Folders we need to focus on. PSM_Client and PSM_Server.
[Only registered and activated users can see links. Click Here To Register...]
2. Lets go to PSM_Server. in here you have a file called ps_passwordEnc
Open it.
[Only registered and activated users can see links. Click Here To Register...]
3. Enter your SQL Password we created earlier in the top box. Then highlight (select) all the long text in the bottom box. Copy it, we need this.
[Only registered and activated users can see links. Click Here To Register...]
4. Back to the ShaiyaServer Folder, lets go ahead and open PSM_Client.
Then open Bin, Open Config. In here you should have 6 INI files. If you have a 7th one, its gamewar and you most likely wont need it.
[Only registered and activated users can see links. Click Here To Register...]
5. Open each one and make your changes. The long text we copied, needs to replace the ones currently in the INIs.
[Only registered and activated users can see links. Click Here To Register...]
You may change the GameName= in ps_game and ps_session INIs to your Server Name.
For ps_game, If you are running this server local, the GamePublicIP= needs to stay 127.0.0.1. If you are running this as a public Server, put YOUR IP ADDRESS.
6. Once you edit all 6 INIs, saving each one upon close, we will head back to PSM_Client. In here you will see PSM_AgentInstall. Run it.
[Only registered and activated users can see links. Click Here To Register...]
7. Click OK.
[Only registered and activated users can see links. Click Here To Register...]
Now Click Apply Windows Registry, then Click OK. Don't restart the machine.
[Only registered and activated users can see links. Click Here To Register...]
8. Go back to PSM_Server and locate PSMServer_AgentInstall and run it.
[Only registered and activated users can see links. Click Here To Register...]
Same as before, Click OK.
[Only registered and activated users can see links. Click Here To Register...]
9. To launch the Server Manager, open PSMServer_Mgr from PSM_Server folder.
[Only registered and activated users can see links. Click Here To Register...]
NEXT STEP : Server Manager Setup
If you have followed the first 3 steps correctly, when you open Server Manager, you should see Green X's
[Only registered and activated users can see links. Click Here To Register...]
To turn on the server all you need to do it the following:
1. Click Server Setup menu up the top, and click Service Install All.
[Only registered and activated users can see links. Click Here To Register...]
Click Yes.
[Only registered and activated users can see links. Click Here To Register...]
The services will turn to Green Pause icons.
[Only registered and activated users can see links. Click Here To Register...]
2. Next we click Control Service menu and then click Start All Server Service.
[Only registered and activated users can see links. Click Here To Register...]
Yes again.
[Only registered and activated users can see links. Click Here To Register...]
And your Server should now have green arrows, meaning your server is up and running.
[Only registered and activated users can see links. Click Here To Register...]
Hit the Thank you Button if this was helpful to you.
If you do have any issues along the way, its most likely because you have missed something. Read the tut again and see what you forgot. If you still have issues, reply here and I will help out when I can :)
Thank you for reading. Happy Developing :)
