vSRO Server Files Installation Guide (Full Professional Setup 2026)​

System Requirements

• OS: Windows Server 2012 / 2016 / 2019 / Windows 10 Pro
• CPU: 4 Cores (8 Core Recommended)
• RAM: Minimum 8 GB (16–32 GB Recommended)
• Disk: SSD Recommended
• Network: Static IP / VPS

Required Files & Tools

• vSRO Server Files (1.188 / 1.274)
• Matching Client Version
• Database Backup (.bak)
• SQL Server (2008 R2 / 2012 / 2014)
• SQL Server Management Studio (SSMS)
• Visual C++ Redistributables (x86 + x64)
• .NET Framework 3.5 + 4.0+
• SMC Tool
• Media.pk2 / Media Patcher
• IP Input Tool
• PK2 Editor
• Certification Files

STEP 1: SQL SERVER SETUP

• Install SQL Server + SSMS
• Enable Mixed Authentication Mode

Restore Databases

SRO_VT_ACCOUNT
SRO_VT_SHARD
SRO_VT_SHARDLOG
SRO_VT_LOG

DB Owner Fix

EXEC sp_changedbowner 'sa'

STEP 2: SQL AUTH SETTINGS

• Server Properties → Security
• Enable SQL Server and Windows Authentication Mode
• Restart SQL Service

STEP 3: ODBC SETUP (32 BIT ONLY)

• Open ODBC Data Sources (32-bit)
• Create System DSN:

SRO_VT_ACCOUNT
SRO_VT_SHARD
SRO_VT_LOG

SQL Server Native Client / ODBC Driver 17+

sa / password

STEP 4: SERVER CONFIG FILES

cert.ini

CertificationIP = YOUR_SERVER_IP

machine.ini

YOUR_SERVER_IP

host.cfg

YOUR_SERVER_IP

GlobalManager.ini

127.0.0.1

STEP 5: OPEN PORTS

15779
15880
15884
15777
32000+

STEP 6: SERVER START ORDER

1. Certification Server
2. Global Manager
3. Machine Manager
4. Gateway Server
5. Download Server
6. Farm Manager
7. SR_ShardManager
8. SR_GameServer

Sıra çok önemli!

STEP 7: GM ACCOUNT

USE SRO_VT_ACCOUNT

INSERT INTO TB_User (StrUserID, password)
VALUES ('admin', '123456')

USE SRO_VT_SHARD

INSERT INTO _PrivilegedUser (UserJID, Privilege)
VALUES (
(SELECT JID FROM SRO_VT_ACCOUNT.dbo.TB_User WHERE StrUserID = 'admin'),
1
)

STEP 8: CLIENT SETUP

• Open client folder
• Run Media Patcher
• Set IP to YOUR_SERVER_IP

divisioninfo.txt
gatewayserver.txt

ADMIN TOOLS

• SMC Tool → Server control
• Media Patcher → IP change
• IP Input Tool → PK2 fast edit
• PK2 Editor → Item/Mob edit

COMMON ERRORS

• C9 / C8 → Wrong IP or Media.pk2 mismatch
• Login Failed → SQL / ODBC issue
• Agent Crash → Missing VC++ or version mismatch
• Server Not Starting → SQL / Ports / ODBC check

OPTIMIZATION

• Use SSD
• Disable SQL auto logs
• Clean VPS recommended

DBCC SHRINKDATABASE

FINAL CHECK

• All services running
• No errors in logs
• Client connects
• Character creation works
• Stable gameplay