Receiving error 'Cannot Initialize SSPI Package.' during Venus 1500 v4 installation, SQL Server Protocol issue

Potential Symptoms

  • Receiving error 'Cannot Initialize SSPI Package.' when trying to install Venus 1500 v4.
    • Error configuring SQL Server. Cannot initialize SSPI package.
    • DD2404802_2.jpg

Environment

  • Product Family: Software
  • Product:
  • Component: Windows 7 or Windows XP
  • Control System: Venus 1500 v4

Cause

  • There is an issue with the Microsoft Operating System SQL Server Protocols that is not allowing our software to configure the SQL Server for Venus 1500 v4.

Resolution

  • The following resolution may or may not resolve the issue. The suggested settings below to change may be unique depending on if the Computer is or is not hooked up to a Network Domain. Please reference the following blog for more information if the below suggestions do not help: Cannot generate SSPI context
  1. Launch the SQL Server Configuration Manager.
    • SQL Server 2005 - Click Windows Start Menu -> Programs/All Programs -> Microsoft SQL Server 2005 -> Configuration Tools
    • SQL Server 2008 - Click Windows Start Menu -> Programs/All Programs -> Microsoft SQL Server 2008 -> Configuration Tools
  2. From the left menu, click on SQL Server (2005 or 2008) Network Configuration.
  3. Double-click on Protocols for NUCLEUS.
    • This may not be available if Venus 1500 v4 is not fully installed, continue to Step 6.
  4. Make sure Named Pipes is Enabled.
    • Right-click on Named Pipes, choose Enable.
  5. May need to enable or disable TCP/IP. (This setting may very depending on Network Requirements.)
    • Right-click on TCP/IP, choose Enable or Disable.
  6. From the left menu, click on SQL Native Client Configuration.
  7. Double-click on Client Protocols.
  8. Make sure the following named are in the properly listed order:
    • Shared Memory - 1 - Enabled
    • TCP/IP - 2 - Enabled (This may need to be disabled, by right-click and selecting Disable).
    • Named Pipes - 3 - Enabled (This may need to be enabled, by right-click and selecting Enable).
  9. From the left menu, click on SQL Server (2005 or 2008) Services.
  10. Right-click on the SQL Server (NUCLEUS), click Stop.
    • Allow process to complete.
  11. Right-click on the SQL Server (NUCLEUS), click Start.
    • Allow process to complete.
  12. Retry installing Venus 1500 v4.

If these steps do not resolve you can attempt the options below at your own risk.  As such, Daktronics cannot perform or troubleshoot if the options below do not resolve the issue or break the computer. Proceed at your own risk.

  • Option 1: User will need to work with their Computer IT Department on trying to resolve the security issue. Please view the below Microsoft Article on the related issues:
  • Option 2: If the resolution or work around does not resolves the issue, either a System Restore or a Reformatting of the Windows Operating system may be required.

KB ID: DD2404802


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.