Setting up a server based on VSRO server files

[Chern0byl]

Cherno i will post what I have for billing and srShard.ini database connection/odbc

If i put this in my browser " http://192.168.x.x:8080/ " of course with my ip. It will show this

HTTP Error 403.14 - Forbidden

The Web server is configured to not list the contents of this directory.

Is my first time using IIS so , if the site is not supposed to show that than im doing something wrong.


Shar.ini

[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SRO
query=DRIVER={SQL Server};SERVER=DAYAN-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=ihavemyusernamehere;PWD=andmypasswordhere;DATABASE=SRO_VT_SHARD
query=DRIVER={SQL Server};SERVER=DAYAN-PC\SQLEXPRESS;DSN=SRO_VT_SHARDLOG;UID=myusernamehere;PWD=andmypasswordhere;DATABASE=SRO_VT_SHARDLOG
capacity=1000
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0

When it comes to ODBC. I have setup all 3 odbc with " SQL SERVER" each to its individual database.

I just cant seem to figure out whats the problem.


For DBCONNECT.ASP

<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=DAYAN-PC\SQLEXPRESS;Data Source=192.168.x.x;Initial Catalog=SRO_VT_ACCOUNT;user ID=mydatabaseusername;password=mydatabasepassword;"
DBConnA.Open strConnectA

%>

of course with my ip again.

Leave data provider as it was, change Source to DAYAN-PC\SQLEXPRESS.

[stemale]

Temple : Reputation Check Faild ! - CShardSJ_TempleOfAnubisAndIsisGate

And SR_ShardManager crash...=\

[Chern0byl]

Temple : Reputation Check Faild ! - CShardSJ_TempleOfAnubisAndIsisGate

And SR_ShardManager crash...=\

Full log, please.

[badibatu]

Full log, please.

can u answer my questions ?

[stemale]

Full log, please.

2011-09-13 22:56:39 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:39 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:39 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:39 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:39 [FarmManager] server cord established : 21
2011-09-13 22:56:39 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:40 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:40 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:40 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:40 [SR_ShardManager] server cord established : 1
2011-09-13 22:56:40 [SR_ShardManager] server cord established : 2
2011-09-13 22:56:40 [SR_GameServer] server cord established : 15 (
2011-09-13 22:56:40 [SR_ShardManager] server cord established : 3
2011-09-13 22:56:40 [AgentServer] server cord established : 15
2011-09-13 22:57:29 [SR_ShardManager] SR_ShardManager is initialized successfully
2011-09-13 22:57:29 [SR_ShardManager] BillingServer is Dead!!
2011-09-13 22:57:30 [AgentServer] 705:SR_ShardManager is blind : 0 users are banned
2011-09-13 22:57:30 [SR_GameServer] server cord closed : 15
2011-09-13 22:57:30 [FarmManager] server cord closed : 21

i think this is it

[Larkon]

Leave data provider as it was, change Source to DAYAN-PC\SQLEXPRESS.

I did that , this shardmanager sure really does not want to open at all.. . Just instantly closes.

[Chern0byl]

i think this is it

2011-09-13 22:57:29 [SR_ShardManager] BillingServer is Dead!!

[saxz]

everything Fine now?
can i log on server now?

[Larkon]

Chern when u have a chance , come to teamviewer pretty quick and take a look at this shard. I've done all that you've told me. yet it wont open.

Am i missing a "billing.ini" or "billin.cfg" file that im supposed to have ? Cause I dont have it.

Anyways Teamviewer ID : 912 180 783 PAss: 2110

[Chern0byl]

everything Fine now?
can i log on server now?

Change shard state to Operating, and yep, then you will be able to log in.

[badibatu]

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'CREATE'.

this query giving me this error

USE [Silkroad]
GO
/****** Object: Table [dbo].[_PrivilegedIP] Script Date: 09/13/2011 08:35:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
drop table_PrivilegedIP
CREATE TABLE [dbo].[_PrivilegedIP](
[IP1] [tinyint] NOT NULL,
[IP2] [tinyint] NOT NULL,
[IP3] [tinyint] NOT NULL,
[IP4] [tinyint] NOT NULL,
[IP5] [tinyint] NOT NULL,
[IP6] [tinyint] NOT NULL,
[IP7] [tinyint] NOT NULL,
[IP8] [tinyint] NOT NULL
) ON [PRIMARY]
GO

[saxz]

Change shard state to Operating, and yep, then you will be able to log in.

sorry for noob Q
BUT HOW I DO IT!

[stemale]

2011-09-13 22:57:29 [SR_ShardManager] BillingServer is Dead!!

Yea but how now i can know what a problem ?

[Chern0byl]

sorry for noob Q
BUT HOW I DO IT!

Right click shard service, and search for "Change Service Type -> Operating".

[saxz]

Right click shard service, and search for "Change Service Type -> Operating".

Thx!...........