[2.3] DBserver help

[samjimin]

Hello just put my server on a dedi and everything works fine sept the dbserver keep disconnecting:


my dbsrc looks like this
[Reg]
Key=0123456789
ServerAddr=109.169.20.202
ServerPort=60320
[SQL]
SQLType=mssql
SQLHost=109.169.20.202
SQLPort=3306
SQLDatabase=mir2
SQLUsername=sa
SQLPassword=******
[Setup]
ServerName=MirLegacy
ServerAddr=109.169.20.202
ServerPor=6000
MapFile=C:\mirserver\Mir200\Envir\MapInfo.txt
ViewHackMsg=1
GateAddr=109.169.20.202
GatePort=5100
DynamicIPMode=0
BackupClearData=0
ShowItemName=1
DBName=HeroDB
[Server]
IDSAddr=109.169.20.202
IDSPort=5600
[DBClear]
Interval=1000
Level1=1
Level2=7
Level3=14
Day1=7
Day2=62
Day3=124
Month1=0
Month2=0
Month3=0
[DB]
Dir=C:\mirserver\DBServer\FDB\
IdDir=C:\mirserver\DBServer\FDB\
HumDir=C:\mirserver\DBServer\FDB\
FeeDir=C:\mirserver\DBServer\FDB\
BackupDir=C:\mirserver\DBServer\Backup\
ConnectDir=C:\mirserver\DBServer\Connection\
LogDir=C:\mirserver\DBServer\Log\
[Backup]
AutoBackup=1
BackupTime=18000000


Thanks in advance for help

 

[Toddwhite]

dont you need to change the SQL host from the i.p to your sql version of "Lux666-PC\SQLEXPRESS"??

also for online, the i.p's shud be your 192.168.0.?? (internal?) in this file? or isit because its a dedi this is different?

 

[samjimin]

tryed that didnt work:/

 

[Toddwhite]

have you ever tried your server online? or only ever tested it offline? Because by the looks of your setup it is for offline use.

Just looked at your screenshot of M2, the DB server gate is runnin on a diff i.p to the Gate0.

 

[andykid131]

You have only posted the info for DBsrc.txt

But arnt there 2 other .txt files that hold IP info for DBserver?
( !Serverinfo.txt )
( !Addrtable.txt )

Have you changed IP in these .txt files aswell?

I havnt messed with 2.3 files in years tho so im not 100% sure if those files even have them .txts lol.
Im gonna fish out my old 2.3 files and have a look over them, i remember having this same problem.

/Toxin

 

[samjimin]

yeah changed both of them checked over ip's again all seem fine not sure y it ses its running on diffrent ip

ok cheers toxin

 

[Toddwhite]

if u need any help add me on msn [email protected]. I got my server online, so will be able to help with yours x

 

[samjimin]

added ya

 

[Zen2]

You should try 127.0.0.1 as every IP other than the few global ips Hope this helps.

 

[samjimin]

tryed that didnt work:/ do you rekon it could be cause im using windows 2008?

 

[Zen2]

You will need to patch SQL 2000 to work with that if i remember correctly. Microsoft should have these patches on thier site, do a search on google SQL 2000 Patch

 

[samjimin]

ok cheers m8 will have a look

 

[boothy]

if you're using SQL 2000 try changing

SQLHost=109.169.20.202

to

SQLHost=(local)

or localhost

 

[andykid131]

if you're using SQL 2000 try changing

SQLHost=109.169.20.202

to

SQLHost=(local)

or localhost

I was thinking it had sumit to do with his SQL Info, i cant remember putting an IP in ( SQLHost= )
Was going to have a look for him but he dosnt seem to be online atm.

/Toxin

 

[samjimin]

hmm iv updated it tried (local) and localhost weird thing is my mir2 server still connects to sql but the dbserver still cant:/

 

[Toddwhite]

seems bit silly asking this but have you changed the SQL database sections to the db name you use in SQL?

 

[samjimin]

yeah they the same