Setting Up BreadCrumbs Server with SQL 2022 – Sigo Instructions

Target Audience: EBI PRIVATE
Article #: 12693

Summary

Follow the instructions in this article to set up a BreadCrumbs server. The process involves:

  1. Install and Configure SQL Express
  2. Install and configure SQL Reporting Services
  3. Install SQL Management Studio
  4. Install and configure IIS
    • Windows 2019
    • Windows 11
  5. Install .NET Core
  6. Set Up Logs and Database
  7. Add Websites
  8. Install BreadCrumbs Automation Service

Preparation

  • Have the installer for SQL Express 2022 or later.
  • Have local administrator access to the server.

Instructions

Part 1: Install and Configure SQL Express

More detailed instructions can be found here: Install and Configure SQL Express for BreadCrumbs Server – BreadCrumbs Instructions.

  1. Run the SQL Express Installer
  2. SQL Server Installation Center Window – Create a new instance
  3. Microsoft Update Screen – Use Microsoft Update to check for updates
  4. Feature Selection Screen – Make sure to select the following features:
    • Database Engine Services
    • SQL Server Replication
    • Full-Text and Semantic Extractions for Search
    • Leave directory selections at default
  5. Instance Configuration Screen – Select ‘Default instance’ (MSSQLSERVER)
  6. Server Configuration Screen – Accept default service accounts and configurations
  7. Database Engine Configuration Screen
    • Server Configuration Tab – Select Mixed Mode and enter SA password
    • Data Directories Tab –
      • User database directory – create and select C:\MSSQL
      • User database log directory – select C:\MSSQL
      • Backup directory – create and select C:\dbBackups
    • FILESTREAM tab – Enable both:
      • FILESTREAM for Transact-SQLaccess
      • FILESTREAM for file I/O access

Part 2: Install SQL Server Reporting Services

