What's new

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

Sonia

Administrator
Administrator
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
 
Top