question about sql setup !

Discussion about Helbreath Server Files.
dumper
Regular
Posts: 88
Joined: Sat Nov 18, 2006 8:25 pm

Post by dumper »

i wanted to play a bit with sql files and followed the tutorials here on the site and got most things working but only thing that doesnt work is when i created a char and wanna log in then it just keeps counting .. i used the same port setting that i used for the non sql server and which worked always ... is there something that must be different in port settings or im missing something else ?
Sprint
Spamtastic
Posts: 1000
Joined: Tue Jun 06, 2006 6:59 am
Location: Far from home
Contact:

Post by Sprint »

ru having the sqlserver up? xD
<span style='color:blue'><span style='font-size:19pt;line-height:100%'><u><b>FUCK Helbreath!</b></u></span></span><br><br><span style='color:gray'><a href='http://www2.analystica.com/users/anttu/online/ngd' target='_blank'>ngdnetwork</a> OFFICIAL WEBSITE OF Northern Game Developers. Do visit! (THEY ARE UP!)<br><a href='http://project3d.x.am' target='_blank'>Project3d development forum</a> plz join and discuss,develop,give ideas,feedback. Anything goes as long it helps the project!</span><br><br>Zepto Znote 6625WD: 1.8Ghz dual core, 2GB, 512mb graphics card(dedicated), 160GB HDD<br><img src='http://www.signaturebar.com/uploads/images/10111.jpg' border='0' alt='user posted image' /><br><img src='http://www.signaturebar.com/uploads/images/13229.jpg' border='0' alt='user posted image' /><br><img src='http://www.signaturebar.com/uploads/images/8852.png' border='0' alt='user posted image' />
dumper
Regular
Posts: 88
Joined: Sat Nov 18, 2006 8:25 pm

Post by dumper »

yea the ml and wl server run in db mode and i manually created an account in the sql dadabase then connected and created a char in client .. that char is in db too .. but when i try to login on hg it doesnt conect ... just waiting for response ...
i tried with diferent hgs now but always the same ...
Sprint
Spamtastic
Posts: 1000
Joined: Tue Jun 06, 2006 6:59 am
Location: Far from home
Contact:

Post by Sprint »

ahve u configured the db to allow information be read, not only write?
<span style='color:blue'><span style='font-size:19pt;line-height:100%'><u><b>FUCK Helbreath!</b></u></span></span><br><br><span style='color:gray'><a href='http://www2.analystica.com/users/anttu/online/ngd' target='_blank'>ngdnetwork</a> OFFICIAL WEBSITE OF Northern Game Developers. Do visit! (THEY ARE UP!)<br><a href='http://project3d.x.am' target='_blank'>Project3d development forum</a> plz join and discuss,develop,give ideas,feedback. Anything goes as long it helps the project!</span><br><br>Zepto Znote 6625WD: 1.8Ghz dual core, 2GB, 512mb graphics card(dedicated), 160GB HDD<br><img src='http://www.signaturebar.com/uploads/images/10111.jpg' border='0' alt='user posted image' /><br><img src='http://www.signaturebar.com/uploads/images/13229.jpg' border='0' alt='user posted image' /><br><img src='http://www.signaturebar.com/uploads/images/8852.png' border='0' alt='user posted image' />
dumper
Regular
Posts: 88
Joined: Sat Nov 18, 2006 8:25 pm

Post by dumper »

um i dont think so .. where i change that ?

btw here is a pic of my ml -> <a href='http://img504.imageshack.us/img504/6886/mlhp1.jpg' target='_blank'>http://img504.imageshack.us/img504/6886/mlhp1.jpg</a>

Sprint
Spamtastic
Posts: 1000
Joined: Tue Jun 06, 2006 6:59 am
Location: Far from home
Contact:

Post by Sprint »

