Setting Up BreadCrumbs Server with SQL 2022 – Sigo Instructions

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

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

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

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

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”

PART 7: Add Websites

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.

PART 8: Install BreadCrumbs Automation Services

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.

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

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

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

 

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

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”

PART 7: Add Websites

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.

PART 8: Install BreadCrumbs Automation Services

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.

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

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

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

 

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

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”

PART 7: Add Websites

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.

PART 8: Install BreadCrumbs Automation Services

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.

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

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

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

 

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

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”

PART 7: Add Websites

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.

PART 8: Install BreadCrumbs Automation Services

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.

Additional Comments

Tested using BreadCrumbs Prerelease and SQL Express 2010

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

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

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

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

 

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

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”

PART 7: Add Websites

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.

PART 8: Install BreadCrumbs Automation Services

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.

Additional Comments

Tested using BreadCrumbs Prerelease and SQL Express 2010

Author

---

Related Articles

• Replace a Database in SSMS – SQL Instructions
• Setting Up BreadCrumbs Server with SQL 2022 – Sigo Instructions
• Create ODBC OLE Data Source for CODESOFT – Instructions
• Create a View from an External Table with a Record ID in TEKLYNX CENTRAL – Instructions
• Configuring the External Database Feature – TEKLYNX CENTRAL Instructions
• Backup a SQL Database to a File – SQL Server Instruction Article