[HELP!] Installing shaiya server on windows 2008 server

Psycnosis · 09/10/2011, 17:19

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.

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)

viper4513 · 09/10/2011, 19:38

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?

Psycnosis · 09/10/2011, 19:42

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

JuuF · 09/10/2011, 20:04

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

viper4513 · 09/10/2011, 21:00

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)

Psycnosis · 09/10/2011, 21:18

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

JuuF · 09/10/2011, 21:28

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".

viper4513 · 09/10/2011, 21:34

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

Psycnosis · 09/10/2011, 21:51

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.

viper4513 · 09/10/2011, 21:57

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

JuuF · 09/10/2011, 22:02

try it with capital "s"

Psycnosis · 09/10/2011, 22:35

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