[READ THIS]SessionServer

05/17/2009 15:24 ex6tenCe#1

heya
Since a virus fucked down my System yesterday and i had to make it new, my Sessionserver doesnt work anymore.

before my system got owned i had the same problem, but it disappeared from one day to the next - i dont know why. i think i was simply lucky. my server was running then for like 2 month. but since i made my system new, the sessionserver crashes again. i cleared the log and let it fail again and saw that error:

Quote:

>> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL

can anyone tell me why?
wut is "SP_LOGIN_FLAG_SET PROC"? i searched for it but i didnt found it lol

05/17/2009 16:56 gedimazs#2

Go to Query Analizer and run SN if you did not do that yet

Code:

EXEC sp_addlinkedserver 'LSV_GHBILL','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRACNT','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRCASH','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRHELION','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRQUNE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSIZ','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRTEST','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRZUTO','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSTA','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRACCOUNT01','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'

And then this:

Code:

exec sp_serveroption 'LSV_GHBILL','rpc out','true' 
exec sp_serveroption 'LSV_GHBILL','rpc','true' 
exec sp_serveroption 'LSV_DKRACNT','rpc out','true' 
exec sp_serveroption 'LSV_DKRACNT','rpc','true' 
exec sp_serveroption 'DKRCASH','rpc out','true' 
exec sp_serveroption 'DKRCASH','rpc','true' 
exec sp_serveroption 'LSV_DKRHELION','rpc out','true' 
exec sp_serveroption 'LSV_DKRHELION','rpc','true' 
exec sp_serveroption 'LSV_DKRNUNVICE','rpc out','true' 
exec sp_serveroption 'LSV_DKRNUNVICE','rpc','true' 
exec sp_serveroption 'LSV_DKRQUNE','rpc out','true' 
exec sp_serveroption 'LSV_DKRQUNE','rpc','true' 
exec sp_serveroption 'LSV_DKRRONDOW','rpc out','true' 
exec sp_serveroption 'LSV_DKRRONDOW','rpc','true' 
exec sp_serveroption 'LSV_DKRSIZ','rpc out','true' 
exec sp_serveroption 'LSV_DKRSIZ','rpc','true' 
exec sp_serveroption 'LSV_DKRTEST','rpc out','true' 
exec sp_serveroption 'LSV_DKRTEST','rpc','true' 
exec sp_serveroption 'LSV_DKRZUTO','rpc out','true' 
exec sp_serveroption 'LSV_DKRZUTO','rpc','true' 
exec sp_serveroption 'LSV_DKRSTA','rpc out','true' 
exec sp_serveroption 'LSV_DKRSTA','rpc','true' 
exec sp_serveroption 'DKRACCOUNT01','rpc out','true' 
exec sp_serveroption 'DKRACCOUNT01','rpc','true'

05/17/2009 17:23 ex6tenCe#3

already did that. i dont want to be noobl1k3 now, but i made it two times: one time i saved the untitle1.sql somewhere and one time i didnt. is that important? does i have to do something with this file?

05/17/2009 17:46 babynator#4

did u add in "config" u DATABASE_ACCOUNT and DATABASE_PASSWORD,

DATABASE_ADDRESS = 5.220.229.96,1433
DATABASE_DATABASE = CHARACTER
DATABASE_ACCOUNT = sa
DATABASE_PASSWORD = 123456
SESSION_SERVER_ID = 1100

LOG_PATH = ..\LogFiles\
BILLING = 0
NO_CHARGE_CODE = NODATA

05/17/2009 17:59 ex6tenCe#5

no :D

is '123456' right?

edit: doesnt work lol

edit2: ok after the 2nd try it works

05/17/2009 22:48 socressor#6

Quote:

Originally Posted by ex6tenCe

no :D

is '123456' right?

edit: doesnt work lol

edit2: ok after the 2nd try it works

yay and u called me a noob...

05/18/2009 04:50 redrobin99#7

Well, I'm having this same problem... I did run the query, and included all the passwords... I've also had a server previously with the latest server files. All the servers start fine except for Session. It crashes immediately after being started and I can't figure out why.

System has more then enough ram/cpu, so it's not that.. Also, running WinXP SP3 (same as I had it working on fine before)

Using MSSQL 2000 Developer Edition, since it's the only one I could get to work.

So any suggestions would be great, been at this for over 6 hours straight >_<

05/18/2009 05:09 Hell1977#8

I would love an answer also :P

05/18/2009 06:59 chobito#9

i think its sql problem i ahd the same prob long ago, i just reinstall all OS and dissaparear

05/18/2009 13:30 ex6tenCe#10

finally only the great ex6tenCe can help you.

while installing SQL 2000 or SP4, i forgott what, there is a field where you have to type in a password. remeber it lol
then look at the config.ini of session again.

database = Character
and then DB_user is nearly always = sa
DB_PASSWORD = <your password>

always ask the divine and great ex6tenCe if oyu need any help

05/18/2009 14:34 roflmaopmp#11

Man, I love your sig. 10 bucks said the second last 2 aren't true. >: )

05/18/2009 15:35 ex6tenCe#12

05/18/2009 15:38 redrobin99#13

I fixed the problem ^_^

Apparently SP4 didn't install properly or something, did a clean reinstall of MSSQL and updated to SP4, and no problems at all. Working great again.

(amazing how something that small can drive a person nuts for 6 hours >_<)