[Guide] Most of vsro files problem solved here

09/17/2011 15:17 Do0mSwEb#1216
Hey guys,
i have downloaded Microsoft SQL Server and installed it.
Now we want to restore the three database files (or add).
When restoring always comes error:

The media family on device 'C:\SRO Database\SRO_VT_ACCOUNT_db_201108210200.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Fehler: 3241)


Can someone help me?
09/17/2011 15:19 nasituygun1#1217
[Only registered and activated users can see links. Click Here To Register...] please help me....
09/17/2011 15:21 isk0rpitx#1218
How can i fix the C9 error ?
09/17/2011 15:38 LegendM#1219
Now I opened everything
Gameserver said
Association Reputation Check is Failed
Agentserver
server cord established : 3 (5.182.10.135:15883)
Shard
Not found RefServerEvent[30002]. Check service and date value. progress next data
failed to permanent removing of character ! [JID: 739530, CharID: 5528, ErrorCode: -10000]
SR_ShardManager is initialized successfully
Smc cant open
[Only registered and activated users can see links. Click Here To Register...]
What should I do?
09/17/2011 15:39 isk0rpitx#1220
When my friends try to connect get C9 error so he click in launcher to the start and get C9 error whats the problem ?

Here is my ip addres / gamebang / privileged ip table's.

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

Here is the server.cfg
09/17/2011 15:47 LegendM#1221
Quote:
Originally Posted by LegendM View Post
Now I opened everything
Gameserver said
Association Reputation Check is Failed
Agentserver
server cord established : 3 (5.182.10.135:15883)
Shard
Not found RefServerEvent[30002]. Check service and date value. progress next data
failed to permanent removing of character ! [JID: 739530, CharID: 5528, ErrorCode: -10000]
SR_ShardManager is initialized successfully
Smc cant open
[Only registered and activated users can see links. Click Here To Register...]
What should I do?
All programs
[Only registered and activated users can see links. Click Here To Register...]
09/17/2011 15:51 gandras16#1222
Quote:
[SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
[SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
[FarmManager] server cord established : 3 (84.32.208.30:53517)
[SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
[SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
[SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
[SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
[SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
[SR_ShardManager] server cord established : 1 (84.32.208.30:32004)
[SR_ShardManager] server cord established : 2 (84.32.208.30:53519)
[AgentServer] server cord established : 2 (84.32.208.30:32005)
[SR_ShardManager] Query Error!!! Query Result : -1, Query : {?=CALL _ExistsServiceOffRentItem}
[SR_ShardManager] SQL Error State:42000, Native Error Code: AFC, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure '_ExistsServiceOffRentItem'.
[SR_ShardManager] {?=CALL _ExistsServiceOffRentItem}
[SR_ShardManager] SR_ShardManager is initialized successfully
[SR_ShardManager] BillingServer is Dead!

hellp
09/17/2011 15:55 nasituygun1#1223
[Only registered and activated users can see links. Click Here To Register...] please help me...
09/17/2011 15:55 Ferpa_#1224
why dont open?

[Only registered and activated users can see links. Click Here To Register...]
09/17/2011 15:56 LegendM#1225
Quote:
Originally Posted by Ferpa_ View Post
why dont open?

[Only registered and activated users can see links. Click Here To Register...]
Your cert is opened?If not just open and try agin :D
09/17/2011 15:57 3lyka#1226
Quote:
[SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
[SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
[FarmManager] server cord established : 3 (84.32.208.30:53517)
[SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
[SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
[SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
[SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
[SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
[SR_ShardManager] server cord established : 1 (84.32.208.30:32004)
[SR_ShardManager] server cord established : 2 (84.32.208.30:53519)
[AgentServer] server cord established : 2 (84.32.208.30:32005)
[SR_ShardManager] Query Error!!! Query Result : -1, Query : {?=CALL _ExistsServiceOffRentItem}
[SR_ShardManager] SQL Error State:42000, Native Error Code: AFC, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure '_ExistsServiceOffRentItem'.
[SR_ShardManager] {?=CALL _ExistsServiceOffRentItem}
[SR_ShardManager] SR_ShardManager is initialized successfully
[SR_ShardManager] BillingServer is Dead!

Quote:
Originally Posted by gandras16 View Post
hellp
Read the first post.

Guys u cant read or what?

SRO_VT_ACCOUNT

Quote:
/****** Object: StoredProcedure [dbo].[_ExistsServiceOffRentItem] Script Date: 09/13/2011 12:03:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE procedure [dbo].[_ExistsServiceOffRentItem]
as

if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) )
begin
return -1
end

GO
09/17/2011 16:00 Ferpa_#1227
Quote:
Originally Posted by LegendM View Post
Your cert is opened?If not just open and try agin :D
what cert?
09/17/2011 16:02 LegendM#1228
Quote:
Originally Posted by Ferpa_ View Post
what cert?
3 - CustomCertificationServer.bat
09/17/2011 16:07 Ferpa_#1229
still error
[Only registered and activated users can see links. Click Here To Register...]
09/17/2011 16:08 tegadil#1230
Abdelfettah i set everything and i can login game but in the game i cant walk ... and 20-30 seconds after gameserver closed please help me