I dun know your version of sqlserver nor how the hb client/server gets info from db, but at least you have to have this configured(img)
<span style='color:blue'><span style='font-size:19pt;line-height:100%'><u><b>FUCK Helbreath!</b></u></span></span><br><br><span style='color:gray'><a href='http://www2.analystica.com/users/anttu/online/ngd' target='_blank'>ngdnetwork</a> OFFICIAL WEBSITE OF Northern Game Developers. Do visit! (THEY ARE UP!)<br><a href='http://project3d.x.am' target='_blank'>Project3d development forum</a> plz join and discuss,develop,give ideas,feedback. Anything goes as long it helps the project!</span><br><br>Zepto Znote 6625WD: 1.8Ghz dual core, 2GB, 512mb graphics card(dedicated), 160GB HDD<br><img src='http://www.signaturebar.com/uploads/images/10111.jpg' border='0' alt='user posted image' /><br><img src='http://www.signaturebar.com/uploads/images/13229.jpg' border='0' alt='user posted image' /><br><img src='http://www.signaturebar.com/uploads/images/8852.png' border='0' alt='user posted image' />
dumper
Regular
Posts: 88
Joined: Sat Nov 18, 2006 8:25 pm

Post by dumper »

i have for mainlog and ws1 public and db_owner selected !
maybe is a problem with account valid time .. when u look at the pic from my ml it says "remaind account time (0) "
but i set the validdate and valitime already .. date to 2020 and time to 20000 ...
Sprint
Spamtastic
Posts: 1000
Joined: Tue Jun 06, 2006 6:59 am
Location: Far from home
Contact:

Post by Sprint »

yes, but is your account on the computer admin over the db? And what rights do u have for the 'dbo'?

btw i suggest u try updating your sqlserver too
<span style='color:blue'><span style='font-size:19pt;line-height:100%'><u><b>FUCK Helbreath!</b></u></span></span><br><br><span style='color:gray'><a href='http://www2.analystica.com/users/anttu/online/ngd' target='_blank'>ngdnetwork</a> OFFICIAL WEBSITE OF Northern Game Developers. Do visit! (THEY ARE UP!)<br><a href='http://project3d.x.am' target='_blank'>Project3d development forum</a> plz join and discuss,develop,give ideas,feedback. Anything goes as long it helps the project!</span><br><br>Zepto Znote 6625WD: 1.8Ghz dual core, 2GB, 512mb graphics card(dedicated), 160GB HDD<br><img src='http://www.signaturebar.com/uploads/images/10111.jpg' border='0' alt='user posted image' /><br><img src='http://www.signaturebar.com/uploads/images/13229.jpg' border='0' alt='user posted image' /><br><img src='http://www.signaturebar.com/uploads/images/8852.png' border='0' alt='user posted image' />
dumper
Regular
Posts: 88
Joined: Sat Nov 18, 2006 8:25 pm

Post by dumper »

what sql server should i use ... i downloaded the version they posted in the tutorial and used a crack ...
and here is a screen of the console ... if that helps ->
<a href='http://img150.imageshack.us/img150/3649/sqlsh3.jpg' target='_blank'>http://img150.imageshack.us/img150/3649/sqlsh3.jpg</a>
Sprint
Spamtastic
Posts: 1000
Joined: Tue Jun 06, 2006 6:59 am
Location: Far from home
Contact:

Post by Sprint »

:o, thats sum real old sqlserver, maby 2000. I suggest u keep the setupfile for it, and download the sqlserverexpress from msdn.com . Assuming you have a genuine windows xD. Cos iv only worked with sqlserverexpress 2005 and MSVS 2005. So if u dont upgrade cant help anymore ;)
<span style='color:blue'><span style='font-size:19pt;line-height:100%'><u><b>FUCK Helbreath!</b></u></span></span><br><br><span style='color:gray'><a href='http://www2.analystica.com/users/anttu/online/ngd' target='_blank'>ngdnetwork</a> OFFICIAL WEBSITE OF Northern Game Developers. Do visit! (THEY ARE UP!)<br><a href='http://project3d.x.am' target='_blank'>Project3d development forum</a> plz join and discuss,develop,give ideas,feedback. Anything goes as long it helps the project!</span><br><br>Zepto Znote 6625WD: 1.8Ghz dual core, 2GB, 512mb graphics card(dedicated), 160GB HDD<br><img src='http://www.signaturebar.com/uploads/images/10111.jpg' border='0' alt='user posted image' /><br><img src='http://www.signaturebar.com/uploads/images/13229.jpg' border='0' alt='user posted image' /><br><img src='http://www.signaturebar.com/uploads/images/8852.png' border='0' alt='user posted image' />
dumper
Regular
Posts: 88
Joined: Sat Nov 18, 2006 8:25 pm

