Daktronics

How to Install Microsoft SQL Server 2008 Manually for Venus 1500 v4 or Vanguard v4

Topic

  • How to Install Microsoft SQL Server 2008 Manually for Venus 1500 v4 or Vanguard v4?
    • NOTE: (This does not apply for Show Control Display Studio)

Environment

  • Microsoft SQL Server 2008 Only

Steps

The following steps require a significant amount of technical knowledge. It is recommended for User to seek assistance from their IT or Technical Department or Daktronics Software Support.

It may be necessary to manually install the Microsoft SQL Server 2008 Nucleus Instance.
 
These are NOT valid directions to install the Microsoft SQL Server 2005 that is used for Venus 1500 v4.17 and earlier, Vanguard 4.8 and earlier, all versions of Show Control Display Studio. If needing to install the Microsoft SQL Server 2005 please reference. How to Install Microsoft SQL Server 2005 Manually for Venus 1500 v4, Vanguard v4, or Display Studio v1 .
 
Two possible scenarios needing to manually install the SQL Server 2008 could be:
  • If the SA password needs to be changed to conform to different rules or policies. Typically effects Military or Highly Restricted Security Networks.
  • If the user account needs to be changed from NETWORK_SERVICE to LOCAL_SYSTEM.
  • This procedure must be completed before installing Venus 1500 v4, Vanguard v4, or Display Studio v1.
  1. Download Microsoft SQL Server 2008 Express from Microsoft's Download Centere using newer Browser like Google Chrome or Fire Fox if possible. IE9 and older can cause some issues.
    1. Select Language and click Download.
    2. Choose SQLEXPR_x86_ENU.exe, and click Next.
      *NOTE* Always use the x86 (32 bit) version regardless of OS on the computer.
      • DD2474426 x.jpg
      • You will need to allow Popups, and may need to click the Click Here to try download again.
    3. Select Save As, and save to the Desktop. If not able to see download like in IE 9 you have to find file on C drive and save to desk top.
      • This is the only installer that can be manually installed, you cannot download or use any other type of Microsoft SQL Server 2008.
      • The Microsoft SQL Server 2008 R2 is not supported by these directions.
  2. Run SQLEXPR_x86_ENU.EXE, This will open the SQL Server Installation Center.
  3. From the SQL Server Installation Center, from the left menu click on Installation.
  4. Click on New SQL Server stand-alone installation or add features to an existing installation.
    • SQL 2008 2.jpg
  5. For Setup Support Rules, once passed all operations, click Ok.
  6. For Product Key, there is not one needed, click Next.
  7. Accept the license agreement and click Next.
  8. For Setup Support Files, click Install and Next.
  9. For Feature Selection, only check Database Engine Service, click Next.
    • SQL 2008 3.jpg
  10. For Instance Configuration, select Named instance and enter in Nucleus and click Next.
    • Make sure spelling is correct or it will not configure properly.
    • SQL 2008 4.jpg
  11. For Disk Space Requirements, if you receive a Green Check, it means you meet requirements and can click Next.
    • SQL 2008 5.jpg
  12. For Server Configuration, under the Service Accounts Tab for the SQL Server Database Engine, choose NT AUTHORITY\NETWORK under the Account Name and click Next.
    • 12-5-2014 4-40-49 PM.jpg
  13. For Database Engine Configuration, under Account Provisioning select Mixed Mode (SQL Server Authentication and Windows Authentication).
    1. Enter in SA logon credentials. Venus 1500 v4 can use any password that is desired or required to meet SA Password Rules or Policies. 
      • Or by default SQLServer2008 can be used as the password.
      • Some sites will have password requirements and will need their IT department to select the password. If this is the case you will receive the possible following error:
    2. Under Specify SQL Server administrators click Add Current User or add any additional users as needed.
      • SQL 2008 7.jpg
    3. Click Next.
  14. For Error and Usage Reporting, leave options unchecked and click Next.
    • SQL 2008 8.jpg
  15. Under Installation Rules, click Next.
  16. Under Ready to Install, click Install.
  17. Under Installation Progress, click Next.
  18. Under Complete, you will receive a notice that Your SQL Server 2008 installation completed Successfully, click Close.
  19. You can close out of the SQL Installation Center.

KB ID: DD2474426

DISCLAIMER: Use of this content may void the equipment warranty, please read the disclaimer prior to performing any service of the equipment.

DAKTRONICS DOES NOT PROMISE THAT THE CONTENT PROVIDED HEREIN IS ERROR-FREE OR THAT ANY DEFECTS WILL BE CORRECTED, OR THAT YOUR USE OF THE CONTENT WILL PROVIDE SPECIFIC RESULTS. THE CONTENT IS DELIVERED ON AN "AS-IS" AND "AS-AVAILABLE" BASIS. ALL INFORMATION PROVIDED IN THIS ARTICLE IS SUBJECT TO CHANGE WITHOUT NOTICE. DAKTRONICS DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF ACCURACY, NON-INFRINGEMENT, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. DAKTRONICS DISCLAIMS ANY AND ALL LIABILITY FOR THE ACTS, OMISSIONS AND CONDUCT OF YOU OR ANY THIRD PARTIES IN CONNECTION WITH OR RELATED TO YOUR USE OF THE CONTENT. ADJUSTMENT, REPAIR, OR SERVICE OF THE EQUIPMENT BY ANYONE OTHER THAN DAKTRONICS OR ITS AUTHORIZED REPAIR AGENTS MAY VOID THE EQUIPMENT WARRANTY. YOU ASSUME TOTAL RESPONSIBILITY FOR YOUR USE OF THE CONTENT AND ANY LINKED CONTENT. YOUR SOLE REMEDY AGAINST DAKTRONICS FOR DISSATISFACTION WITH THE CONTENT IS TO STOP USING THE CONTENT. THIS LIMITATION OF RELIEF IS A PART OF THE BARGAIN BETWEEN THE PARTIES.

The above disclaimer applies to any property damage, equipment failure, liability, infringement, or personal injury claim arising out of or in any way related to your use or application of the content, whether such claim is for breach of contract, tort, negligence or any other cause of action.