Hello everyone,
I am currently setting up a local **Rappelz Private Server (Epic 9.5.2)** using the **HatrickRepack** files. However, I am facing a persistent issue when launching the **Auth Server (PrincessAuroraServer.exe)** and would greatly appreciate any assistance from experienced developers.
## Environment Details
* **Operating System:** Windows 10 / Windows 11
* **Database Engine:** Microsoft SQL Server
* **SQL Instance:** `XMEGA\XXMEGA`
* **SQL Login:**
* Username: `rappelz`
* Password: `123456`
* Permissions: Full `sysadmin` privileges
## The Problem
Whenever I start **PrincessAuroraServer.exe**, it fails to initialize the database connection and returns one of the following errors:
```text
AUTH DB INIT ERROR : Login failed for user 'rappelz'
```
or
```text
Specified SQL Server not found
```
(depending on the server address format configured in the `.opt` file).
---
## Troubleshooting Already Performed
### SQL Server Configuration
✔ Enabled **Mixed Mode Authentication** (SQL Server and Windows Authentication).
✔ Enabled **TCP/IP** protocol through SQL Server Configuration Manager.
✔ Assigned a static port (**1433**) under the **IPAll** section.
✔ Confirmed that **SQL Server Browser Service** is running.
---
### Credential Verification
✔ Successfully connected to SQL Server using:
* SSMS (SQL Server Management Studio)
* Login: `rappelz`
* Password: `123456`
The account works perfectly outside of the game server.
---
### ODBC Configuration
✔ Created both **System DSN** and **User DSN** entries.
✔ Configured both:
* 32-bit ODBC Administrator
* 64-bit ODBC Administrator
✔ Created DSNs for:
* Auth Database
* Billing Database
✔ All connection tests returned:
```text
TESTS COMPLETED SUCCESSFULLY!
```
---
### Auth.opt Testing
I have tested multiple server connection formats, including:
```text
127.0.0.1\XXMEGA
127.0.0.1\\XXMEGA
127.0.0.1,1433
.\XXMEGA
localhost\XXMEGA
```
None resolved the issue.
---
### Password Format Testing
Since some older game server executables occasionally expect encrypted credentials, I also tested:
* Plain-text password
* MD5-hashed password
The behavior remained unchanged.
---
## Current Observation
Despite:
* Verified SQL connectivity
* Correct login credentials
* Working ODBC connections
* SQL Browser running
* TCP/IP enabled
* Proper user permissions
**PrincessAuroraServer.exe still refuses to authenticate with SQL Server.**
This leads me to suspect one of the following:
1. The executable may be reading configuration from a hidden or secondary location.
2. The server may require a specific SQL Native Client version.
3. The executable may only support default SQL instances.
4. There may be an undocumented password encryption method expected by the Auth Server.
5. The repack may contain hardcoded connection parameters.
---
## Questions
Has anyone experienced this issue with:
* HatrickRepack
* Epic 9.5.x Auth Server
* PrincessAuroraServer.exe
If so:
* What ultimately fixed it?
* Does the Auth Server require a specific SQL Native Client or ODBC version?
* Does it properly support named SQL instances?
* Are there additional configuration files that override Auth.opt?
Any insight, documentation, or troubleshooting suggestions would be greatly appreciated.
Thank you in advance for your time and assistance.
I am currently setting up a local **Rappelz Private Server (Epic 9.5.2)** using the **HatrickRepack** files. However, I am facing a persistent issue when launching the **Auth Server (PrincessAuroraServer.exe)** and would greatly appreciate any assistance from experienced developers.
## Environment Details
* **Operating System:** Windows 10 / Windows 11
* **Database Engine:** Microsoft SQL Server
* **SQL Instance:** `XMEGA\XXMEGA`
* **SQL Login:**
* Username: `rappelz`
* Password: `123456`
* Permissions: Full `sysadmin` privileges
## The Problem
Whenever I start **PrincessAuroraServer.exe**, it fails to initialize the database connection and returns one of the following errors:
```text
AUTH DB INIT ERROR : Login failed for user 'rappelz'
```
or
```text
Specified SQL Server not found
```
(depending on the server address format configured in the `.opt` file).
---
## Troubleshooting Already Performed
### SQL Server Configuration
✔ Enabled **Mixed Mode Authentication** (SQL Server and Windows Authentication).
✔ Enabled **TCP/IP** protocol through SQL Server Configuration Manager.
✔ Assigned a static port (**1433**) under the **IPAll** section.
✔ Confirmed that **SQL Server Browser Service** is running.
---
### Credential Verification
✔ Successfully connected to SQL Server using:
* SSMS (SQL Server Management Studio)
* Login: `rappelz`
* Password: `123456`
The account works perfectly outside of the game server.
---
### ODBC Configuration
✔ Created both **System DSN** and **User DSN** entries.
✔ Configured both:
* 32-bit ODBC Administrator
* 64-bit ODBC Administrator
✔ Created DSNs for:
* Auth Database
* Billing Database
✔ All connection tests returned:
```text
TESTS COMPLETED SUCCESSFULLY!
```
---
### Auth.opt Testing
I have tested multiple server connection formats, including:
```text
127.0.0.1\XXMEGA
127.0.0.1\\XXMEGA
127.0.0.1,1433
.\XXMEGA
localhost\XXMEGA
```
None resolved the issue.
---
### Password Format Testing
Since some older game server executables occasionally expect encrypted credentials, I also tested:
* Plain-text password
* MD5-hashed password
The behavior remained unchanged.
---
## Current Observation
Despite:
* Verified SQL connectivity
* Correct login credentials
* Working ODBC connections
* SQL Browser running
* TCP/IP enabled
* Proper user permissions
**PrincessAuroraServer.exe still refuses to authenticate with SQL Server.**
This leads me to suspect one of the following:
1. The executable may be reading configuration from a hidden or secondary location.
2. The server may require a specific SQL Native Client version.
3. The executable may only support default SQL instances.
4. There may be an undocumented password encryption method expected by the Auth Server.
5. The repack may contain hardcoded connection parameters.
---
## Questions
Has anyone experienced this issue with:
* HatrickRepack
* Epic 9.5.x Auth Server
* PrincessAuroraServer.exe
If so:
* What ultimately fixed it?
* Does the Auth Server require a specific SQL Native Client or ODBC version?
* Does it properly support named SQL instances?
* Are there additional configuration files that override Auth.opt?
Any insight, documentation, or troubleshooting suggestions would be greatly appreciated.
Thank you in advance for your time and assistance.
