db server prob

[Timmy20231]

keeps on disconnecting and reconnecting every 3 seconds can anyone help please?

 

[Kaori]

db server connects to login server

what did login server say?

you probably forgot to add ip to one of the txt/ini... serveraddr or something in login server folder.

 

[Timmy20231]

Checked if i've missed IPs and its all fine heres my gates ...

 

[Kaori]

Paste the content of the 2 files:

LoginSrv's Logsrv.ini
DBServer's dbsrc.ini

 

[Timmy20231]

here you go..

 

[akacary2]

In the logsrv.ini i got my Monaddr set to 0.0.0.0 try that m8

 

[Kaori]

why is your mssql port 3306?

don't need to change those 0.0.0.0 to 127.0.0.1

 

[Mask]

is your db called lom2 or mir2?

 

[akacary2]

why is your mssql port 3306?

don't need to change those 0.0.0.0 to 127.0.0.1

Mine is also 3306 and works fine :S

 

[Timmy20231]

why is your mssql port 3306?

don't need to change those 0.0.0.0 to 127.0.0.1

That's what it was when i dl'd the whole server files and as you just said these IP's in them 2 files don't need changing to 127.0.0.1? If i've gone wrong here please tell me where to start thanks.

 

[Weikster]

That's what it was when i dl'd the whole server files and as you just said these IP's in them 2 files don't need changing to 127.0.0.1? If i've gone wrong here please tell me where to start thanks.

Kaori meant that any ip set as 0.0.0.0 should not be changed to 127.0.0.1
try changing your MonAddr in LogServ.ini back to 0.0.0.0
And from screenie, your login server isn't connected so something is wrong ip wise, also selgate is not connected,
In mine DBSPort=16303, not sure if that would make a difference though.

 

[Kaori]

at this point, your objective is to get login/db servers up. There's no point opening all other programs.

Turn on DBServer ONLY.
Do you get "Server Started..."?

 

[Timmy20231]

Nope i get "TFrmDBSrv.starttimer"

 

[Kaori]

it's not connecting to the SQL.
fix your sql server first.

which sql are you running? 2000 or 2005 or 2008?

 

[Timmy20231]

im runnin sql 2000

 

[Kaori]

im runnin sql 2000

with SP4?

Check if your server is listening on port 1433.
Verify user/pass is correct.

 

[jasper]

also instead of (local) try localhost or 127.0.0.1 in your dbsrv.ini

 

[Kaori]

like jasper say try 127.0.0.1 instead of (local)

to test if sql is listening on 1433
open cmd

netstat -na | find "1433"

You should see something like

TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING

 

[Timmy20231]

alright so as you can see what do i do from here?

 

[Kaori]

okay good

next is to test if your sa/sa actually works.

open cmd again
type these carefully

osql -S (local) -U sa -P sa
or
osql -S 127.0.0.1 -U sa -P sa

You should get "1>" (good)
You may get "Login failed for user 'sa'." or "SQL Server does not exist or access denied."