...
The personalized connector software provided by Profit Diagnostix as a download link.
The soe administration tool has to be installed usually under
C:\Program Files (x86)\Software of Excellence\EXACT Server\SoeAdmin.exe
Steps:
Installation MS SQL EXPRESS
Installation Profit Diagnostix Connector Software
Configure SOE Admin Tool
Create Upsize Databases on MS SQL EXPRESS Server
Test Upsize process
Setup scheduled task for SOE Admin Tool
Send SQL SERVER Credentials to Profit Diagnostix support
1. Installation MSSQL EXPRESS:
Download and install MSSQL EXPRESS from Microsoft (free)
https://www.microsoft.com/en-us/download/details.aspx?id=55994
Configure
Disable Azure Extension for SQL Server
Disable SQL Replication Feature
Use default instance name (MSSQLSERVER)
Authentication mode: mixed
Set a strong password for user ‘sa’
Keep the password for user ‘sa’ for later.
During the installation the connection string is shown. It contains the name of the server instance, usually
localhost\SQLEXPRESS
. Keep the instance name for later.
Make sure TCP is enabled (“SQL Server Configuration Manager”)
Make sure that the following services are running and startup type is set to Automatic:
SQL Server (SQLEXPRESS)
SQL Server Browser
Make sure that the “sqlcmd” (try run in Poweshell) command line tool is installed. If not it can be downloaded from https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility
...