Any Ideas?

10/31/2012 02:55 Su1ph3r#1

I get this whenever I try to start my test server. All of the services start except for session and then after a few moments the other services fail.

I have never seen these errors before. I copied this straight from the logs:

PS_DBAGENT__system log start (DBAgent01)

gamedata connect error

3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

DBKillCountSave db alloc failed

SAVE kill count ERROR

CKeepObeliskMgr:: DBSave db alloc failed

SAVE g_KeepObeliskMgr ERROR

GuildMgrSave:: DBSave db alloc failed

SAVE g_GuildMgrSave ERROR

PS_DBAGENT__system log end (DBAgent01)

3 1 SService: :ServiceCtrlDispatcher(): service shutdown

10/31/2012 03:32 nephren#2

Please Check your Account on SQL. (Password, Permission etc)

10/31/2012 03:51 Su1ph3r#3

I have already checked the username/pass multiple times. I think it might be something with the linked servers because they fail connection tests.

10/31/2012 03:56 nephren#4

you already checked Linked Server's Connection too?

> Server Objects >Linked Servers > Doubleclick > Security

Account & Password

10/31/2012 04:07 Su1ph3r#5

I now have all the Linked Servers connecting just fine. But I still have the issue with all services starting except session and then going back to pause.

10/31/2012 04:28 nephren#6

Code:

[b]Original Posted by treica[/b]

You mess up some files like kill count datas.
Clean the guild table database > PS_GameData > dbo.guilds then dbo.guilditems and so on.
Also you need the Guild fix, friends and so on, give a search is all fixes here.

10/31/2012 04:37 Su1ph3r#7

I already checked that as well. All the .dbo's that are listed are empty. I also already have the fixes applied. Like I said earlier these servers files are working perfectly on my first test server, but when I copy them to the second test server I get those errors.

10/31/2012 04:47 nephren#8

I have no idea whats wrong in your Second Server but if u wanna know what i would do:

i have to ask because maybe we figured out this:
Did your Test-Server run on the same-machine ?
i mean: did you have two psm-Server Manager on the same machine?

And did you copied only your Database or all files on a differnet path of your (maybe) Second System? Because :

If yes: it cannot Start because your Services locate a different path on your Harddrive.
If no: Please delete all files and "install" it again Step by Step:

Do backups:
Right-Click on your Database's > Task > BackUP
save as .bak file.

After that go on your Second Server and right-click on your normal-standard Databases
Task > Recover > Choose files.

10/31/2012 04:58 Su1ph3r#9

Not sure I follow exactly what you are saying, but here is what I have done:

1. Setup a working test server.
2. Setup Sql Server with the exact same username/pass on a second test server.
3. Copied the server files from C:\shaiyaserver on the first test server to c:\shaiyaserver on the second test server.
4. Installed the shaiya services on the second machine.
5. Start Services.
6. Watch as all services except session start up perfectly, then disconnect.
7. Slam head into nearest wall.

10/31/2012 05:10 nephren#10

So i don't know if it works but try to encrypt your password in your INI Files again.
Normaly it's the same but maybe it works.

If not: iam out, but there will be more ppl who can help u.

Sorry - the only thing that i would do is: a Clean (no copied files) Setup again.

10/31/2012 05:16 Su1ph3r#11

Quote:

Originally Posted by Terence.Hill

So i don't know if it works but try to encrypt your password in your INI Files again.
Normaly it's the same but maybe it works.

I have done that countless times. Each time I use the password encode it encrypts the pass differently, but I have tried it like 18 times now.

Quote:

Sorry - the only thing that i would do is: a Clean (no copied files) Setup again.

I have done this just now and still have the same problem.

I am going to re-install SQL Server yet again and see if that helps.