Rappelz 7.4 Error DB SQLEXPRESS 2012

Good morning all,
I decided to spend my time on Appelz since the FR server no longer exists I'm bored ..
So I downloaded version 7.4 as well as a 7.4 client to create the server.

I have the files and SQLExpress, the databases are well configured.
I opened the TCP connection as indicated in the guide.
Available here:[Only registered and activated users can see links. Click Here To Register...]

Following that, I configured the Authserver and GameServer.opt files and recompress to file.opt.
However, it is impossible for me to start the server.

I have a connection error when I run PrincessAuroraServer.exe ...

"Auth DB INIT ERROR: failed to connect to user session" sa "."

So I tested with the password encrypt and not encrypt but nothing changes ...

Do you have a solution?

I am available on discord: LinkoLabs#5027

I am going to move this to the proper forum

Is user "sa" log in enabled in SQL?

Did you encrypt the .opt files and create a new .eop file?

Are the database ports set correctly?

No seeing any of your .opt information I can only offer small nudges but somewhere the log in for sa fails and it might not be the password.

I would ask if you tried with a black password but if we are not even sure if you are compressing and using your different .opt settings it would be hard to set the password to blank as well.

How do I know if the user is properly activated for the SQL connection? I created two other users to do the tests and it doesn't change anything.
I connect without problem with sql management from the user "sa"

I encrypt the .opt files well so that it changes to .eop format
This works because when I change the sql user there is indeed the nickname change in the error, however the connection is not working, maybe I should use a php script to see if the connection is working.

the connection ports, I have configured sql on port 1433

Here are the opt files, for the password I tested them with the encrypted password and the unencrypted password
[Only registered and activated users can see links. Click Here To Register...]
Auth :

Quote:

S db.auth.server:127.0.0.1 S db.auth.name:Auth S db.auth.account:sa S db.auth._password:PASSWORD_MD5_SA_AND_USER_SESSION S db.auth.port:1433 S app.name:auth N game.user_limit:3000 N auth.max_client_per_ip:30000 S log.ip:127.0.0.1 N _auth.version:200604290 N auth.version:200701120 N auth.max_daily_client_per_ip:50000 S db.auth.thread:350 S db.thread:350 S db.auth.md5_key:2011 N db.auth.use_md5:1 N db.auth.use_md5_for_security_no:0 S console._password:PASSWORD_MD5_SA_AND_USER_SESSION

GameServer:

Quote:

S app.name:Insult Removed S auth.server_idx:3 S auth.server_name:Insult Removed S db.game.ip:127.0.0.1 S db.c._password:PASSWORD_MD5_SA_AND_USER_SESSION S db.c.account:sa S db.c.name:Arcadia S db.c.server:127.0.0.1 S db.user._password:PASSWORD_MD5_SA_AND_USER_SESSION S db.user.account:sa S db.user.name:Telecaster S db.user.server:127.0.0.1 S game.iocp.active:1 S game.console.port:4502 S io.port:4418 S io.ip_address:127.0.0.1 S blank.io.port:4502 S io.auth.ip:127.0.0.1 S game.exp_rate:10 S game.server_screenshot_url:Removed S game.item_drop_rate:10 S game.gold_drop_rate:10 S game.chaos_drop_rate:10 S game.party_drop_rate:10 T game.use_login_logout_debug:0 T game.max_level:170 S working_dir:\upload S io.upload.ip:127.0.0.1 S io.upload.port:4616 T game.use_auto_trap:0 T game.cash_usable_server:1 T game.no_collision_check:1 T game.no_skill_cooltime:0 T game.disable_huntaholic:0 N game.logout_timer:0 S memory.player_heap_size:760 T game.mem_usage_info_save_interval:60 T game.PKServer:0 N game.item_hold_time:1800 S game.cash_item_dropable:0 T game.disable_dungeon_raid_siege:0 T game.limit_dungeon_enterable_level:0 T game.max_storage_item_count:400 T set_user_limit:1000 N game.skip_loading_attribute:1 S game.url_list:guild.url|[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
For the password I tested like this

PASSWORD_No_CRYPT = Error

PAssword_Crypt = error

Salt_Pssword_Crypted = error

The password is not MD5 it is generated with the password generator that come with the files that was created by Pyrok

Salt and MD5 is for User passwords and accounts not the .opts files

password crypted in Rappelz Zlib Password Generator.
with and without salt 2011.
with or without encryption it does not work

Try an empty password

I have just formatted my machine under Windows 7 I finished installing sql server and the server, I will keep you posted. It is true that I have not thought of testing without the password nor of creating a user without a password.

Windows 7 is outdated

I'm going to do the tests on windows server 2016, why did you send me a warning for insult?

Quote:

Originally Posted by BinaryFox why did you send me a warning for insult?

Because of content you posted in your .opt files that I had to remove.

ah ok sorry if i offended you i just made a copy paste of the file

I come back to you,
the connection without password works, I noticed that the sql connection is deactivated I am looking for the solutions however I have set the two connection modes.

The client does not seem to be connected to the database when I connect I have no response (no error log)

Quote:

Originally Posted by BinaryFox The client does not seem to be connected to the database when I connect I have no response (no error log)

This is probably a port issue.

Or not running the startup commands.

if you have run the start service and set game open commands then check your ports again

my firewall is disabled.

file.bat :

Quote:

RappelzCmdLauncher.exe SFrame.exe /auth_ip:192.168.0.112 /locale:windows-1252 /country:FR

hi test 127.0.0.1 , same result
how to activate this:
[Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by ThunderNikk This is probably a port issue. Or not running the startup commands. if you have run the start service and set game open commands then check your ports again

I didn't understand why, but there was a real need to open the ports of the firewall, even when it was deactivated, for the client to connect to the server, so I did indeed return to the server!

Now the connection works without a password,
How to put a password? I tested several passwords and restart the sql server several times but it remains the same problem, would you have an encrypt for the password of the .opt files maybe I'm doing things wrong

I also have the service "Agent sql server" which does not start