Post by dumper »

well im trying with the express version now but its givin me some problems setting up that odbc thingy when i enter the user and pass ... some connection error pops up ....
but with the server management tool i can login with that user and pass ....
bah now i get some error 233 with management login too .. still there even i already enabled the named pipes and tcp/ip ....
Sprint
Spamtastic
Posts: 1000
Joined: Tue Jun 06, 2006 6:59 am
Location: Far from home
Contact:

Post by Sprint »

what error, can u post img or explain it better, cos do u have a administrator account on your pc? If you dont, you will have fucking much problems (if you know the administrator password but dun wanan change account, rightclick ->run as)
<span style='color:blue'><span style='font-size:19pt;line-height:100%'><u><b>FUCK Helbreath!</b></u></span></span><br><br><span style='color:gray'><a href='http://www2.analystica.com/users/anttu/online/ngd' target='_blank'>ngdnetwork</a> OFFICIAL WEBSITE OF Northern Game Developers. Do visit! (THEY ARE UP!)<br><a href='http://project3d.x.am' target='_blank'>Project3d development forum</a> plz join and discuss,develop,give ideas,feedback. Anything goes as long it helps the project!</span><br><br>Zepto Znote 6625WD: 1.8Ghz dual core, 2GB, 512mb graphics card(dedicated), 160GB HDD<br><img src='http://www.signaturebar.com/uploads/images/10111.jpg' border='0' alt='user posted image' /><br><img src='http://www.signaturebar.com/uploads/images/13229.jpg' border='0' alt='user posted image' /><br><img src='http://www.signaturebar.com/uploads/images/8852.png' border='0' alt='user posted image' />
dumper
Regular
Posts: 88
Joined: Sat Nov 18, 2006 8:25 pm

Post by dumper »

looks like some problem with the odbc driver .. i tried that odbcping but thats only for upper versions i think so i dunno how to fix yet ...
image ->
<a href='http://img252.imageshack.us/img252/9114/errorbw2.jpg' target='_blank'>http://img252.imageshack.us/img252/9114/errorbw2.jpg</a>
Sprint
Spamtastic
Posts: 1000
Joined: Tue Jun 06, 2006 6:59 am
Location: Far from home
Contact:

Post by Sprint »

lol, if i got it right(dont speak german or whaterver that is), its just the sqladapter in the hbserver wich wont connect. Are u able to connect to your own computer?(when u start sqlserver up)
<span style='color:blue'><span style='font-size:19pt;line-height:100%'><u><b>FUCK Helbreath!</b></u></span></span><br><br><span style='color:gray'><a href='http://www2.analystica.com/users/anttu/online/ngd' target='_blank'>ngdnetwork</a> OFFICIAL WEBSITE OF Northern Game Developers. Do visit! (THEY ARE UP!)<br><a href='http://project3d.x.am' target='_blank'>Project3d development forum</a> plz join and discuss,develop,give ideas,feedback. Anything goes as long it helps the project!</span><br><br>Zepto Znote 6625WD: 1.8Ghz dual core, 2GB, 512mb graphics card(dedicated), 160GB HDD<br><img src='http://www.signaturebar.com/uploads/images/10111.jpg' border='0' alt='user posted image' /><br><img src='http://www.signaturebar.com/uploads/images/13229.jpg' border='0' alt='user posted image' /><br><img src='http://www.signaturebar.com/uploads/images/8852.png' border='0' alt='user posted image' />
dumper
Regular
Posts: 88
Joined: Sat Nov 18, 2006 8:25 pm

Post by dumper »

what u mean connect to my comp lol ...
the sql server is running and i can connect to it with the management studio
Post Reply