MVP Pre-Install Requirements

Please have the following items prepared prior to CMMS Data Group’s installation. If you have any questions, please email us at: OnPrem@CMMSDataGroup.com

Prior to Arriving on Site MVP Admins do the Following:

• Windows Server
• SQL Server
  • A SQL User for MVP with the server role of sysAdmin.
    • Once the install has been completed the role will be scaled back and sysAdmin can be removed.
  • A domain user account for report execution.

Software to be Installed:

• Windows Server
  • Internet Information Services (IIS 7+)
    • Application Development - ASP.NET Components 3.5 & 4.7.2 or Greater
  • Application Server
    • Most Recent .NET Framework Version
  • Database Server
    • Most Recent .NET Framework Version
  • Microsoft Report Viewer Redistributable 2008
  • Access Database Engine 2010 Redistributable (64 bit)
  • MSMQ (Alerting Services)
    • Basic Installation, no additional features needed
  • All Windows Updates Installed
• .NET Framework 3.5 Features (On all servers if they are being split)
  • .NET Framework 3.5 (Includes .NET 2.0 and 3.0)
• .NET Framework
  • ASP.NET
  • WCF Services
    • HTTP Activation
    • Named Pipe Activation
• Microsoft SQL Server (Standard or Enterprise)
  • Database Service
    • SQL Server Agent
    • Client Tools
    • Client Tools SDK
    • SQL Client Connectivity SDK
    • Install All Service Packs and Updates
  • Reporting Service (Don’t configure)

Configuration:

• IIS
  • ISAPI and CGI security in IIS need to allow .NET 4 at the website level
• SQL Server
  • Report executor domain account should be added the Local SQL reporting services group.
    • Default Install Name: 
      • SQLServerReportServerUser$HOSTNAME$MSRS10.SQLSERVER
  • Report executor domain account should have access to Master, Msdb, ReportServer, and ReportServerTempDB databases with RSExecRole and db_datareader roles.

General Access to:

• Mail Server (SMTP)
• Windows PowerShell 2.0