Onforum.net - Web and gaming resource community

Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members .

Mu Online How to setup and Install MSSQL 2000 for S0,S1,S2 Server files

Sonia

Administrator
Administrator
Credits
1,338
Installation

1.Download and install the file:
http://download.microsoft.com/downlo...US/SQLEVAL.exe

2.After the installation is done go to (You can copy and paste the location):
%SystemDrive%\SQLEVAL\X86\setup\
Than open the file:
msetup.exe
choose:
sqlservr.dbd
then press open.
Press:
Sql server 2000 components
Then:
Install Detabase server
1.Press Next
2. Check:
Local Computer
Then press Next
3. Check:
Create a new instance of SQL Server,or install Client Tools
Then press Next
4. Press Next
5. Press Yes
6. Check:
Server and Client Tools
Then press Next
7. Check:
Default
Then press Next
If the option is Grayed-out then Write: Instance name
Then press Next
8. Check:
Typical
Then press Next
9. Check:
Use the same account for each service.Auto start SQL Server Service.
10. Check:
Use the Local System account
Then press Next
11. Check:
Windows Authenticatication Mode
Then press Next
12. Press:
Next
Then wait until the Installation is finished.
Restart your system.

Setting Up


1.Go to:
Start >> All Programs >> Microsoft SQL Server >> Enterprise Manager >> Microsoft SQL Server Group >> (local) (Windows NT)
Right click on:
Databases
Press:
New Database
Write the Database's name in:
Name
Press OK
Right click on your new created database >> All Tasks >> Restore Database
Check:
From Device
Press:
Select Devices
Press:
Add
Press the 3 dots and select the .bak file that came with the server files.
Press OK,Press OK again.
Go to the Options tab.
Check:
Force restore over existing database
In Move to physical file name
Change the paths to where you want the Database file to be located.
Press OK.

2.Go to:
Start >> All Programs >> Microsoft SQL Server >> Enterprise Manager >> Microsoft SQL Server Group >> (local) (Windows NT) >> Security
Right click on:
Logins
Press:
New Login
In Name write your Database User Name
Check:
SQL Server Authentication.
Write you Database Password in Password.
In Database change Master to your Database's Name.
In Language choose English.
Go to the tab:
Server Roles
Check everything with a V
Go to the tab:
Database Access
Check only your Databases with a V.
Press OK,You will be asked to confirm your password,Provide it again.
Press OK.
Right click:
(Local) Windows NT)
Press:
Properties
Go to the tab:
Security
Check:
SQL Server and Windows
Press OK.Then Press Yes.
MSSQL will restart,after it finished restarting you may exit the window.


Don't forget to install ODBC Registry file.
ODBC x32.reg for 32-Bit Operating Systems
ODBC x64.reg for 64-Bit Operating Systems
 
Thread starter Similar threads Forum Replies Date
Sonia MU Online PC Tutorials 2

Similar threads


Top

Dear User!

We found that you are blocking the display of ads on our site.

Please add it to the exception list or disable AdBlock.

The advertises that you'll see aren't intrusive they just help us to keep the community alive

If you don't want to see those ads just buy an upgrade.

Thank you for understanding!

Rogue

Rogue Purchase

User upgrade! at

🔥 Upgrade Now
Baba2

Baba2 Purchase

User upgrade! at

🔥 Upgrade Now

Escanor25 Purchase

User upgrade! at

🔥 Upgrade Now