DB Errors

04/03/2012 22:01 liamknight24#1
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 :

Code:
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 :

Code:
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.
04/03/2012 22:08 Xijezu#2
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. ;)
04/03/2012 22:12 liamknight24#3
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
04/03/2012 22:20 Xijezu#4
Quote:
Originally Posted by liamknight24 View Post
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.
04/03/2012 22:29 liamknight24#5
Hmm ill remove 2012 and put 2008 and get back to you thanks
04/03/2012 22:31 c1ph3r#6
Check if you enabled the TCP/IP protocol for the instance in the Configuration Manager. It's disabled by default.
04/03/2012 22:39 liamknight24#7
yeah i did that mate
04/03/2012 23:37 →Striker←#8
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
04/04/2012 00:31 wisp66#9
did u restart the pc after u set up sql config
04/04/2012 02:41 liamknight24#10
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
04/04/2012 02:57 oxymnya#11
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
04/04/2012 06:54 ProdStar#12
Quote:
Originally Posted by liamknight24 View Post
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 :

Code:
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 :

Code:
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 =)
04/04/2012 10:48 AngelOwns#13
enable all in ur SQL Configs

[Only registered and activated users can see links. Click Here To Register...]
04/04/2012 14:14 liamknight24#14
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
04/04/2012 14:17 c1ph3r#15
If you want help, post your Crash-Log.