DB Errors

[liamknight24]

Hey everyone im new here and i have tried using the search and there is nothing about it here, Don't be ignorant and tell me to use the search because i have!

Anyway the error is when i start princessauroraserver.exe and i get this error:

AUTH DB INIT ERROR: [DBNETLIB][ConnectionOpen(connect()).]SQL Server does not exist or access denied, Here is my authserver.opt and gameserver.opt, The details in there are correct and the SQL is set up correctly.

AuthServer.opt :

S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth.password:
S app.name:Testserver
S log.ip:127.0.0.1
S db.auth.port:1433
N db.auth.use_webauth:0
N db.auth.use_md5:1
N db.auth.debug_md5:0
N db.auth.md5_key:2011

gameserver.opt :

S app.name:game001
S auth.server_idx:1
S auth.server_name:FWCentral-Rappelz
S db.game.ip:127.0.0.1
S db.c.password:
S db.c.account:sa
S db.c.name:Arcadia
S db.c.server:127.0.0.1
S db.user._password:
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:4514
S io.ip_address:127.0.0.1
S blank.io.port:4502
S game.server_screenshot_url:
S game.guild_icon_base_url:
S log.disable:1
S log.working:0
S game.exp_rate:10
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
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 io.upload.ip:127.0..1
S io.upload.port:4616

Thanks in advance for any help on this issue.

[Xijezu]

Those settings looks right for me (I just looked at the DB-Part, also I didn't even read the topic. ^^).

It seems that you have some issues with your SQL Server, means it isn't set up correctly.

Take a look in JW988's Guide, there you can find the right setup for it.

[liamknight24]

Hey thanks for the reply mate, I am using SQL 2012 i followed JW988's guide and did everything like he said, I can connect to it using SQL manager using user sa and removed the password, im using windows 7 64bit if that helps :P

[Xijezu]

Originally Posted by liamknight24

Hey thanks for the reply mate, I am using SQL 2012 i followed JW988's guide and did everything like he said, I can connect to it using SQL manager using user sa and removed the password, im using windows 7 64bit if that helps :P

I personally would say use SQL 2008 R2 instead of 2012. :/ 2012 is still in Beta if I remember right.

Well, nvm.

When you are able to login with (local)/localhost/127.0.0.1/etc. instead of telling him the specified instance, then the connection with the Gameserver should work, too.

[liamknight24]

Hmm ill remove 2012 and put 2008 and get back to you thanks

[c1ph3r]

Check if you enabled the TCP/IP protocol for the instance in the Configuration Manager. It's disabled by default.

[liamknight24]

yeah i did that mate

[→Striker←]

The issue is from the MSSQL Server that you got; I'm sure it got corrupted while installation just either contact Microsoft support or re-install the MSSQL

[wisp66]

did u restart the pc after u set up sql config

[liamknight24]

yeah i restarted the pc before, and i removed SQL 2012 and installed 2008 R2 and now i have another problem, Im on windows XP and when i try to add the database i get an error saying i haven't got enough space but i have 28gb free on the computer so im not sure what is wrong

[oxymnya]

as far as I know you'll need at least 35-40gb of free hdd space. Also watch out for dump files, those can take out space also. I belive extension for those files is .dmp

[ProdStar]

Originally Posted by liamknight24

Hey everyone im new here and i have tried using the search and there is nothing about it here, Don't be ignorant and tell me to use the search because i have!

Anyway the error is when i start princessauroraserver.exe and i get this error:

AUTH DB INIT ERROR: [DBNETLIB][ConnectionOpen(connect()).]SQL Server does not exist or access denied, Here is my authserver.opt and gameserver.opt, The details in there are correct and the SQL is set up correctly.

AuthServer.opt :

S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth.password:
S app.name:Testserver
S log.ip:127.0.0.1
S db.auth.port:1433
N db.auth.use_webauth:0
N db.auth.use_md5:1
N db.auth.debug_md5:0
N db.auth.md5_key:2011

gameserver.opt :

S app.name:game001
S auth.server_idx:1
S auth.server_name:FWCentral-Rappelz
S db.game.ip:127.0.0.1
S db.c.password:
S db.c.account:sa
S db.c.name:Arcadia
S db.c.server:127.0.0.1
S db.user._password:
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:4514
S io.ip_address:127.0.0.1
S blank.io.port:4502
S game.server_screenshot_url:
S game.guild_icon_base_url:
S log.disable:1
S log.working:0
S game.exp_rate:10
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
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 io.upload.ip:127.0..1
S io.upload.port:4616

Thanks in advance for any help on this issue.

pm Skype ProdDevStar .. i can install server to you =)

[AngelOwns]

enable all in ur SQL Configs

[liamknight24]

Ok all the SQL is working fine now thanks but whenever i start the game server it just crashes, Im using Windows XP if that helps and added you ProdStar

[c1ph3r]

If you want help, post your Crash-Log.