ABDEL - CHECK THIS!

09/17/2011 20:48 Lupin*#1
ERROR #1 : [Only registered and activated users can see links. Click Here To Register...]

ERROR #2 : [Only registered and activated users can see links. Click Here To Register...]

i checked everything and i can not find the problem in my configs
09/17/2011 20:51 kevin_owner#2
the first screen says something not supported by the server.

so first question which sql server version are you using?

and does the account has rights to access the database. I also had a problem like this cause the user I created couldn't access the database.
09/17/2011 20:53 Lupin*#3
i am using MSSQL Server & Studio Management 2005

and for the access to they database could you tell me where should i verify that?
09/17/2011 20:55 kevin_owner#4
you can check this too login at the database with the username and password the server files use and simply open the database and right click at a table and select the top 1000 records.
09/17/2011 20:58 Lupin*#5
[Only registered and activated users can see links. Click Here To Register...]

those right you mean?

[Only registered and activated users can see links. Click Here To Register...]

#2
09/17/2011 21:05 kevin_owner#6
I was more thinking about the rights in the security tab.

I logged in with my windows auth and created a new user under Security -> Logins

if you right click at a user and view the properties you can select a few pages. Click on User Mapping. At that page you select the map column for the 3 databases (account, shard, log) and I gave that user for every database the db_owner membership.

so this way I never had any problems with select problems or update problems ect. so You might want to check these things out:)
09/17/2011 21:08 Lupin*#7
[Only registered and activated users can see links. Click Here To Register...]

any idea for this error?
09/17/2011 21:11 kevin_owner#8
Owh it's the user 'sa' which is the system administrator so that user already has all the rights you can imagine.

Uuhm the only idea I have left is to delete the database and restore the originial one. there might be something wrong with that table or something.
09/17/2011 21:13 Lupin*#9
accesly SRO_VT_ACCOUNT wasnt checked in the rights but when i checked the db it gived me this error , could you come on my teamviewer for a sec please since yesterday im on this error
09/17/2011 21:15 kevin_owner#10
Quote:
Originally Posted by thetbot View Post
accesly SRO_VT_ACCOUNT wasnt checked in the rights but when i checked the db it gived me this error , could you come on my teamviewer for a sec please since yesterday im on this error
I'm not gonna join you in teamviewer but the SRO_VT_ACCOUNT doesn't matter since the error is in the SRO_VT_SHARD_INIT database:)

I suggest you to remove the database and restore it with the backup.
09/17/2011 21:16 Lupin*#11
ok ill try that now thank you i appreciate your help

EDIDTED : omg same error for gameserver and shard

11-09-17 12:29:31 [GlobalManager] server cord established : 1 (192.168.1.101:32000)
2011-09-17 12:29:31 [GlobalManager] GlobalManager is initialized successfully
2011-09-17 12:29:34 [GlobalManager] server cord established : 2 (192.168.1.101:51157)
2011-09-17 12:29:35 IBUV: StringSize: 1, CharSet: ABCDEF1234567890
2011-09-17 12:29:35 IBUV: CharSet(ABCDEF1234567890)
2011-09-17 12:29:35 IBUV: Preserved image created : (dwImageCount)
2011-09-17 12:29:50 [GlobalManager] server cord established : 3 (192.168.1.101:51158)
2011-09-17 12:29:55 [GlobalManager] server cord established : 4 (192.168.1.101:51159)
2011-09-17 12:30:03 [GlobalManager] server cord established : 5 (192.168.1.101:51160)
2011-09-17 12:30:03 [FarmManager] server cord established : 1 (192.168.1.101:15880)
2011-09-17 12:30:03 [FarmManager] FarmManager is initialized successfully
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [FarmManager] server cord established : 2 (192.168.1.101:51161)
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] server cord established : 1 (192.168.1.101:15882)
2011-09-17 12:30:20 [SR_ShardManager] Query Error!!! Query Result : -1, Query : SELECT AssociationCodeName,Reputation,PriorOccupation FROM _AssociationReputation WHERE AssociationCodeName = 'TraderHunter' and AssociationTypeName = 'TEMPLE_ANUBIS'
2011-09-17 12:30:20 [SR_ShardManager] SQL Error State:42000, Native Error Code: AD7, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The code page 949 is not supported by the server.

2011-09-17 12:30:20 [SR_ShardManager] SELECT AssociationCodeName,Reputation,PriorOccupation FROM _AssociationReputation WHERE AssociationCodeName = 'TraderHunter' and AssociationTypeName = 'TEMPLE_ANUBIS'
2011-09-17 12:30:20 [SR_ShardManager] SQL Error State:42000, Native Error Code: 4231, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared.
2011-09-17 12:30:20 [SR_ShardManager] SELECT AssociationCodeName,Reputation,PriorOccupation FROM _AssociationReputation WHERE AssociationCodeName = 'TraderHunter' and AssociationTypeName = 'TEMPLE_ANUBIS'
2011-09-17 12:30:35 [FarmManager] server cord established : 3 (192.168.1.101:51162)
2011-09-17 12:30:35 [SR_GameServer] server cord established : 1 (192.168.1.101:15882)
2011-09-17 12:30:37 [SR_ShardManager] server cord established : 2 (192.168.1.101:51163)
2011-09-17 12:30:37 [SR_GameServer] server cord established : 2 (192.168.1.101:15883)
2011-09-17 12:30:55 [SR_ShardManager] OnExit() Called
2011-09-17 12:30:55 [FarmManager] server cord closed : 2
2011-09-17 12:30:56 [SR_GameServer] OnExit() Called
2011-09-17 12:30:56 [FarmManager] server cord closed : 3
2011-09-17 12:30:57 [GlobalManager] server cord closed : 5
2011-09-17 12:30:57 [GlobalManager] server cord closed : 3
2011-09-17 12:30:58 [GlobalManager] server cord closed : 2
2011-09-17 12:31:02 [GlobalManager] server cord closed : 4