WINDOWS INSTALLATION INSTRUCTIONS
- SQL Server
SERENEDI requires a running SQL Server instance; the examples included in these instructions assume that it was installed:
- Using an server instance name of MSSQLSERVER (and not ./SQLEXPRESS)
- Using SQL Mixed Mode authentication
- Using an ‘sa’ password of ‘strongPass1’
- An account and password with local administrator privileges
This is the account that will be used with the SERENEDI Service that is installed. If this is a domain account, it should be expressed in the form DOMAIN\username. If it is a local account, it should be expressed as ‘.\username’ (no quotes).
- SQL Server connection string
This defines the location and possibly the login credentials of the SQL Server account. For different examples of the connection string, visit https://www.connectionstrings.com/sqlconnection/ This connection string will be used in conjunction with the supplied login credentials above to access the SQL Server specified above. It will also specify the name of the distribution database – by convention, this is normally called ‘serenediCore’.
- The SERENEDI Windows installer is a single MSI file, around 120MB in size, looking like this:
- It will likely be named differently than as listed here. Double click on it, and you should receive this popup – click Yes to continue:
Click “Yes” to continue.
- Accept the License Agreement
Click “I accept the agreement” and hit Next.
- Read the installation instructions
Click “Next” when you are finished reading.
- Fill in the Prompts
The Domain\Username prompt is the login credentials used to use the Windows Service. If you are using a local domain account, use “.” For the domain – for example: .\admin
Finally, enter a connection string that SERENEDI will use to connect to an existing serenediCore database (which it will attempt to upgrade, if it has not been upgraded), or to create a new serenediCore database if one does not exist on that server. An example connection that would connect to a local SQL Server instance with an administrator password of ‘strongPass1’ is as follows:
Data Source=(local);Database=serenediCore;User id=sa;Password=strongPass1;TrustServerCertificate=true;
- Enter the Destination Folder
Enter the destination folder for SERENEDI, or use the default in place, and hit “Next.”
- Confirm the Installation
Press “Install” to start the installation process.
- Confirm success
If all steps are successful, you should get a Setup Complete dialog. To further ensure normal operation of SERENEDI, go to C:\serenedi\shared\pipeline, and look for the following folder structure:
If this folder structure exists, then SERENEDI is running and processing events successfully.
1. If upgrading the schema of an existing database and you do not see the new 011 and 012 pipeline folders appear, try running the command on the associated distribution SQL Database:
insert into BIZ_EVENT (event_data3, event_data4) select ‘INITIALIZE’, ‘$\Pipeline.ps1’
2. If you have problems, try validating the SQL login credentials. You may have to install SQL Server Management Studio in order to test the login credentials to the server.
3. Most operations are logged to the serenedi root folder under a file called “install_log” – see if there are any problems there.