connecting problem !![ get SQL 2000 here ]
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 click here [ 263.73 MB ]..............this link will never get died:D ...
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
Re: Need Some hELP AND FILE and here u will find sql link
from google I had found this:
define:guide - Google Search
Quote:
guide: someone who shows the way by leading or advising
I believe the old thread by legendary is clear enough for that.
Re: Need Some hELP AND FILE and here u will find sql link
Itz not my solution dear First Read It care fully
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
4shared.com - online file sharing and storage - download Ready made Database.exe
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)
Quote:
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
Quote:
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
RapidShare: 1-Click Webhosting
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
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 :( |( |( ( .................
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
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.
Re: Need Some hELP AND FILE and here u will find sql link
Quote:
Originally Posted by
RudyMartin
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
Re: Need Some hELP AND FILE and here u will find sql link
Re: connecting problem !![ get SQL 2000 here ]
i m getting freeze in connecting ..................
help me plzzz
ma Ram is 1 GB
help pls
Re: connecting problem !![ get SQL 2000 here ]
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!
Re: connecting problem !![ get SQL 2000 here ]
ya m getting reply quer ,........
tell me how to disable map ---------> ??...??
Re: connecting problem !![ get SQL 2000 here ]
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
Re: connecting problem !![ get SQL 2000 here ]
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
Quote:
Map0=0
Make this:
;Map0=0
Re: connecting problem !![ get SQL 2000 here ]
yea i guided him on my hamachi network ... to disable some maps ..
But i think he also got the same ram compatibility problem