Hello
let's start real topic
now all can make server with out bugs ~ (Just only still topic for explain billing server cuz most of us path this billing is dead but u don't know it's really still died :D and u will got item bug and DC bug and so)
but now we are on fixing mobs respawn bugs and pet 2
those fixed in patchs wich i will explain then in the last of this topic
Now we will start with mssql (sql server) configuration
Introduction
By default, SQL Server 2005 doesn’t allow remote connection so you have to enable it manually. If you try to connect to remote SQL Server without enable remote connection first, you’ll see one of these error messages.
“An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connection. ….�?
[Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...]
“Login failed for user ‘sa’. The user is not associated with a trusted SQL Server connection.�?
[Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...]
To resolve these problems, you have 2 majors task. One is to enable both SQL Server and Windows authentication mode on SQL Server and the other is to allow remote connection and SQL Server Browser.
Step-by-step
This topic may be found on the Internet in many site or even Microsoft support but the purpose is to rearrange with easier to read and follow with graphic along with each step so it may help you reminder solution faster or even the person who have just start to use SQL Server 2005 Express Edition.
--------------------------------------------------------------
Now we finish sql problems (all errors comes from database gone now !!!)
and u must do what in this sql explain to make patchs works fine ;)
Start explain patchs
patch 3 with same ports !
patch 3.1 with unsame ports !!!
patch 4 with more download server and gateway server and same with 3.1
and patch 4.1 with more download server and gateway server and same with 3.1 !! but more servers in list ! [Only registered and activated users can see links. Click Here To Register...]
Patch 3 = 2 gameserver & 2 agentserver & 2 machinemanager
Patch 3.1 = 2 gameserver & 2 agentserver & 2 machinemanager (with diffrent ports)
Patch 4 = 2 downloadserver & 2 gatewayserver & 2 machinemanager & 2 gameserver & 2 agent server
Patch 4.1 = 2 downloadserver & 2 gatewayserver & 2 machinemanager & 2 gameserver & 2 agent server & 2 sharedmanager
Patch 5 = 2 downloadserver & 2 gatewayserver & 3 machinemanager & 3 gameserver & 3 agent server
Patch 5.1 = 2 downloadserver & 2 gatewayserver & 3 machinemanager & 3 gameserver & 3 agent server & 3 sharedmanager
Patch 3 & 3.1 & 4 & 4.1
hosted on 2 machines (can't host on vmware :( )
Patch 5 & 5.1
more stable but must hosted on 3 machines (can't host on vmware 2 :( )
Patch 4.1 & 5.1
u must Edot db _SharedService
with
64 0
65 0
that's for 4.1 and for 5.1
64 0
65 0
66 0
Works and more explain u will find notbad in each patch explain what's it's function and how to open it ;) and u will find too in this .txt the ports u must open on firewall (i suggest to use plesk panel it will make much easyer thing to ur server in creat ftp or website or make db mssql ;) )
-----------------------------------------------------------
Edit
in
in patch 5&5.1
-----------------------------------------------------------------------------------
(My Final Work)
Now
Download Patches From attachement
Have a Nice Time (Don't forget to Like :) )
let's start real topic
now all can make server with out bugs ~ (Just only still topic for explain billing server cuz most of us path this billing is dead but u don't know it's really still died :D and u will got item bug and DC bug and so)
but now we are on fixing mobs respawn bugs and pet 2
those fixed in patchs wich i will explain then in the last of this topic
Now we will start with mssql (sql server) configuration
Introduction
By default, SQL Server 2005 doesn’t allow remote connection so you have to enable it manually. If you try to connect to remote SQL Server without enable remote connection first, you’ll see one of these error messages.
“An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connection. ….�?
[Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...]
“Login failed for user ‘sa’. The user is not associated with a trusted SQL Server connection.�?
[Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...]
To resolve these problems, you have 2 majors task. One is to enable both SQL Server and Windows authentication mode on SQL Server and the other is to allow remote connection and SQL Server Browser.
Step-by-step
- Check that you have allowed both SQL Server and Windows Authentication mode (If you’re not use Windows Authentication mode). For instance, user ‘sa’.
- Login to SQL Server using SQL Server Management Studio Express on local SQL Server with Windows Authentication user. This will use Windows account to authenticate to SQL Server.
[Only registered and activated users can see links. Click Here To Register...] - In Object Explorer, right click on the instance name and select Properties.
[Only registered and activated users can see links. Click Here To Register...] - On the left, select Security and change Server authentication to SQL Server and Windows Authentication mode. If the choice is already selected, that means you have already allowed SQL Server authentication.
[Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] - There’ll be an information window shows that you need to restart SQL Server to takes effect of the changes.
[Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] - Right-click on the instance name again, select Restart to restart SQL Server service.
[Only registered and activated users can see links. Click Here To Register...] - Select Yes.
[Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] - Wait for service stop and start.
[Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] - That’s it. You have enabled both SQL Server and Windows authentication so now you can login to SQL Server with your current Windows account or your created account.
- Login to SQL Server using SQL Server Management Studio Express on local SQL Server with Windows Authentication user. This will use Windows account to authenticate to SQL Server.
- Check that you have enabled remote connection on SQL Server Surface Area Configuration
- Open SQL Server Surface Area Configuration.
[Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] - Select Surface Area Configuration for Services and Connections.
[Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] - On the left side, expand your SQL Server instance -> Database Engine -> Remote Connections. On the right side, select Local and remote connections -> using both TCP/IP and named pipes.
[Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] - On the left side, select SQL Server Browser -> Service.
On the right side, if the startup type is Disable, you need to change to Automatic and click Apply and click Start button to start the service. Then, click OK.
[Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] - You have finished configure. Now try to login to your SQL Server from remote computer using SQL Server authentication mode.
[Only registered and activated users can see links. Click Here To Register...] - Login to SQL Server succeeded.
[Only registered and activated users can see links. Click Here To Register...]
- Open SQL Server Surface Area Configuration.
This topic may be found on the Internet in many site or even Microsoft support but the purpose is to rearrange with easier to read and follow with graphic along with each step so it may help you reminder solution faster or even the person who have just start to use SQL Server 2005 Express Edition.
--------------------------------------------------------------
Now we finish sql problems (all errors comes from database gone now !!!)
and u must do what in this sql explain to make patchs works fine ;)
Start explain patchs
patch 3 with same ports !
patch 3.1 with unsame ports !!!
patch 4 with more download server and gateway server and same with 3.1
and patch 4.1 with more download server and gateway server and same with 3.1 !! but more servers in list ! [Only registered and activated users can see links. Click Here To Register...]
Patch 3 = 2 gameserver & 2 agentserver & 2 machinemanager
Patch 3.1 = 2 gameserver & 2 agentserver & 2 machinemanager (with diffrent ports)
Patch 4 = 2 downloadserver & 2 gatewayserver & 2 machinemanager & 2 gameserver & 2 agent server
Patch 4.1 = 2 downloadserver & 2 gatewayserver & 2 machinemanager & 2 gameserver & 2 agent server & 2 sharedmanager
Patch 5 = 2 downloadserver & 2 gatewayserver & 3 machinemanager & 3 gameserver & 3 agent server
Patch 5.1 = 2 downloadserver & 2 gatewayserver & 3 machinemanager & 3 gameserver & 3 agent server & 3 sharedmanager
Patch 3 & 3.1 & 4 & 4.1
hosted on 2 machines (can't host on vmware :( )
Patch 5 & 5.1
more stable but must hosted on 3 machines (can't host on vmware 2 :( )
Patch 4.1 & 5.1
u must Edot db _SharedService
with
64 0
65 0
that's for 4.1 and for 5.1
64 0
65 0
66 0
Works and more explain u will find notbad in each patch explain what's it's function and how to open it ;) and u will find too in this .txt the ports u must open on firewall (i suggest to use plesk panel it will make much easyer thing to ur server in creat ftp or website or make db mssql ;) )
-----------------------------------------------------------
Edit
in
change node_type=335 to node_type=336Quote:
[entry3]
node_id=699
operation_type=22
global_operation_id=0
associated_shard_id=0
node_type=335
service_type=4
certification_node_id=697
port=15778
node_icon=0
u1=96
u2=23
u3=24
u4=1
u5=48
u6=148
u7=19
u8=1
u9=64
u10=160
u11=17
u12=1
u13=0
u14=0
u15=0
u16=0
u17=0
u18=0
u19=0
u20=0
in patch 5&5.1
-----------------------------------------------------------------------------------
(My Final Work)
Now
Download Patches From attachement
Have a Nice Time (Don't forget to Like :) )
