[HELP!] Installing shaiya server on windows 2008 server

09/10/2011 17:19 Psycnosis#1

I installed my server on my windows 7 and it worked flawesly for awhile but need a server cos I cant use hamachi for my testing anymore. So I rented a dedicated server with windows 2008. I cant install the server there cos it wont work. It wont connect to the SQL server.

Only errors I get in the installation process is this.
[Only registered and activated users can see links. Click Here To Register...]

in the logs after I try and start the server I get this:

Code:

2011-09-10 15:56:41 PS_DBAGENT__system log start (DBAgent01)

2011-09-10 15:56:41 DB gamedata connect error

2011-09-10 15:56:41 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2011-09-10 15:56:41 DBKillCountSave db alloc failed

2011-09-10 15:56:41 SAVE kill count ERROR

2011-09-10 15:56:41 CKeepObeliskMgr::DBSave db alloc failed

2011-09-10 15:56:41 SAVE g_KeepObeliskMgr ERROR

2011-09-10 15:56:41 GuildMgrSave::DBSave db alloc failed

2011-09-10 15:56:41 SAVE g_GuildMgrSave ERROR

2011-09-10 15:56:41 PS_DBAGENT__system log end (DBAgent01)


2011-09-10 15:56:41 3 1 SService::ServiceCtrlDispatcher(): service shutdown

I would highly appreciate if anyone could help! Also I need more devs on my team if anyone is interested pm me for more details. I need help on server side. I got everything else taken care of (mostly)

09/10/2011 19:38 viper4513#2

Are you using SQL 2005 Express for this?

Sounds strange, but i had the same error using that, i uninstalled and deleted all the Services, then installed SQL 2008 and it worked fine.. maybe give that a go and see if it helps you atall?

09/10/2011 19:42 Psycnosis#3

hmm I never used 2008 but thanks ill give it a try, ill let you know how it goes

09/10/2011 20:04 JuuF#4

do you have 'Shaiya' account in sql? check it, if you dont have.. make an account

09/10/2011 21:00 viper4513#5

I hadnt used it either until i installed it after having this problem, but it all works all fine and it's pretty much the same as 2005 anyways. Looks all the same, and is easier to save data aswell (for CSV's)

09/10/2011 21:18 Psycnosis#6

How do I make a "shaiya" account in sql? it always done it automaticly for me

09/10/2011 21:28 JuuF#7

Connect with windows authentication > security > logins (right click on logins) > new login
then make your account with Login Name='Shaiya', password='Shaiya123' and choose SQL server authentication.Dont forget to change "server roles " and "user mapping".

09/10/2011 21:34 viper4513#8

go to your SQL manager, open "security" then right click "logins" then click "new logins" then follow the wizard to make your login.

edit: Juuf beat me to it :P do what he said xD

09/10/2011 21:51 Psycnosis#9

hmm Im installing sql2008R2 now got a wierd problem when I put the password in mixed mode to shaiya123, it says its not complex enough.

09/10/2011 21:57 viper4513#10

put in a more "complex" password then... :P
I didnt use "shaiya123" and i got no problems atall, so it will be fine for you :)

09/10/2011 22:02 JuuF#11

try it with capital "s"

09/10/2011 22:35 Psycnosis#12

Quote:

Originally Posted by JuuF

Connect with windows authentication > security > logins (right click on logins) > new login
then make your account with Login Name='Shaiya', password='Shaiya123' and choose SQL server authentication.Dont forget to change "server roles " and "user mapping".

new problem... it wont let me set the password to shaiya123 for the user shaiya cos its not complex enough... :(

any idea at this point? I figure this is not where i can put it to what I want

Think its cos windows 2008 i more strict about passwords

edit: Didnt help with capital S

edit 2: Figured it out, in win 2008 you have to change the password policies in windows not sql