[NA - 2008] Server Files & Guide

[blacksystem]

http://forum.ragezone.com/f591/beginners-guide-839032/

Use the DB files from there, I've used them on 3 different SQL versions and never had problems.

files got deleted... can you reupload please?

[[Dev]Reiji]

dont have those any more lol sorry :(

[blacksystem]

dont have those any more lol sorry :(

ok thanks anyway, i'll try by installing another istance on my server, but i dont know if i can keep 2 versions installed at the same time ._.

[[Dev]Reiji]

You should be able to.

[DevWill]

The right version of SQL Server:

32 bit: http://go.microsoft.com/?linkid=9729748
64 bit: http://go.microsoft.com/?linkid=9729749

If you've failed installation on SQL server before, or have/had more than one instance of SQL Server on your computer, I suggest you reset your computer to Factory Settings. Otherwise you could recieve errors.

[blacksystem]

getting some errors starting the services...

000001 2012-05-13 15:57:11 -------------------------------------------------------
000002 2012-05-13 15:57:11 Launching the server.....
000003 2012-05-13 15:57:11 Local  Time      13/05/2012 15:57:11
000004 2012-05-13 15:57:11 System Time(UTC) 13/05/2012 13:57:11
000005 2012-05-13 15:57:11 <SUCCESSED SCRIPTOR READ> config.txt
000006 2012-05-13 15:57:11 <I AM THE _Account DB Server, SERVER_ID_DB_ACCOUNT, WorldNo=0, ZoneNo=0>
000007 2012-05-13 15:57:11 Service start(no parameter)
000008 2012-05-13 15:57:11 <IOCP WORKTHREAD #0 RUNNING>
000009 2012-05-13 15:57:11 <IOCP WORKTHREAD #1 RUNNING>
000010 2012-05-13 15:57:11 <IOCP WORKTHREAD #2 RUNNING>
000011 2012-05-13 15:57:11 <IOCP WORKTHREAD #3 RUNNING>
000012 2012-05-13 15:57:11 <IOCP WORKTHREAD #4 RUNNING>
000013 2012-05-13 15:57:11 <NUMBER OF 5 IOCP WORKTHREAD STARTED, 1 CPU DETECTED>
000014 2012-05-13 15:57:11 DB_Init FAILED = DSN=Account;	UID=*******;	PWD=*******
000015 2012-05-13 15:57:11 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
000016 2012-05-13 15:57:11 < END OF MAIN = 0 >
000017 2012-05-13 15:57:11 <IOCP WORKTHREAD #4 FREE>
000018 2012-05-13 15:57:11 <IOCP WORKTHREAD #3 FREE>
000019 2012-05-13 15:57:12 <IOCP WORKTHREAD #2 FREE>
000020 2012-05-13 15:57:12 <IOCP WORKTHREAD #1 FREE>
000021 2012-05-13 15:57:12 <IOCP WORKTHREAD #0 FREE>

then services close itself....

whats the problem?

(login details censured by me), logins are correct...

[Canic]

000014 2012-05-13 15:57:11 DB_Init FAILED = DSN=Account; UID=*******; PWD=*******

ODBC/Databse name wrong

[blacksystem]

000014 2012-05-13 15:57:11 DB_Init FAILED = DSN=Account; UID=*******; PWD=*******

ODBC/Databse name wrong

how do i get the correct one?

[Canic]

Setting up the database
Fiesta Database runs on MSSQL. I recommend SQL 2008 Express. Make sure you choose "Mixed Mode for easier setup.

Open "SQL Management Studio" login with the details you set while installing.
Right click Databases and choose restore database.
Enter the database name and choose "From File" otherwise it won't work. Browser to and choose a database .bak file.
Restore the following databases:
- Account
- OperatorTool
- AccountLog
- World00_Character
- StatisticsData
- World00_GameLog


Installing the ODBC Connectors
There are different ways for 64 bit computers then there are for 86 bit.

86bit Computer
Open ODBC Management the way you normally would.

64bit Computer
If your running on a 64 bit computer. Then open run and type in or browse to
"%SystemRoot%\sysWOW64\odbcad32.exe"

Go to the System-DSN tab. Click Add and select SQL Server.
Enter your SQL Server Name (Ex. Doodlebob\SQLEXPRESS)

Link the following DSNs to their database:
-Account
-AccountLog
-Character
-GameLog
-OPTool
-Statistics
..........

Here... rofl xD

[blacksystem]

then all is correct.

isn't database name wrong, is something else.

database name = correct
login id's = correct

whats the problem?

[Thekguy]

Athens Client = download = down

[Sailor Moon]

AthensFiesta0013 - 4shared

[Spiritis]

I'm having problem, I'm able to log on and create a character, but when I try to enter the world it gives me the "Map is under maintenance, please try again later" Help please? .-.

[hamisgood87]

I'm having problem, I'm able to log on and create a character, but when I try to enter the world it gives me the "Map is under maintenance, please try again later" Help please? .-.

Are your zone services running?

[Spiritis]

Ah, I've checked and it seems that after about 30seconds to a minute, my zones shut down. ^_^ Thank you! You found my problem! But now I need to know what's wrong with it :/ Any ideas?