Getting Started

Server Setup

Download Files

• i25 Binaries Torrent
• SQL Express Edition
• SQL Management Studio

Setup Local Server

• Install SQL Server 2017 Express Edition
• Choose Basic when installing and when given the option choose to install SSMS.
• Open up wherever you extracted the i25 Binaries folder and navigate to data\server\db
• Open up chat_server.cfg and account_server.cfg

You will see something like this.

SqlLogin "DRIVER={SQL Server Native Client 11.0};Server=NS319069\SCORE;Uid=sa;Pwd=FinallyFree!;"

Change this to

SqlLogin "DRIVER={SQL Server Native Client 11.0};Server=localhost\SQLEXPRESS;Uid=sa;Pwd=password;"

• You can change the password to whatever you would like. For this example I will be just using password.
• Now open up server.cfg and change all the ips to localhost (Note : You could also set these to your local ip if you know it.)

At the top of the file you will see this.The IP will be set to whatever you previous set it to.

DBServer 192.168.0.1 18717

ShardName Bree

AuthServer 192.168.0.1 2104

DefaultAccessLevel 0

NoStats 1

• Change the ShardName to whatever you would like and add 2 slashes infront of AuthServer. And add UseFakeAuth 1 under NoStats 1

It should now look like this

DBServer localhost 18717

ShardName ShardName

//AuthServer 192.168.0.1 2104

DefaultAccessLevel 0

NoStats 1

UseFakeAuth 1

• Okay now extract the dbschema.rar found in your i25 folder. We will be using these later.
• Open up SQL Server Management Studio (SSMS which you installed in the first step). Your one will look slightly different and hit Connect.
• Now we have to enable SQL logins so that the databases can connect. We need to enable them and the sa login so that user can login to the database.
• If you look to the left panel you will see the object explorer and your connection. Right click it and enter properties.
• When this window comes up hit Security to the left and enable sql server and windows authentication. Then click ok.
• In the same panel you used before navigate to Security -> Logins then right click and enter properties the sa user.
• In this window set the password to the same password you set back at step 4
• Once you are done there. Choose Status from the left panel in this same window and set login to enabled and hit ok.
• Okay now navigate back to your i25 folder and open the dbschema folder I previously had you extract and open up cohauc.sql in SQL Server Management Studio.
• You will see these 2 lines at the top of the file opened
  • ( NAME = N'cohauc', FILENAME = N'C:\mssql\MSSQL11.SCORE\MSSQL\DATA\cohauc.mdf' , SIZE = 157440KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
  • ( NAME = N'cohauc_log', FILENAME = N'C:\mssql\MSSQL11.SCORE\MSSQL\DATA\cohauc_log.ldf' , SIZE = 353216KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
• What you want to do is set the first part of these directory listings to where your SQL Server is located for example, I set my to D:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL because that is where my SQL Server is. So my would become:
  • ( NAME = N'cohauc', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\cohauc.mdf' , SIZE = 157440KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
  • ( NAME = N'cohauc_log', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\cohauc_log.ldf' , SIZE = 353216KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
• Once done click the Execute button. And do this again for both the cohauth and cohchat.
• Once you have done that you can now start up your server. Navigate back to your i25 files and start up dbserver and dblauncher
  • Note : you will have to fix up these shortcuts so they point back to their intended destinations.
• Go to your City of Heroes folder and make a shortcut of score.exe adding
  • score.exe -db 127.0.0.1 -console -patchdir score -noversioncheck -project "coh"
• Login and Enjoy!