Private Server [HELP]

[ursan99]

idk but maybe u need to add the ports in ur firewall...

[Bear Walken]

You must run these scripts on SQL Query Analyzer

Run this first

USE master
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=;'

then this...

USE master
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'

Maybe this is your problem. Another thing try to install netframework... sry my poor english.

[EliteWarrior]

CAST_PORT = 7882
DATABASE_ADDRESS = 5.58.189.91
DATABASE_DATABASE = CHARACTER
DATABASE_ACCOUNT = sa
DATABASE_PASSWORD = 1234
CAST_SERVER_ID = 1101
LOG_PATH = ..\LogFiles\

I got a question the ''sa'' account do i have to create it with sql manager or is it a default one? Becuase authenication mode during setup i used windows authenication.

If so the password can just be random?

Because i dont think sa can just be put in the config.ini while it dont exists with pw in database .


So what do i need to do to make it work? This is the only problem atm where im stuck.

Trust me ive searched alot of topics.

Error message i get:



this is how my config looks like :

[~Kakkarot~]

Originally Posted by EliteWarrior

I got a question the ''sa'' account do i have to create it with sql manager or is it a default one? Becuase authenication mode during setup i used windows authenication.

If so the password can just be random?

Because i dont think sa can just be put in the config.ini while it dont exists with pw in database .


So what do i need to do to make it work? This is the only problem atm where im stuck.

Trust me ive searched alot of topics.

Error message i get:



this is how my config looks like :

no the password cant be "just random" you ahve to put in the password that u used while installing SQL, if you put windows atuhentication then i think you will have to install it again

[EliteWarrior]

nvm got it work for some reason i used SA and a password that used while install sp4. If i edit anything withing the server files while server is up do i have to close client or close client and server so the edited files like exp ratio/dil is active?

[caper]

Any updates to server files or server share requires a restart. You must also update client if you update server share folder.

[abelwang]

i NEED A WEB SERVER FILE. any1 have it? i couldnt find it.

[Pyrofol]

It is not needed anymore

[EliteWarrior]

Originally Posted by caper

Any updates to server files or server share requires a restart. You must also update client if you update server share folder.

Ok thanks so i have to shutdown server if i edit replace files in share.

Ive managed to get 100% succesr rate for argating and socketing and dil for it to pay 100dil :P

Right now ive got a major problem,when i do the command /gm callmonsters 330

or w/e the client crashes immediately. Ever since i downloaded some ones edited monster.csv and itemset.csv because you could then spawn GM Rings.

AND yes i have replaced in both server side and client side folders. Any one knows what the problem is?

I also have replaced them with the old ones,still no succes.

[twiggy345]

Originally Posted by EliteWarrior

Ok thanks so i have to shutdown server if i edit replace files in share.

Ive managed to get 100% succesr rate for argating and socketing and dil for it to pay 100dil :P

Right now ive got a major problem,when i do the command /gm callmonsters 330

or w/e the client crashes immediately. Ever since i downloaded some ones edited monster.csv and itemset.csv because you could then spawn GM Rings.

AND yes i have replaced in both server side and client side folders. Any one knows what the problem is?

I also have replaced them with the old ones,still no succes.

Is it any monster or just that one?
if its just that one then you are missing files. the textures etc. but if its with other monsters as well then you have a bad monster.csv file

Just download A6 from silkbotter and start over on the editing files. that should fix it

[EliteWarrior]

It is with all Monster ID's ever since i downloaded that edited monster.csv and itemset.csv . I have tried replacing with the A6 from silkbotter nothing worked.

What im doing now is extract again the A6 client and replace ALL files. Same for server . I let you know what i got.

[janvier123]

does anything show up in you dbmon ?

[EliteWarrior]

ehm no not really ,what i have done is reinstalled client and server. Now its working again.

But **** that edited monster.csv and itemset.csv are bugged for some reason the one that has posted them.


Do you know what values to edit ? For the gm rings? Without having again client crash.

[janvier123]

try to check the logs folder in your server folder
see if anything pops up in there

[CROvic]

download this