--THE magnet link

magnet:?xt=urn:btih:938c769ec2beee7c7f381570b93a861a60bd4fe5&dn=i25Binaries_InsurancePolicy.7z

--General setup of the VM and applications

1) Download VMWare Player (Free for non commercial) https://www.vmware.com/products/workstation-player/workstation-player-evaluation.html
2) Setup VM With Win7+, make sure to install VMware Tools (will let you get 3d acceleration and launch CoH within the VM itself)
3) Download SSMS - https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017
4) Download SQL Setup - https://www.microsoft.com/en-gb/sql-server/sql-server-editions-express
5) Once VM running, install 3 and 4.
6) Transfer NaughtyName.7z to VM, unzip and move all files to C:/COH (From i25 release)
7) Unzip dbschema and run each .sql files
8) Change sql from C:\mssql\MSSQL11.SCORE\MSSQL to C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL
8A) Open SSMS and use default connetion
8B) Right-click properties of \SQLEXPRESS DB
8C) Navigate to Security and select "SQL Server and Windows Authentication mode"
8D) Click ok and open Security (under databases folder) 8E) Right click and new login
8F) Enter a name, select sql server authentication, enter a password
8G) Open User Mapping
8H) Select all COH ones and choose "db_owner" and then ok.
9) Edit servers.cfg to include connection string Server=localhost\SQLEXPRESS;Database=cohdb;User Id=NAME;Password=yourpassword;
10) Change all other .cfg files to include connection string
11) DBServer needs to be 127.0.0.1 12) LocalIP also 127.0.0.1 13) Comment out AuthServer (add //) 14) Add UseFakeAuth 1 15) Run DBserver 16) ignore first error (loadbalanceshard) 17) Run Launcher!

--Launching CoH and pointing it to the server (127.0.0.1 is local, set it to the approperate server otherwise), note "Score.exe" is i25

score.exe -db 127.0.0.1 -console -patchdir score -noversioncheck -project "coh"

--More info on setting up the SQL Server
Go install SQL Express 2017 (or Express 2012)
When installing, choose basic
Click the button that says Install SSMS (this is SQL Server Management Studio)
Install SSMS
Start SSMS
Connect

//I am running this on a burner VM so I disabled my firewall, but TCP networking just in case
Start up SQL Server Config Manager, find "Protocols for SQLEXPRESS" and enable TCP/IP
Right click TCP/IP and click Properties
Click on IP Addresses Tab
Scroll down and under IPAll set TCP Dynamic Ports to blank(clear it out)
then set TCP Port to 1433

Go find I25 Release>data>server>db>servers.cfg and follow
https://docs.google.com/document/d/1keKkCFJW6lddheLkqhShAeDEHay89uVMfUZlYrXhJKg/edit
at the Dbserver setup section, starting at
* Modify coh-server-original\bin\data\server\db\servers.cfg to look like:

NOTE:
SqlLogin "Driver={SQL Server Native Client 11.0};server=localhost;database=coh;trusted_connection=Yes;"
Depending on your express install, this needs to be changed
for 2017 Express,
SqlLogin "Driver={ODBC Driver 13 for SQL Server};server=localhost;database=coh;trusted_connection=Yes;"
for 2012 Express, leave as is

Start dbserver.exe
start launcher.exe