MS-SQL config
HERE IS COPY FROM Zelda803's translation
IF YOU STILL CANT UNDERSAND HOW TO USE SQL CHECK HERE klop's guide
1. Creation of Databases
- lin2world
- lin2comm
- lin2log
- lin2report
- lin2db
- petition
Databases mentioned above should be created.
2. Rightclick the Database - Registered sql server Property Edit(e) Click
sql server identity uses(q) (Check this one)
User Name(l)
Password(a)
Put the Name and Password which you have used on the installation
This is the important part of this installation .Usually errors occur somewhere in
here, so follow along really carefully.
RUN your SQL Server Agent
3. lin2world Database - lin2world_20040609_all.sql Analyze Query,than press save and next to Query Section Analyer, Click on TriangleDisplay box finishes this section.
4. lin2comm Database - lin2comm_new.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.
5. lin2log Database - lin2log_20040416.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.
6. lin2report Database - lin2report_20040416.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.
7. lin2db Database - lin2db_AuthDBSchema.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.
8. lin2db Database - lin2db_update.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.
9. petition Database - petition.sql analyze query next to Query Section Analyer, Click on TriangleDisplay box finishes this section.
IMPORTANT!!!
lin2db Database -> Table -> Server (open table)
add
id = 1
name = same as the worldname in l2server.ini
ip = your WAN IP
inner_ip = your LAN IP
ageLimit = 0
pk_flag = 0 PK not allow; 1 allow
kind=0
port=7777
