[Tutorial] How to setup and Install MSSQL 2000 for S0,S1,S2 Server files

Results 1 to 2 of 2
  1. #1
    Apprentice Vishera is offline
    MemberRank
    Sep 2017 Join Date
    17Posts

    [Tutorial] How to setup and Install MSSQL 2000 for S0,S1,S2 Server files

    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

    ODBC Registry files:
    ODBCx32_x64.zip

    VirusTotal Scan:
    https://www.virustotal.com/#/file/1e...8999f267e07c5/
    Last edited by Vishera; 20-09-17 at 11:19 AM.


  2. #2
    Novice nirepsa is offline
    MemberRank
    Sep 2017 Join Date
    AULocation
    1Posts

    thumbs up Re: [Tutorial] How to setup and Install MSSQL 2000 for S0,S1,S2 Server files

    Quote Originally Posted by Vishera View Post
    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

    ODBC Registry files:
    ODBCx32_x64.zip

    VirusTotal Scan:
    https://www.virustotal.com/#/file/1e...8999f267e07c5/
    Thank you dude.appreciate it.much help to us



Advertisement