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
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. ….�?
“Login failed for user ‘sa’. The user is not associated with a trusted SQL Server connection.�?
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.
- In Object Explorer, right click on the instance name and select Properties.
- 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.
- There’ll be an information window shows that you need to restart SQL Server to takes effect of the changes.
- Right-click on the instance name again, select Restart to restart SQL Server service.
- Select Yes.
- Wait for service stop and start.
- 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.
- Select Surface Area Configuration for Services and Connections.
- 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.
- 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.
- You have finished configure. Now try to login to your SQL Server from remote computer using SQL Server authentication mode.
- Login to SQL Server succeeded.
- 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 !
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
)
