Jump to content
  • Sign in to follow this  

    3: Install Microsoft SQL Server (MSSQL)


    Ron

    Summary

    This document will walk you through setting up Microsoft SQL Server 2008 Express, then configuring the game databases. This guide assumes you are installing SQL Server on a fresh operating system.

    If you already have MSSQL installed, skip to 4: Install Game Databases.

    Express Limitations

    Be advised that SQL Sever Express has specific software limitations and limited tools. The full and developer versions of SQL Server come with all features available, but are not publicly available. SQL Server Express may be downloaded publicly directly from Microsoft's website and meets the minimum requirements to get started with development. The installation steps will be the same with all 2008 versions. Newer versions of SQL Server will have additional options but the general steps will be the same.

    MSSQL Download

    1. Visit Microsoft's website to Download Microsoft SQL Server 2008 R2 SP2
      image.png.8f99b4fba489f3ef4631f3809cd4dc8b.png
       
    2. Select SQLEXPRWT_x64_ENU.exe, then click Next. The download will start immediately.
       
    3. Run SQLEXPRWT_x64_ENU.exe from your Downloads folder to extract and run the installer. The installer will run automatically after extraction. Proceed to the next section.
       

    MSSQL Installation Wizard

    1. Click Installation on the sidebar.
      image.png.32278e5d0f229d30af9ed33f4cea54f7.png
       
    2. Select the option for New Installation
      image.png.b09af74f810e3ee74400181ddaab9652.png
       
    3. Click OK after the tests are completed.
      image.png.ad2aaa256e4feb981cb3dcf88f9b61e8.png
       
    4. Ignore the Product Key information and just click Next.
      image.png.06822be78a5dca9446cc5b6383f0a9a4.png
       
    5. Check the box for accepting the License Terms, then click Next
      image.png.326164ffb1a9124601adf4ae719dbf39.png
       
    6. Click Install to install the setup files.
      image.png.bc3766308e31b4a5d4a4eca8722275dc.png
       
    7. Click Next
      image.png.11004ab0e707df9b04275e16a34c1202.png
       
    8. Select SQL Server Feature Installation, then click Next. (no image, sorry)
        
    9. Make sure All Features are selected, then click Next.
      image.png.9eb641bea55fc5bf9b5bb2808d0dd4ca.png
       
    10. Allow Installation Rules to process, then click Next.
      image.png.9ba7c6ee325e67c3fd5edc2aaf8692d0.png
       
    11. Select Default Instance, then click Next

      Don't skip this step. 
      Not setting SQL Server to use the default instance will result in the Server not finding the Databases.


      image.png.fe5b60e1cabb73b96800ea8ac04b5aa4.png
    12. Verify disk checks pass, then click Next
      image.png.0bdb97a2cf3389267ba2cc06c58da86a.png
       
    13. Select NT AUTHORITY\SYSTEM for the Account Name on SQL Server Database Engine, then click Next
      image.png.9a21eb84908aa17883e3b13e97733480.png
       
    14. Under Authentication Mode, select Mixed Mode and enter a secure default password. After, click Add Current User and allow the installer a few moments to load.
      image.png.db8f60961bb43f8a418a7fd455dba07a.png
       
    15. Verify your user is added, then click Next
      image.png.6c37b7d34351d3227874f1a4f431d373.png
       
    16. Click Next to skip through the Error Reporting information
      image.png.c7587614f8f02338f477c0fdee2f57c3.png
       
    17. Click Next through the Installation Rules
      image.png.37ceb71f35d26af5be094170a3cd1064.png
       
    18. Review the summary as needed, then click Install
      image.png.a870ee9072d0d1277ca16846096e015a.png
       
    19. Allow some time for the installer to run. This usually takes around five to ten minutes.
      image.png.90358eb84ed3db0b4304e8ad7d8fdfaa.png
       
    20. Click Close once completed.
      image.png.0c60cfe8bc1e5a9a8b9de63e4b12f82d.png
       
    21. Close the Setup Wizard
      image.png.8fb1f32d5ba2c94e72d879bb2cb4e0b4.png

     

    Windows 7 Additional Configuration

    If you are on Windows 7, some additional configuration is required. TCP/IP in SQL Server is not enabled by default on Windows 7 like it is on Windows 10 and most Windows Server editions. Not enabling TCP/IP causes a zoneserver connection bug when you try to login to the game.

    Fix this issue as follows:

    1. Search for and open SQL Server Configuration Manager.
      image.png.4b571f834f9f5c7e8cb4c07cc14dbfa4.png
       
    2. Locate SQL Server Network Configuration -> Protocols for MSSQL Server, right click TCP/IP, then select Properties.
      image.png.9afb2a86f3a627cff7e3c55946d38778.png
       
    3. Click on the IP Addresses tab.
      image.png.daa4f39d25814adf75865f1cf1a3618d.png
       
    4. Change the Enabled option for IP Address 127.0.0.1.
      image.png.7fc3c23cb16f07db74aaec7817b455b1.png

      image.png.84aab8b52cd823dde927e1a2ba87ab15.png
       
    5. Verify your settings, then click OK. You will see a warning dialog box advising a restart. Click OK again.
      image.png.fe030514750000c6ff7cf24f73cc2500.png

      image.png.e56f8fe68294275d024298861a741960.png
       
    6. Right click TCP/IP and click Enable. Accept the same extra dialog box when prompted.image.png.a8740456a3f28aaef0514e38ca10e6ad.png

      image.png.e56f8fe68294275d024298861a741960.png
       
    7. Verify TCP/IP is Enabled, then close SQL Server Configuration Manager.
      image.png.9a97324004154ff920cc8536ebee6222.png
       
    8. Open Start -> Run, then type in services.msc and press OK.
       image.png.2f8451f40513177bdf60c7049a91a994.png
         
    9. Locate SQL Server (MSSQL), right click it, then select Restart. Allow a moment for MSSQL to restart.
      image.png.2935152d701cfeb8ebf15174d3359ebe.png

    Verify Connection

    Now, let’s confirm we can connect to MSSQL.

    1. Find and run SQL Server Management Studio
      image.png.1ab7e590d838d50b9673d0ff35a25c3c.png
       
    2. Connect to localhost with Windows Authentication
      image.png.d5594d37c845cc1d70e406f9668f3f5c.png
       
    3. You should now be connected to MSSQL through Server Management Studio.
      image.png.7102c5beeeb97c40d51e41384ae47e2e.png

     

    Closing

    You now have a functional instance of MSSQL. You are ready to configure your game databases and ODBC settings. Proceed to 4: Install Game Databases.

    Edited by Ron
    Step 8 had a broken image. Removed for now.

    Sign in to follow this  



×
×
  • Create New...