For more detailed instructions: Install and Configure SQL Reporting Services for BreadCrumbs Server

  • Database tab
    • Action screen – Create a new report server database
    • Database Server screen – Confirm default settings (Current User – Integrated Security)
    • Database screen – Confirm defaults (‘ReportServer’ database name)
    • Credentials screen – Confirm defaults (Service Credentials authentication type)
    • Summary screen – Review and confirm before starting database setup
    • Progress and Finish screen – Monitor and confirm database executed correctly
  • Final Confirmation of Report Server Database Setup

    Part 3: Install SQL Management Studio

    1. SQL Server Installation Center Window – Select Install for SQL Server Reporting Services
    2. Microsoft SQL Server Management Tools Website – Use Download SQL Server Management Studio link and then run the installer
    Microsoft Website to Download the SQL Server Management Studio Installer
    Confirmation Screen that Microsoft SQL Server Management Studio is Installed

    Part 4: Install and Configure IIS

    1. Windows Turn Windows Features On or Off – Select IIS and key components
      • Windows Server 2019 Add:
        • Feature: IIS Hostable Web Core
        • Feature: Role Adminstration Tools
        • Role Servcies: Dynamic Content Compression
      • Windows 11 (PC) Add:
        • Internet Information Services
        • (under Internet Information Services) Web Management Tools
        • (under Internet Information Service) Worldwide Web Services
    2. Restart IIS
    Windows Server 2019 Features and Role Services Needed for BreadCrumbs Server
    Windows 11 Internet Information Services Features Web Management Tools and World Wide Web Servcies Must Be Turned On.

     

    Use CMD Prompt (Run as Administrator) to Restart IIS

    Part 5: Install and .NET Core (MUST BE DONE AFTER IIS INSTALL)

    1. Microsoft .NET Core Website – Use this Microsoft link to download and then run the installer: https://dotnet.microsoft.com/permalink/dotnetcore-current-windows-runtime-bundle-installer
    2. Command Prompt: Restart IIS
    Confirms .NET Installation

    Part 6: Set Up Logs, Web Services, and Database

    1. Windows Explorer – Create Two Folders in C:\inetpub\wwwroot directory
      • WsTrackTrace
      • Logs
    2. Microsoft SQL Management Studio – Execute two SQL scripts to create two critical databases (scripts stored in EBS Library under Software/Sigo/BreadCrumbs – look for latest date folder):
      • BreadCrumbs_Assets.sql (MUST BE DONE FIRST)
      • BreadCrumbs_Common.sql (MUST BE DONE AFTER COMMON)
    3. Windows Explorer – Copy web service files to WsTrackTrace folder by unzipping the file from EBS Library under Software/Sigo/BreadCrumbs (e.g. Net7.0-Feb21.zip).
    4. Notepad – Edit appsettings.json file in C:\inetpub\wwwroot\WsTrackTrace\Net7.0 to confirm “LogFileLocation”
    Add Logs and WsTrackTrace Folders
    Location of appsettings.json File

    Appsettings.json File Contents

    PART 7: Add Websites

    Internet Information Services (IIS) Manager
    1. Internet Information Services (IIS) Manager – Add WsTrackTrace Web Site and set Application Pool (under Sites in left navigation)
      • Stop Default Web Site website
      • Add Website screen – Confirm binding (IP address of BreadCrumbs server)
      • Application Pools screen – Set to Integrated for Managed pipeline mode
      • Advanced Settings screen – Verify settings
    2. Windows Explorer – Give the WsTrackTrace application pool user account full access to two folders (first add the user then give permissions):
      • inetpub\wwwroot\logs directory
      • inetpub\wwwroot\wstrackTrace
    3. Microsoft SQL Management Studio – Create SQL login for application pool user
      • Main screen – On left navigation under BreadCrumbs database Security folder) right click to create New Login
      • Logins – New screen General Tab – Enter Login name as IIS APPPOOL\WsTrackTrace
      • Logins – New screen Server Roles – Give Sysadmin role to the new SQL user.
    Add Website Screen
    Select Application Pools from Left-Hand Navigation, then select WsTrackTrace, then verify settings.
    Advanced Settings
    Adding WsTrackTrack User to Folder Security Full Permissions Given to WsTrackTrack User
    Create New Login with IIS-APPPOOL/WsTrackTrace Name and Assign Sysadmin Role

    PART 8: Install BreadCrumbs Automation Services

    Directory Paths that must be added in Sigo Directory
    1. Windows Explorer – Create Sigo directory
      • Add folder structure that matches the Label_Paremeters table in the Commons database
        • C:\Sigo
        • C:\Sigo\Logs
        • C:\Sigo\Automation_Service
        • C:\Sigo\CompletedFiles
        • C:\Sigo\DropFiles
        • C:\Sigo\ErrorFiles
        • C:\Sigo\Labels
        • C:\Sigo\ProcessedFiles
        • C:\Sigo\Automation_Service\Service
      • Add LOCAL SERVICE account and give Full control for each folder.
      • Copy the AutomationService.zip file and extract all of the contents to the C:\Sigo\Automation_Service\Service directory.
    2. PowerShell (run as administrator) – Create a Windows Service by executing the following command: New-Service -Name “BreadCrumbsAutomation” -Description “Sigo BreadCrumbs Import Service” -BinaryPathName C:\Sigo\Automation_Service\Service\Automation_Service.exe
    3. Notepad – Edit appsettings.json file in the C:\Sigo\Automation_Service\Service directory:
      • Verify file paths.
      • Update database location to WebServiceUrl setting
    4. Windows Services – select BreadCrumbsAutomations service, open properties and verify default settings.
    Sigo Directory Structure and Example of LOCAL SERVICE Permissions Needed
    Location of appsettings.json file
    Need to Change WebServiceUrl to Database Location
    Settings Needed for BreadCrumbs Automation Service

    Additional Comments

    Tested using BreadCrumbs Prerelease and SQL Express 2010

  • Database tab
    • Action screen – Create a new report server database
    • Database Server screen – Confirm default settings (Current User – Integrated Security)
    • Database screen – Confirm defaults (‘ReportServer’ database name)
    • Credentials screen – Confirm defaults (Service Credentials authentication type)
    • Summary screen – Review and confirm before starting database setup
    • Progress and Finish screen – Monitor and confirm database executed correctly
  • Final Confirmation of Report Server Database Setup

    Part 3: Install SQL Management Studio

    1. SQL Server Installation Center Window – Select Install for SQL Server Reporting Services
    2. Microsoft SQL Server Management Tools Website – Use Download SQL Server Management Studio link and then run the installer
    Microsoft Website to Download the SQL Server Management Studio Installer
    Confirmation Screen that Microsoft SQL Server Management Studio is Installed

    Part 4: Install and Configure IIS

    1. Windows Turn Windows Features On or Off – Select IIS and key components
      • Windows Server 2019 Add:
        • Feature: IIS Hostable Web Core
        • Feature: Role Adminstration Tools
        • Role Servcies: Dynamic Content Compression
      • Windows 11 (PC) Add:
        • Internet Information Services
        • (under Internet Information Services) Web Management Tools
        • (under Internet Information Service) Worldwide Web Services
    2. Restart IIS
    Windows Server 2019 Features and Role Services Needed for BreadCrumbs Server
    Windows 11 Internet Information Services Features Web Management Tools and World Wide Web Servcies Must Be Turned On.

     

    Use CMD Prompt (Run as Administrator) to Restart IIS

    Part 5: Install and .NET Core (MUST BE DONE AFTER IIS INSTALL)

    1. Microsoft .NET Core Website – Use this Microsoft link to download and then run the installer: https://dotnet.microsoft.com/permalink/dotnetcore-current-windows-runtime-bundle-installer
    2. Command Prompt: Restart IIS
    Microsoft Website for .NET Core Installer Download
    Confirms .NET Installation

    Part 6: Set Up Logs, Web Services, and Database

    1. Windows Explorer – Create Two Folders in C:\inetpub\wwwroot directory
      • WsTrackTrace
      • Logs
    2. Microsoft SQL Management Studio – Execute two SQL scripts to create two critical databases (scripts stored in EBS Library under Software/Sigo/BreadCrumbs – look for latest date folder):
      • BreadCrumbs_Assets.sql (MUST BE DONE FIRST)
      • BreadCrumbs_Common.sql (MUST BE DONE AFTER COMMON)
    3. Windows Explorer – Copy web service files to WsTrackTrace folder by unzipping the file from EBS Library under Software/Sigo/BreadCrumbs (e.g. Net7.0-Feb21.zip).
    4. Notepad – Edit appsettings.json file in C:\inetpub\wwwroot\WsTrackTrace\Net7.0 to confirm “LogFileLocation”
    Add Logs and WsTrackTrace Folders
    Location of appsettings.json File

    Appsettings.json File Contents

    PART 7: Add Websites

    Internet Information Services (IIS) Manager
    1. Internet Information Services (IIS) Manager – Add WsTrackTrace Web Site and set Application Pool (under Sites in left navigation)
      • Stop Default Web Site website
      • Add Website screen – Confirm binding (IP address of BreadCrumbs server)
      • Application Pools screen – Set to Integrated for Managed pipeline mode
      • Advanced Settings screen – Verify settings
    2. Windows Explorer – Give the WsTrackTrace application pool user account full access to two folders (first add the user then give permissions):
      • inetpub\wwwroot\logs directory
      • inetpub\wwwroot\wstrackTrace
    3. Microsoft SQL Management Studio – Create SQL login for application pool user
      • Main screen – On left navigation under BreadCrumbs database Security folder) right click to create New Login
      • Logins – New screen General Tab – Enter Login name as IIS APPPOOL\WsTrackTrace
      • Logins – New screen Server Roles – Give Sysadmin role to the new SQL user.
    Add Website Screen
    Select Application Pools from Left-Hand Navigation, then select WsTrackTrace, then verify settings.
    Advanced Settings
    Adding WsTrackTrack User to Folder Security Full Permissions Given to WsTrackTrack User
    Create New Login with IIS-APPPOOL/WsTrackTrace Name and Assign Sysadmin Role

    PART 8: Install BreadCrumbs Automation Services

    Directory Paths that must be added in Sigo Directory
    1. Windows Explorer – Create Sigo directory
      • Add folder structure that matches the Label_Paremeters table in the Commons database
        • C:\Sigo
        • C:\Sigo\Logs
        • C:\Sigo\Automation_Service
        • C:\Sigo\CompletedFiles
        • C:\Sigo\DropFiles
        • C:\Sigo\ErrorFiles
        • C:\Sigo\Labels
        • C:\Sigo\ProcessedFiles
        • C:\Sigo\Automation_Service\Service
      • Add LOCAL SERVICE account and give Full control for each folder.
      • Copy the AutomationService.zip file and extract all of the contents to the C:\Sigo\Automation_Service\Service directory.
    2. PowerShell (run as administrator) – Create a Windows Service by executing the following command: New-Service -Name “BreadCrumbsAutomation” -Description “Sigo BreadCrumbs Import Service” -BinaryPathName C:\Sigo\Automation_Service\Service\Automation_Service.exe
    3. Notepad – Edit appsettings.json file in the C:\Sigo\Automation_Service\Service directory:
      • Verify file paths.
      • Update database location to WebServiceUrl setting
    4. Windows Services – select BreadCrumbsAutomations service, open properties and verify default settings.
    Sigo Directory Structure and Example of LOCAL SERVICE Permissions Needed
    Location of appsettings.json file
    Need to Change WebServiceUrl to Database Location
    Settings Needed for BreadCrumbs Automation Service

    Additional Comments

    Tested using BreadCrumbs Prerelease and SQL Express 2010

  • Report Server Configuration Manager Application
    • Service Account tab – Use built-in account (Virtual Service Agent)
    • Database tab
      • Action screen – Create a new report server database
      • Database Server screen – Confirm default settings (Current User – Integrated Security)
      • Database screen – Confirm defaults (‘ReportServer’ database name)
      • Credentials screen – Confirm defaults (Service Credentials authentication type)
      • Summary screen – Review and confirm before starting database setup
      • Progress and Finish screen – Monitor and confirm database executed correctly
  • Final Confirmation of Report Server Database Setup

    Part 3: Install SQL Management Studio

    1. SQL Server Installation Center Window – Select Install for SQL Server Reporting Services
    2. Microsoft SQL Server Management Tools Website – Use Download SQL Server Management Studio link and then run the installer
    Microsoft Website to Download the SQL Server Management Studio Installer
    Confirmation Screen that Microsoft SQL Server Management Studio is Installed

    Part 4: Install and Configure IIS

    1. Windows Turn Windows Features On or Off – Select IIS and key components
      • Windows Server 2019 Add:
        • Feature: IIS Hostable Web Core
        • Feature: Role Adminstration Tools
        • Role Servcies: Dynamic Content Compression
      • Windows 11 (PC) Add:
        • Internet Information Services
        • (under Internet Information Services) Web Management Tools
        • (under Internet Information Service) Worldwide Web Services
    2. Restart IIS
    Windows Server 2019 Features and Role Services Needed for BreadCrumbs Server
    Windows 11 Internet Information Services Features Web Management Tools and World Wide Web Servcies Must Be Turned On.

     

    Use CMD Prompt (Run as Administrator) to Restart IIS

    Part 5: Install and .NET Core (MUST BE DONE AFTER IIS INSTALL)

    1. Microsoft .NET Core Website – Use this Microsoft link to download and then run the installer: https://dotnet.microsoft.com/permalink/dotnetcore-current-windows-runtime-bundle-installer
    2. Command Prompt: Restart IIS
    Microsoft Website for .NET Core Installer Download
    Confirms .NET Installation

    Part 6: Set Up Logs, Web Services, and Database

    1. Windows Explorer – Create Two Folders in C:\inetpub\wwwroot directory
      • WsTrackTrace
      • Logs
    2. Microsoft SQL Management Studio – Execute two SQL scripts to create two critical databases (scripts stored in EBS Library under Software/Sigo/BreadCrumbs – look for latest date folder):
      • BreadCrumbs_Assets.sql (MUST BE DONE FIRST)
      • BreadCrumbs_Common.sql (MUST BE DONE AFTER COMMON)
    3. Windows Explorer – Copy web service files to WsTrackTrace folder by unzipping the file from EBS Library under Software/Sigo/BreadCrumbs (e.g. Net7.0-Feb21.zip).
    4. Notepad – Edit appsettings.json file in C:\inetpub\wwwroot\WsTrackTrace\Net7.0 to confirm “LogFileLocation”
    Add Logs and WsTrackTrace Folders
    Location of appsettings.json File

    Appsettings.json File Contents

    PART 7: Add Websites

    Internet Information Services (IIS) Manager
    1. Internet Information Services (IIS) Manager – Add WsTrackTrace Web Site and set Application Pool (under Sites in left navigation)
      • Stop Default Web Site website
      • Add Website screen – Confirm binding (IP address of BreadCrumbs server)
      • Application Pools screen – Set to Integrated for Managed pipeline mode
      • Advanced Settings screen – Verify settings
    2. Windows Explorer – Give the WsTrackTrace application pool user account full access to two folders (first add the user then give permissions):
      • inetpub\wwwroot\logs directory
      • inetpub\wwwroot\wstrackTrace
    3. Microsoft SQL Management Studio – Create SQL login for application pool user
      • Main screen – On left navigation under BreadCrumbs database Security folder) right click to create New Login
      • Logins – New screen General Tab – Enter Login name as IIS APPPOOL\WsTrackTrace
      • Logins – New screen Server Roles – Give Sysadmin role to the new SQL user.
    Add Website Screen
    Select Application Pools from Left-Hand Navigation, then select WsTrackTrace, then verify settings.
    Advanced Settings
    Adding WsTrackTrack User to Folder Security Full Permissions Given to WsTrackTrack User
    Create New Login with IIS-APPPOOL/WsTrackTrace Name and Assign Sysadmin Role

    PART 8: Install BreadCrumbs Automation Services

    Directory Paths that must be added in Sigo Directory
    1. Windows Explorer – Create Sigo directory
      • Add folder structure that matches the Label_Paremeters table in the Commons database
        • C:\Sigo
        • C:\Sigo\Logs
        • C:\Sigo\Automation_Service
        • C:\Sigo\CompletedFiles
        • C:\Sigo\DropFiles
        • C:\Sigo\ErrorFiles
        • C:\Sigo\Labels
        • C:\Sigo\ProcessedFiles
        • C:\Sigo\Automation_Service\Service
      • Add LOCAL SERVICE account and give Full control for each folder.
      • Copy the AutomationService.zip file and extract all of the contents to the C:\Sigo\Automation_Service\Service directory.
    2. PowerShell (run as administrator) – Create a Windows Service by executing the following command: New-Service -Name “BreadCrumbsAutomation” -Description “Sigo BreadCrumbs Import Service” -BinaryPathName C:\Sigo\Automation_Service\Service\Automation_Service.exe
    3. Notepad – Edit appsettings.json file in the C:\Sigo\Automation_Service\Service directory:
      • Verify file paths.
      • Update database location to WebServiceUrl setting
    4. Windows Services – select BreadCrumbsAutomations service, open properties and verify default settings.
    Sigo Directory Structure and Example of LOCAL SERVICE Permissions Needed
    Location of appsettings.json file
    Need to Change WebServiceUrl to Database Location
    Settings Needed for BreadCrumbs Automation Service

    Additional Comments

    Tested using BreadCrumbs Prerelease and SQL Express 2010

  • Report Server Configuration Manager Application
    • Service Account tab – Use built-in account (Virtual Service Agent)
    • Database tab
      • Action screen – Create a new report server database
      • Database Server screen – Confirm default settings (Current User – Integrated Security)
      • Database screen – Confirm defaults (‘ReportServer’ database name)
      • Credentials screen – Confirm defaults (Service Credentials authentication type)
      • Summary screen – Review and confirm before starting database setup
      • Progress and Finish screen – Monitor and confirm database executed correctly
  • Final Confirmation of Report Server Database Setup

    Part 3: Install SQL Management Studio

    1. SQL Server Installation Center Window – Select Install for SQL Server Reporting Services
    2. Microsoft SQL Server Management Tools Website – Use Download SQL Server Management Studio link and then run the installer
    Microsoft Website to Download the SQL Server Management Studio Installer
    Confirmation Screen that Microsoft SQL Server Management Studio is Installed

    Part 4: Install and Configure IIS

    1. Windows Turn Windows Features On or Off – Select IIS and key components
      • Windows Server 2019 Add:
        • Feature: IIS Hostable Web Core
        • Feature: Role Adminstration Tools
        • Role Servcies: Dynamic Content Compression
      • Windows 11 (PC) Add:
        • Internet Information Services
        • (under Internet Information Services) Web Management Tools
        • (under Internet Information Service) Worldwide Web Services
    2. Restart IIS
    Windows Server 2019 Features and Role Services Needed for BreadCrumbs Server
    Windows 11 Internet Information Services Features Web Management Tools and World Wide Web Servcies Must Be Turned On.

     

    Use CMD Prompt (Run as Administrator) to Restart IIS

    Part 5: Install and .NET Core (MUST BE DONE AFTER IIS INSTALL)

    1. Microsoft .NET Core Website – Use this Microsoft link to download and then run the installer: https://dotnet.microsoft.com/permalink/dotnetcore-current-windows-runtime-bundle-installer
    2. Command Prompt: Restart IIS
    Microsoft Website for .NET Core Installer Download
    Confirms .NET Installation

    Part 6: Set Up Logs, Web Services, and Database

    1. Windows Explorer – Create Two Folders in C:\inetpub\wwwroot directory
      • WsTrackTrace
      • Logs
    2. Microsoft SQL Management Studio – Execute two SQL scripts to create two critical databases (scripts stored in EBS Library under Software/Sigo/BreadCrumbs – look for latest date folder):
      • BreadCrumbs_Assets.sql (MUST BE DONE FIRST)
      • BreadCrumbs_Common.sql (MUST BE DONE AFTER COMMON)
    3. Windows Explorer – Copy web service files to WsTrackTrace folder by unzipping the file from EBS Library under Software/Sigo/BreadCrumbs (e.g. Net7.0-Feb21.zip).
    4. Notepad – Edit appsettings.json file in C:\inetpub\wwwroot\WsTrackTrace\Net7.0 to confirm “LogFileLocation”
    Add Logs and WsTrackTrace Folders
    Location of appsettings.json File

    Appsettings.json File Contents

    PART 7: Add Websites

    Internet Information Services (IIS) Manager
    1. Internet Information Services (IIS) Manager – Add WsTrackTrace Web Site and set Application Pool (under Sites in left navigation)
      • Stop Default Web Site website
      • Add Website screen – Confirm binding (IP address of BreadCrumbs server)
      • Application Pools screen – Set to Integrated for Managed pipeline mode
      • Advanced Settings screen – Verify settings
    2. Windows Explorer – Give the WsTrackTrace application pool user account full access to two folders (first add the user then give permissions):
      • inetpub\wwwroot\logs directory
      • inetpub\wwwroot\wstrackTrace
    3. Microsoft SQL Management Studio – Create SQL login for application pool user
      • Main screen – On left navigation under BreadCrumbs database Security folder) right click to create New Login
      • Logins – New screen General Tab – Enter Login name as IIS APPPOOL\WsTrackTrace
      • Logins – New screen Server Roles – Give Sysadmin role to the new SQL user.
    Add Website Screen
    Select Application Pools from Left-Hand Navigation, then select WsTrackTrace, then verify settings.
    Advanced Settings
    Adding WsTrackTrack User to Folder Security Full Permissions Given to WsTrackTrack User
    Create New Login with IIS-APPPOOL/WsTrackTrace Name and Assign Sysadmin Role

    PART 8: Install BreadCrumbs Automation Services

    Directory Paths that must be added in Sigo Directory
    1. Windows Explorer – Create Sigo directory
      • Add folder structure that matches the Label_Paremeters table in the Commons database
        • C:\Sigo
        • C:\Sigo\Logs
        • C:\Sigo\Automation_Service
        • C:\Sigo\CompletedFiles
        • C:\Sigo\DropFiles
        • C:\Sigo\ErrorFiles
        • C:\Sigo\Labels
        • C:\Sigo\ProcessedFiles
        • C:\Sigo\Automation_Service\Service
      • Add LOCAL SERVICE account and give Full control for each folder.
      • Copy the AutomationService.zip file and extract all of the contents to the C:\Sigo\Automation_Service\Service directory.
    2. PowerShell (run as administrator) – Create a Windows Service by executing the following command: New-Service -Name “BreadCrumbsAutomation” -Description “Sigo BreadCrumbs Import Service” -BinaryPathName C:\Sigo\Automation_Service\Service\Automation_Service.exe
    3. Notepad – Edit appsettings.json file in the C:\Sigo\Automation_Service\Service directory:
      • Verify file paths.
      • Update database location to WebServiceUrl setting
    4. Windows Services – select BreadCrumbsAutomations service, open properties and verify default settings.
    Sigo Directory Structure and Example of LOCAL SERVICE Permissions Needed
    Location of appsettings.json file
    Need to Change WebServiceUrl to Database Location
    Settings Needed for BreadCrumbs Automation Service

    Additional Comments

    Tested using BreadCrumbs Prerelease and SQL Express 2010

    1. SQL Server Installation Center Window – Select Install for SQL Server Reporting Services
    2. Microsoft SQL Server Reporting Service Website – Use Download SQL Server 2022 Reporting Services link and then select Download button
    3. Downloads Folder – Run SQL Server Reporting Services installer
    4. MSSQL Reporting Services Installer
      • Welome Screen – Select Install Reporting Services
      • Choose an edition to install – Select Express
      • Specify an install location – Accept default (C:\Program Files\Microsoft SQL Server Reporting Services)
      • Setup completed – Select Configure report server
    5. Report Server Configuration Manager Application
      • Service Account tab – Use built-in account (Virtual Service Agent)
      • Database tab
        • Action screen – Create a new report server database
        • Database Server screen – Confirm default settings (Current User – Integrated Security)
        • Database screen – Confirm defaults (‘ReportServer’ database name)
        • Credentials screen – Confirm defaults (Service Credentials authentication type)
        • Summary screen – Review and confirm before starting database setup
        • Progress and Finish screen – Monitor and confirm database executed correctly
    Final Confirmation of Report Server Database Setup

    Part 3: Install SQL Management Studio

    1. SQL Server Installation Center Window – Select Install for SQL Server Reporting Services
    2. Microsoft SQL Server Management Tools Website – Use Download SQL Server Management Studio link and then run the installer
    Microsoft Website to Download the SQL Server Management Studio Installer
    Confirmation Screen that Microsoft SQL Server Management Studio is Installed

    Part 4: Install and Configure IIS

    1. Windows Turn Windows Features On or Off – Select IIS and key components
      • Windows Server 2019 Add:
        • Feature: IIS Hostable Web Core
        • Feature: Role Adminstration Tools
        • Role Servcies: Dynamic Content Compression
      • Windows 11 (PC) Add:
        • Internet Information Services
        • (under Internet Information Services) Web Management Tools
        • (under Internet Information Service) Worldwide Web Services
    2. Restart IIS
    Windows Server 2019 Features and Role Services Needed for BreadCrumbs Server
    Windows 11 Internet Information Services Features Web Management Tools and World Wide Web Servcies Must Be Turned On.

     

    Use CMD Prompt (Run as Administrator) to Restart IIS

    Part 5: Install and .NET Core (MUST BE DONE AFTER IIS INSTALL)

    1. Microsoft .NET Core Website – Use this Microsoft link to download and then run the installer: https://dotnet.microsoft.com/permalink/dotnetcore-current-windows-runtime-bundle-installer
    2. Command Prompt: Restart IIS
    Microsoft Website for .NET Core Installer Download
    Confirms .NET Installation

    Part 6: Set Up Logs, Web Services, and Database

    1. Windows Explorer – Create Two Folders in C:\inetpub\wwwroot directory
      • WsTrackTrace
      • Logs
    2. Microsoft SQL Management Studio – Execute two SQL scripts to create two critical databases (scripts stored in EBS Library under Software/Sigo/BreadCrumbs – look for latest date folder):
      • BreadCrumbs_Assets.sql (MUST BE DONE FIRST)
      • BreadCrumbs_Common.sql (MUST BE DONE AFTER COMMON)
    3. Windows Explorer – Copy web service files to WsTrackTrace folder by unzipping the file from EBS Library under Software/Sigo/BreadCrumbs (e.g. Net7.0-Feb21.zip).
    4. Notepad – Edit appsettings.json file in C:\inetpub\wwwroot\WsTrackTrace\Net7.0 to confirm “LogFileLocation”
    Add Logs and WsTrackTrace Folders
    Location of appsettings.json File

    Appsettings.json File Contents

    PART 7: Add Websites

    Internet Information Services (IIS) Manager
    1. Internet Information Services (IIS) Manager – Add WsTrackTrace Web Site and set Application Pool (under Sites in left navigation)
      • Stop Default Web Site website
      • Add Website screen – Confirm binding (IP address of BreadCrumbs server)
      • Application Pools screen – Set to Integrated for Managed pipeline mode
      • Advanced Settings screen – Verify settings
    2. Windows Explorer – Give the WsTrackTrace application pool user account full access to two folders (first add the user then give permissions):
      • inetpub\wwwroot\logs directory
      • inetpub\wwwroot\wstrackTrace
    3. Microsoft SQL Management Studio – Create SQL login for application pool user
      • Main screen – On left navigation under BreadCrumbs database Security folder) right click to create New Login
      • Logins – New screen General Tab – Enter Login name as IIS APPPOOL\WsTrackTrace
      • Logins – New screen Server Roles – Give Sysadmin role to the new SQL user.
    Add Website Screen
    Select Application Pools from Left-Hand Navigation, then select WsTrackTrace, then verify settings.
    Advanced Settings
    Adding WsTrackTrack User to Folder Security Full Permissions Given to WsTrackTrack User
    Create New Login with IIS-APPPOOL/WsTrackTrace Name and Assign Sysadmin Role

    PART 8: Install BreadCrumbs Automation Services

    Directory Paths that must be added in Sigo Directory
    1. Windows Explorer – Create Sigo directory
      • Add folder structure that matches the Label_Paremeters table in the Commons database
        • C:\Sigo
        • C:\Sigo\Logs
        • C:\Sigo\Automation_Service
        • C:\Sigo\CompletedFiles
        • C:\Sigo\DropFiles
        • C:\Sigo\ErrorFiles
        • C:\Sigo\Labels
        • C:\Sigo\ProcessedFiles
        • C:\Sigo\Automation_Service\Service
      • Add LOCAL SERVICE account and give Full control for each folder.
      • Copy the AutomationService.zip file and extract all of the contents to the C:\Sigo\Automation_Service\Service directory.
    2. PowerShell (run as administrator) – Create a Windows Service by executing the following command: New-Service -Name “BreadCrumbsAutomation” -Description “Sigo BreadCrumbs Import Service” -BinaryPathName C:\Sigo\Automation_Service\Service\Automation_Service.exe
    3. Notepad – Edit appsettings.json file in the C:\Sigo\Automation_Service\Service directory:
      • Verify file paths.
      • Update database location to WebServiceUrl setting
    4. Windows Services – select BreadCrumbsAutomations service, open properties and verify default settings.
    Sigo Directory Structure and Example of LOCAL SERVICE Permissions Needed
    Location of appsettings.json file
    Need to Change WebServiceUrl to Database Location
    Settings Needed for BreadCrumbs Automation Service

    Additional Comments

    Tested using BreadCrumbs Prerelease and SQL Express 2010

    Author


    Was this article helpful?

    Related Articles