ABDEL - CHECK THIS!

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

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.

i am using MSSQL Server & Studio Management 2005

and for the access to they database could you tell me where should i verify that?

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.

[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

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:)

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

any idea for this error?

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.

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

Quote:

Originally Posted by thetbot 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.

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