cast server error...

[ozboy07]

hey guys as it says in the title im having troubles starting my server up...
because of the cast server not doing what it should...

ive done restoring bak files ect... config files... came to starting everything up but i got an error message from the cast server then followed by the session server and dekaron server to stop working... im just completely stuck at the moment, ill include a screen shot to show the error message :S

If anyone knows how to fix this i will appreciate the help

Also if someone could kindly post a link to the P-server connector launcher as i didnt get one in my server files

[BioNicX]

Password input is wrong in the castserver config file.

[ozboy07]

hmm is it the account called "sa" you mean the pass within the login props in sql?

[joshyb123]

the account for the database.... doesn't have to be ''sa'' you can make a new one with anything.
but you make it in sql server management then put into files for it to access. (if you do that be sure to change odbc settings as well)

But yes, the login details for sql is what you need to put in it.

[ozboy07]

ahh so the config file user and pass has nothing to do with the connect object on sql login part ~ btw im using express 2005

got rid of express getting enterprise installed atm

[joshyb123]

yes... it does have to do with it lol.
the config for cast should look like this

;
CAST_PORT		= 7882
DATABASE_ADDRESS	= [COLOR="Red"]Your I.P Address[/COLOR],1433
DATABASE_DATABASE	= CHARACTER
DATABASE_ACCOUNT	= [COLOR="Red"]Sql Username[/COLOR]
DATABASE_PASSWORD	= [COLOR="Red"]Sql Password[/COLOR]
CAST_SERVER_ID		= 1101
LOG_PATH		= ..\LogFiles\

You need to change the IP, and database account/password info.

[ozboy07]

enterprise dosnt seem to be working so im reverting to express lol
i sent u a p-message :P

[joshyb123]

just use sql server 2000, or 2008. they work fine.

there are a few tuts out there on how to install, and setup the databases.
after that, all you need to do, is set a new login account on the sql server. and put that login info into the configs.

[ozboy07]

i did everything correctly.. set the permissions ect... the error comes up but just under the error i get the message SP_GUILD_SERVER_ID_SET SUCCESS which is what i wanted to show up without the error msg...

getting the success msg after an error msg is that a bad thing or...?

[joshyb123]

if u done it all correctly you wouldn't get an error lol
go through a tut again, and make sure you didn't miss any steps by mistake.

[ozboy07]

true, the tuts ive come across say different things :S

EDIT: is it okay to use ms sql server 2008?

[BioNicX]

Yes theres a Tut, search for it.

[Valtsu]

Check the tutorial on this site, there is a picture posted by Mozo on the lasr page.

Mine sessionserver crashe bcause I hadnt enabled that... Its not mentined in the guide tho... idk why

[ozboy07]

Couldnt have followed the tut any better than i did...
but the error still comes up the same as in the screen shot i first posted


;
CAST_PORT = 7882
DATABASE_ADDRESS = 5.115.72.220,1433
DATABASE_DATABASE = CHARACTER
DATABASE_ACCOUNT = aeolosdk
DATABASE_PASSWORD = elsa17
CAST_SERVER_ID = 1101
LOG_PATH = ..\LogFiles\

db_account
db_password

is perfect double checked in the management studio

cant seem to work out whats wrong...

got the usual session error too even after i enabled the TCP/IP in config manager >.<
Going through the tut again to see if i get the error again...

[guesswho-.-]

if you don't eve know how to set up SQL properly then don't touch the pservers stuff. use mixed auth mode and your problem will be gone. and yes, it has been answered already.