Help plz
- Thread starter Shadow
- Start date
You have to follow this instructions.
/////////////////////////////////////////////////
A: Setting Up The SQL Server
/////////////////////////////////////////////////
Firstly, if you havn't already, you need to
download the Microsoft SQL Server Trial Edition.
If you have the real version, hey thats cool.
I dunno if this link still works but it did for
me:
http://download.microsoft.com/download/e/6/e/e6ea2122-5c4d-4a0d-baa8-8138548f9973/SQLEVAL.exe
If it doesnt work you can find it on Microsoft.com
To set up the SQL Server, first extract the exe file
to some directory. Go into that directory and run
setup.bat
This batch file opens the Microsoft SQL Server 2000
InstallShield program.
Window One:
Select Local Computer
<Click Next>
Window Two:
Name: Bob (or whatever your name is)
Company: ServerName (or whatever)
<Click Next>
Window Three:
Terms of agreement that no one really cares about..
<Click Yes>
Window Four:
( ) Client Tools
(*) Server and Client Tools (bubbled in)
( ) Connectivity Only
<Click Next>
Some users might get another window.. it might be
just me though because im going through a reinstall
procedure.
Window Five:
I recommend a typical install because thats what ill
be going through.
<Click Next>
Window Six:
(*) Use the same account for each service (bubbled in)
( ) Customize the settings for each service
_Service Settings_
(*) Use the Local System account (bubbled in)
( ) Use a Domain User account
<Click Next>
Window Seven:
( ) Windows Authentication Mode
(*) Mixed Mode (Windows Authentication and SQL Server Authentication) [bubbled in]
Add Password for the sa login:
Enter password: <sapassword>
Confirm password: <sapassword>
<Click Next>
Window Eight:
Click Next
/////////////////////////////////////////////////
B: Setting up your Mircrosoft SQL Server
/////////////////////////////////////////////////
1. Goto the ClientSetup file and follow instructions (complete version)
2. Start > All Programs > Microsoft SQL Server > Enterprise Manager
3. Console Root > Microsoft SQL Servers > SQL Server Group > You P.C.
4. Right Click Databases > New Database
5. Name = mir3db > Click OK
6. Right Click mir3db > All Tasks > Import Data
7. Click Next > Data Source = Microsoft Access
File Name = C:\Mud3\mir3db2.9.mdb
8. Click Next > Data should be entered, Click Next
9. Click Next (Top option should be selected)
10. Click Select All > Click Next
11. Click Next > Click Finnish > Click OK > Click Done
12. Exit SQL Server Enterprise Manager
/////////////////////////////////////////////////
C: Setting Up The ODBC Database
/////////////////////////////////////////////////
Go to your control panel first. Next, click
Administrative Tools. Now click on
Data Sources (ODBC).
Now click Add. Now scroll down and click on
SQL Server. Then click finish.
Now enter this:
Name: mir3db
Description: whatever goes here
Server: (local)
Now on the next page, click the second bubble
on the top. Now enter:
Login ID: sa
Password: ur password
Now at the top of the next page, put a checkmark
by "Change the default database to:" and put it
on mir3db
On the next page leave everything as it is and
click Finish. Then click OK.
/////////////////////////////////////////////////
A: Setting Up The SQL Server
/////////////////////////////////////////////////
Firstly, if you havn't already, you need to
download the Microsoft SQL Server Trial Edition.
If you have the real version, hey thats cool.
I dunno if this link still works but it did for
me:
http://download.microsoft.com/download/e/6/e/e6ea2122-5c4d-4a0d-baa8-8138548f9973/SQLEVAL.exe
If it doesnt work you can find it on Microsoft.com
To set up the SQL Server, first extract the exe file
to some directory. Go into that directory and run
setup.bat
This batch file opens the Microsoft SQL Server 2000
InstallShield program.
Window One:
Select Local Computer
<Click Next>
Window Two:
Name: Bob (or whatever your name is)
Company: ServerName (or whatever)
<Click Next>
Window Three:
Terms of agreement that no one really cares about..
<Click Yes>
Window Four:
( ) Client Tools
(*) Server and Client Tools (bubbled in)
( ) Connectivity Only
<Click Next>
Some users might get another window.. it might be
just me though because im going through a reinstall
procedure.
Window Five:
I recommend a typical install because thats what ill
be going through.
<Click Next>
Window Six:
(*) Use the same account for each service (bubbled in)
( ) Customize the settings for each service
_Service Settings_
(*) Use the Local System account (bubbled in)
( ) Use a Domain User account
<Click Next>
Window Seven:
( ) Windows Authentication Mode
(*) Mixed Mode (Windows Authentication and SQL Server Authentication) [bubbled in]
Add Password for the sa login:
Enter password: <sapassword>
Confirm password: <sapassword>
<Click Next>
Window Eight:
Click Next
/////////////////////////////////////////////////
B: Setting up your Mircrosoft SQL Server
/////////////////////////////////////////////////
1. Goto the ClientSetup file and follow instructions (complete version)
2. Start > All Programs > Microsoft SQL Server > Enterprise Manager
3. Console Root > Microsoft SQL Servers > SQL Server Group > You P.C.
4. Right Click Databases > New Database
5. Name = mir3db > Click OK
6. Right Click mir3db > All Tasks > Import Data
7. Click Next > Data Source = Microsoft Access
File Name = C:\Mud3\mir3db2.9.mdb
8. Click Next > Data should be entered, Click Next
9. Click Next (Top option should be selected)
10. Click Select All > Click Next
11. Click Next > Click Finnish > Click OK > Click Done
12. Exit SQL Server Enterprise Manager
/////////////////////////////////////////////////
C: Setting Up The ODBC Database
/////////////////////////////////////////////////
Go to your control panel first. Next, click
Administrative Tools. Now click on
Data Sources (ODBC).
Now click Add. Now scroll down and click on
SQL Server. Then click finish.
Now enter this:
Name: mir3db
Description: whatever goes here
Server: (local)
Now on the next page, click the second bubble
on the top. Now enter:
Login ID: sa
Password: ur password
Now at the top of the next page, put a checkmark
by "Change the default database to:" and put it
on mir3db
On the next page leave everything as it is and
click Finish. Then click OK.
Upvote
0
You missing a file in DBSrv300.. you need –
!serverinfo.txt
!servertable.txt
!idlist.txt
!absayed.txt
!addrtable.txt
See if you have all them files , if not.. thats the problem and its easy to fix. or your othere setup file may be looking in the wrong dir for files (i not sure about that, but i'm in a rush atm lol)
well that’s what I removed to recreate error
!serverinfo.txt
!servertable.txt
!idlist.txt
!absayed.txt
!addrtable.txt
See if you have all them files , if not.. thats the problem and its easy to fix. or your othere setup file may be looking in the wrong dir for files (i not sure about that, but i'm in a rush atm lol)
well that’s what I removed to recreate error
Last edited:
Upvote
0
The last post I did refereed to Shadows problem.. But I may have an idea on your problem…
When I use to run Mir sever, my Dbcommander (like SQL sever) trial ran out and I could only get past the select char on external internal (any other IP apart from 127.0.0.1)
Check that your trial on SQL hasn’t run out and/or a firewall is not blocking ips. All I can think of right now
When I use to run Mir sever, my Dbcommander (like SQL sever) trial ran out and I could only get past the select char on external internal (any other IP apart from 127.0.0.1)
Check that your trial on SQL hasn’t run out and/or a firewall is not blocking ips. All I can think of right now
Upvote
0
Because I haven’t had this problem on mir3 this is all guess work –
When I changed the ServerPort (see below) the select gate wouldn’t connect. Just wondering, cus you mentioned “7000,7100,7200” .. maybe the 5100 is the problem, think there’s a 5600 port to
(mirgate.ini)
[server]
Color=Green
Title='SelChr Gate'
ServerPort=5100
GatePort=7100
index=0
Server1=xxx.xxx.xxx.xxx
Server2=
Server3=
Server4=
Server5=
When I changed the ServerPort (see below) the select gate wouldn’t connect. Just wondering, cus you mentioned “7000,7100,7200” .. maybe the 5100 is the problem, think there’s a 5600 port to
(mirgate.ini)
[server]
Color=Green
Title='SelChr Gate'
ServerPort=5100
GatePort=7100
index=0
Server1=xxx.xxx.xxx.xxx
Server2=
Server3=
Server4=
Server5=
Upvote
0
Sooden said:
Yep noticed differences
DB server says:
login server 5600
game server 6000
run gate 5100
well login server has only 1600 ports in it.
game server is 5010
which is also the rungate
the selchrgate is 5100 - which could be a conflict??
and loggate runs on 5500.
might try and change ini for rungate to 5600
Upvote
0