The following steps should be performed for installation of the self-hosted version of Guardant Station:
- Plug-in Guardant master key
- Run MSI-installer Guardant Station-X.X.msi
- Setup SQL server connection
- Enter new database name for Guardant Station
- Complete the installation
SQL server connection setup
In case SQL server is installed on the same computer as Guardant Station → it is necessary to leave (local) value in the drop-down list or replace it with the full address (i.e. localhost\SQLEXPRESS).
In addition to SQL server address, server authentication mode should be selected:
- Trusted (Windows Authentication) mode - selection of this mode means that Server Role = "sysadmin" must be added for "NT AUTHORITY\SYSTEM" group on SQL server. This should be done as follows: Launch "Microsoft SQL Server Management Studio" → go to the "Security" section → "Logins" → open "NT AUTHORITY\SYSTEM" group properties → select "Server Role" page → tick "sysadmin" role checkbox
- User name and SQL server password allows to set specific credentials for further authentication and does not require other settings on the server side
Different SQL server versions use differnet ODBC drivers, for example:
- SQL Server 2017 = ODBC Driver 13 for SQL Server
- SQL Server 2019 = ODBC Driver 17 for SQL Server
ODBC driver must be installed on the same computer as Guardant Station.
After Guardant Station installation the files with extension *.properties (grdstation_service.properties and grdactivation_service.properties) containes driver «ODBC Driver 13 for SQL Server» by default.
If another SQL server version is installed, then such files should be adjusted accordingly.
What's next?