Step 1:
Downloading the required files.
Server Files:
You must be registered to see links
Client:
You must be registered to see links
- Thanks To whitemist for the upload.
SQL Server 2000:
You must be registered to see links
(Upgrade to SQL Server 2000 SP3 Patch Recommended)
Step 2:
Setting Up The Databases
After downloading the SQL Server 2000 and the server files - install and extract them to their respective folders.
> Then open
Enterprise Manager in SQL Server 2000.
> Then to go
Databases and create a new database by right clicking. Name it
qtank.
> Then go to
Logins and create a new login by right clicking it. Set the name to
tanky and the password to
1111 (the password should be in the SQL Authentication column). Once this is done, set the login master database to
qtank and give it owner rights by setting it as the
db_owner.
Now the database has been created. You need to restore the database.
> Open
Query Analyzer in SQL Server 2000.
> Authenticate using your SQL master password and you will enter Query Analyzer.
> There you need to open the
tanky.sql file that comes along with the server files. Once this is opened, set your database to
qtank at the top and click on the green button (which looks like play button) or inshort,
RUN it.
Congratulations, You have successfully restored your database.
Step 3:
Setting Up the ODBC's
> Open
Control Panel - Administrative Tools - Data Sources (ODBC) - System DSN Tab
> Click
Add and choose
SQL Server (which is at the end of the list).
> Enter the name as
qtank and set your
server name (which you can find in the Service Manager of SQL Server 2000).
> Then set to
SQL Server Authentication and enter your
ID: sa and
Password: (your master password)
> Then tick change default database to and choose
qtank
> In the end -
Test Database and it it works successfully, then you are all set.
Congratulations on setting your ODBC's correctly.
Step 4:
Configuring Your Server Files
Open your server files folder where you will find
LoginServerSetup.dat and
ServerSetup.dat. Open these files using
Wordpad.
LoginServerSetup.dat
This is the version of your server. Your server and client version should match each other to avoid incompatibility problems.
ServerSetup.dat
Set your
IP Address to either you
local (127.0.0.1) if you want to host it offline or to your
LAN (192.168.1.XXX) if you want to host it on your local area network and your
WAN IP if you want to host it over the internet.
SN Value is the number of rooms setup on the server.
Name is the name of your server which your clients will see.
Step 5:
Configuring Your Client
> In your client folder, you will find the following files -
ClientSetup.dat
> Open the file in WordPad and edit the
IP line to the same you mentioned in the
ServerSetup.dat
Congratulations! You have successfully configured your server and client files.
Step 6:
Launching Your Server
Execute your
LogInServer.exe first and then your
QTankSvr.exe. After executing both, you should see a value
1 and the
IP setup on your Login Server. This means your server has started with no errors.
Congratulations On Setting Up Your Server!
Miscellaneous:
Editing Your Databases
Creating A User ID:
> Open your
Enterprise Manager - Databases -Tables
> Go to the table "
UserData" and right click it. Go to
Open Table - Return All Rows.
> Here you can enter the values you wish and create your User ID.
You can also do the same for the rest of the tables present in the database to edit the respective stuff they stand for.
Thank You,
--
iNs@nE