connecting problem !![ get SQL 2000 here ]

[kaks]

EDITED :- THANKS ALL [ spc thx to Mr.gentle ]

now i made server running successfully but m not able to enter in game ......i just get stuck in connecting connecting ......................................................for forever ......

ma ram = 1 GB ..
and cn i get solution to run it !! PLEASE

Please help please !!



Speacial Thanks Goes to Mr.gentle [ Danish ] ................


........................................................................................................Please Help me !!



and for those who want to download SQL 2000 just

To view the content, you need to sign in or register

..............this link will never get died ...
HOW TO INSTALL SQL ....
Step [1.1]
-Extract SQLEVAL.exe
Step [1.2]
-Run Setup.exe and click ''next'' 8 times.
Step [1.3]
-It will show up a window named : Services Accounts
Step [1.4]
-In the Service Settings set it to Use the Local System Account. * else it will give you an error *
Step [1.5]
-Click next and u will see a window named : Authentication Mode window
Step [1.6]
-Set it to Mixed Mode(Windows Authentication and SQL server Authentication) and right password and remeber it or write down it
Step [1.7]
-u need the sa account + password for Online Registration ! and making ODBC Reg!
- After that Click ''Next'' and continue the installation. now this part is done

 

[RudyMartin]

Re: Need Some hELP AND FILE and here u will find sql link

from google I had found this:

To view the content, you need to sign in or register

guide: someone who shows the way by leading or advising

I believe the old thread by legendary is clear enough for that.

 

[kaks]

Re: Need Some hELP AND FILE and here u will find sql link

Itz not my solution dear First Read It care fully

 

[Mrgentle]

Re: Need Some hELP AND FILE and here u will find sql link

Database restoring problem,

so i have found out a possible solution.. so here it is.. what i have done is
I have copied my Database files (working without any error's) .First u need to Create these Databases IN THE ENTERPRISE MANAGER

1)A3ItemEvent
2)ASD
3)HSDB
4)FriendDB
5)ADMIN
7)itemstorage
8)Clan
9)Character

Dont restore tham from any sources do this ...
Now Click Start>All Programs>Microsoft SQL server>Service Manager
STOP THE SQL SERVER
Download this file

To view the content, you need to sign in or register

Go to C:\Program Files\Microsoft SQL Server\MSSQL\Data . and delete all files in the data folder
And extract the downloaded files To the same data folder
(I HOPE U HAVE INSTALLED SQL server in C:\Program Files)

After that, LOOK at all the ini/cfg for your username and password and replace them respectively..

These files needs to be edited

1)AccountServer folder:-
Gminfo.ini, Svrinfo.ini
2)Mainserver folder :-
Gminfo.ini, Svrinfo.ini
3)Battleserver folder:-
Gminfo.ini, Svrinfo.ini
4)Zoneserver folder:-
Gminfo.ini, Svrinfo.ini
6)Loginserver folder:-
Loginserver.ini, Monitor Client.ini
7)Loginagent folder:-
Loginagent.ini, Monitor Client.ini
8)ZoneAgent folder:-
ZoneAgent.ini, Monitor Client.ini
9)7770:-tdb.ini.
10)8880:-tdb.ini.
11)9990:-tdb.ini

Note:- Gminfo.ini Should Contain Gms Id ..AND SHOULD MATCH IN ALL THE SERVER'S AND THEN NUMBER OF GMS SHOULD MATCH WITH THE GMCOUNT

Now u need To Hex the A3client.exe
Open It in Hex Editor
Open Search Type Mercenary
Then rite you will find 6 IP's .Edit them to yours

Create:
C:\A3log
C:\Clan
C:\Zonelog
C:\A3LogBackup
C:\A3_ClanMarkData
how and where i have to create that Pleqase help me all Please

To view the content, you need to sign in or register

Download this File and Extract in your C drive ...


HOPE THIS SOLVES YOUR PROBLEM


If this doesnt Help you .. than i can help by U by taking ur PC on remote .. and creating the Server

 

[kaks]

Re: Need Some hELP AND FILE and here u will find sql link

okie Thx .... i will try this but ....

Can u give me server files i m getting error in extracting the server files ......but got 17 folders ......

and HOW TO CREATE ACCOUNT !!

...................................and i want BDE..and client too |( |( ( .................

 

[doc2mee]

Re: Need Some hELP AND FILE and here u will find sql link

i have tried too
it seems the sql files in the server files has gone missing .. so u cannot create the link in sql server
even i have the ready made database it is not link properly and the server will jz stop.

the BDE files is with the server files....myserver205Modded.

Client u can download from the sticky

ok I got the sql files .. it is now placed in DB files ..

KAKS can we work on the same database? .. I am using the A3server145final

 

[RudyMartin]

Re: Need Some hELP AND FILE and here u will find sql link

if the DB files has a .bak extension then you should restore it using the enterprise manager. if they have .mdf extension (or whatever is the ext for mssql files) then you should copy/overwrite directly into the mssql setup. may be trycky.

 

[doc2mee]

Re: Need Some hELP AND FILE and here u will find sql link

if the DB files has a .bak extension then you should restore it using the enterprise manager. if they have .mdf extension (or whatever is the ext for mssql files) then you should copy/overwrite directly into the mssql setup. may be trycky.

tq rudy

 

[Mrgentle]

Re: Need Some hELP AND FILE and here u will find sql link

tq rudy ???????? tq??

 

[kaks]

i m getting freeze in connecting ..................

help me plzzz

ma Ram is 1 GB


help pls

 

[cvrdheeraj]

Just check if you are getting any "Reply Queries" in Loginserver. It will keep on increasing as u make more and more login attempts. If these come, you need to Increase ur ram or disable some maps!

 

[kaks]

ya m getting reply quer ,........

tell me how to disable map ---------> ??...??

 

[VARUN]

u have not edited 1 or other ip replace all ip's ya evn i faced that problem when i was noob cant help ne 1 at present coz tom is 1st board of my life and on second hand my laptop is still not fixed

 

[cvrdheeraj]

If he gets the Reply Queries, then there is noting to do with misconfigured IPs because the server is listening!

To disable maps, just open the MapInfo.ini located in the Map folder of Zonedata present in the Zoneserver. Just place a ";"(semicolon) in from of the "Map" so that the map is not loaded

Map0=0

Make this:
;Map0=0

 

[Mrgentle]

yea i guided him on my hamachi network ... to disable some maps ..

But i think he also got the same ram compatibility problem

 

[cvrdheeraj]

It might also be because the PayASD is getting loaded and preventing Reply Queries. Just check the Loginserver log and please post the screenies of full running server so that we can check!

 

[iNs@nE]

Thread Closed! Learn to read.