Daktronics

Venus 1500: How do I confirm what Microsoft SQL Server is being used by version 4?

Topic

How do I confirm what Microsoft SQL Server is being used by Venus 1500 v4?

Environment

  • Venus 1500 v4.18
  • Both SQL Server 2005 and 2008 Installed

Steps

With the recent releases of Venus 1500 4.18, all brand new, first time installs of our software will have Microsoft SQL Server 2008 automatically installed. All Venus 1500 Versions 4.17 and lower and SCS 1.20 and lower being updated to 4.18 or 1.21 and newer will continue to use Microsoft SQL Server 2005.

Why it is important to know what SQL Server is being use? It is due to, when transferring databases, you CANNOT take a Database using SQL Server 2008 and bring it to a computer using SQL Server 2005, even if they are the same software versions. You CAN however take a database using SQL Server 2005 and bring it to a computer using SQL Server 2008. Computers can have both SQL Servers installed, it is just a matter of what server we are using and where our Database instance is stored. This is why it is important to always check before performing a database transfer or using SQL Server 2005/2008 troubleshooting articles.

  1. Launch Venus 1500 v4 (Any version)
  2. Click the Orange V Application Menu -> Help -> About.
  3. Click on the Nucleus Tab.
  4. Look at the Database (Microsoft SQL Server):
    • If it shows 9.XX.XXXX.XX, the computer is using SQL Server 2005.
      • DD2438050_1.jpg
    • If it shows 10.XX.XXXX.XX, the computer is using SQL Server 2008.
      • DD2438050_2.png

Unable to Launch Venus?

If you cannot launch your Venus 1500 v4 software to confirm, please use the following method.

  1. Go to the following location on the computer:
    •  Windows 32 Bit Systems:  C:\Program Files\Microsoft SQL Server
    •  Windows 64 Bit Systems:  C:\Program Files (x86)\Microsoft SQL Server
  • If you see only a folder called MSSQL.1 or any higher number, or multiple, the computer is using a SQL 2005 database.
    DD2438050-1.jpg
  • If you see a folder called MSSQL10.NUCLEUS, the computer is using a SQL 2008 Database, even if there are other MSSQL.X Folders. 
    DD2438050-2.jpg

Alternatively, learn more about Venus Control Suite to enhance your control software experience.

KB ID: DD2438050

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.