Newbie Spellweaver
- Joined
- Dec 27, 2006
- Messages
- 5
- Reaction score
- 0
First Step - Attaching Database:
1: Open Enterprise Manager.
(Or Download MSQL, I reccomend Advanced -
You must be registered to see links
)2: Keep clicking on the + till u see Databases.
3: Now right click and goto All Tasks/Attach Database.
4: Locate the Database files u downloaded.(SQL DB Download -
You must be registered to see links
)5: Click OK.
6: Step 1 Completed!
7: Picture -
You must be registered to see links
(Using another program like MSQLExpress/Business Studio?)
(Then save the DB files into C:\Program Files\Microsoft SQLServer\MSSQL.1\MSSQL\Data)
Second Step - Hex'ing Gamerserver:
1: Open Game Server v20.exe with a hex editor.
(Best Freeware Hex Editor -
You must be registered to see links
) 2: Search for 61.218.244.18 (Line 7C050)
3: Change to your IP. (
You must be registered to see links
)4: Do not change the second one.
5: Save.
6: Step 2 Completed!
7: Picture -
You must be registered to see links
Third Step - ODBC Resource Manager:
1: Open Control Panel.
2: Open Administrative Tools. (Can't find it? Try using the Windows Classic View.)
3: Open Data Sources. (ODBC)
4: Click on System DSN.(Picture Step 1)
5: Click Add. (Picture Step 1)
6: Scroll down the the bottom and double click on SQL Server. (Picture Step 2)
7: In Name type AglaiaSQL. (Picture Step 3)
8: In Description LEAVE BLANK.
9: In Server type in your IP and click Next. (Or enter your MSQL Name)
10: Choose Windows Authentification and click Next. (Picture Step 4)
(If it doesn't work then start your Service Manager. See Picture)
11: Tick Change the default databse to: and select AglaiaSQL, Click Next. (Picture Step 5)
12: Click Next then Next again then OK. (Picture Step 6 & 7)
13: Step 3 Completed!
14: Picture -
You must be registered to see links
,
You must be registered to see links
Fourth Step - SQL Login:
1: Open Enterprise Manager.
2: Click all the + till u see Security.
3: Click on Security and right click on it and select New Login.
4: In Name type in your name.
5: Click SQL Server Authentication and enter a password.
6: Change Database to AglaiaSQL.
7: Click Server Roles at the top.
8: Check all the boxes.
9: Click Databse Access at the Top.
10: Check AglaiaSQL.
11: Check the last 4 boxes in Database roles for `AglaiaSQL`.
12: Clock OK and enter the same password u entered in part 5.
13: Step 4 Completed, or Skipped!
(MSQLExpress has a default login of sa, and password you decide at setup. Skip this!)
Fifth Step - Changing IP's:
1: Goto Authorization Server folder.
2: Open AuthorizationData and create an ID and PASS. (*USED IN STEP 6*)
3: Save & Close.
4: Goto Login Server folder.
5: Open LoginIPData and change ServerIP to your IP
6: Save & Close.
7: Step 5 Completed!
8: Picture -
You must be registered to see links
Sixth Step - Account Creation:
1: Open Enterprise Manager. (Or MSQLExpress)
2: Keep clicking on the + till u see AglaiaSQL.
3: Click again so u can see Tables.
4: Click on Tables.
5: Then you'll be able to see Account in right side window.
6: Then right click on Account, select Open Table.
7: Then simply insert any ID and PASS, this is how you make accounts.
(Make an ID and PASS identical to the ones you used in Step 5:2)
8: Close that window.
9: Next click on Stroke Point.
10: Then right click again and select Open Table.
11: Insert the ID of an account you've created.
12: Fill the rest of the fields as such: 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1
(Each number is a different field in the Stroke Point Table!
You must be registered to see links
)13: Close the window, don't worry it save as you change it.
14: Step 6 Completed!
15: Picture -
You must be registered to see links
Seventh Step - Running The Server:
1: Launch Login Server using the SQL Name and Pass u used in Part 4.
(MSQLExpress users this is the account sa, with password you chose.)
2: Click Start.
3: Launch Authorization Server
4: Click Start
5: Launch Game Server (Takes a minute or two for it to load.)
6: Change Auth ID & PW to what u used in Step 5:2.
7: Change SQL ID & PW to what u used in Step 4:5.
8: Click Start.
9: Step 7 Completed!
(The top of the program should say Read Save Complete after its done loading.)
10: Pictures -
You must be registered to see links
,
You must be registered to see links
Eighth Step - Playing The Server:
1: Open the Aglaia Client Folder.
2: Open IPData-ori.ini with Notepad or Wordpad.
3: Change all Server IP's to your IP Address.
4: Change all Server Ports to 2000.
5: Save & Close.
6: Run the Aglaia.exe program.
7: Login with a username and password you created in Step 6.
(Do not use the one also in the AuthorizationData file, Step 5)
8: Step 8 Completed!
9: Pictures -
You must be registered to see links
,
You must be registered to see links
-For the record, this is just information I've gathered from all the aglaia posts I've read. I'm a bit of a neat freak, and prefer things to be organized. This helps my wife and I to ensure everything is working properly, and if something isn't then it's not hard to backtrack. We've decided to host a server, and develop it as far as we can. Sharing everything along the way!
Credit for this Guide goes to every user who has posted in the Aglaia section.
Last edited:
