Welcome to Onforum.net - Web and gaming resource community

Join us now to get access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, and so, so much more. It's also quick and totally free, so what are you waiting for?

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
 

About us

OnForum.net is a resource community where aspiring webmasters and designers can share content and receive support for a wide variety of software platforms. We are working every day to make sure our community is one of the best.

None of the files are hosted on this site.

PARTNERS

Follow us

We recommend

Doza de Blog
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!