- Install SQL
- Login to the SQL server, launch SQL Management Studio;
- Create a new database. In database settings apply General → Autogrowth / Maximize → File Growth → In Megabytes = 128;
- Choose collation: Options → Collation → SQL_Latin1_General_CP1_CI_AS;
MS SQL 2008 and MS SQL 2008R2 are not supported OS anymore. For MS SQL 2016 choose Options → Compatibility Level = 2014
Issues currently detected with installing Workspace ONE UEM up to version 1909 in Microsoft SQL 2017. Services do not start after install, console does not launch.
As recommended by Microsoft for SQL 2017, services should use the <generatePublisherEvidence> element to improve startup performance. Using this element can also help avoid delays that can cause a time-out and the cancellation of the service startup.
- Create a user in Mixed-mode SQL (non-domain), with sysadmin permissions for server and db_owner for database. Gice the user permissions for msdb: SQLAgentUserRole, SQLAgentReaderRole, db_datareader roles. Do not forget to cancel password expiration for this user;
- If there is not Internet on DB server - download Microsoft .NET Framework 4.6.2 from Microsoft website for English Windows on separate computer and copy to this server (during setup WorkspaceONE_UEM_DB_XX.YY.Z.K_Setup tries to download the framework itself, with no Internet it may hang the installation process for some time);
- Copy WorkspaceONE_UEM_DB_XX.YY.Z.K_Setup files to the server, launch it. Copy to C:\Distr\;
Do not NOT launch installer from C:\Users\Dosuments Documents and Settings\Downloads etc folders - long path may cause unpacking error.
Port binding is needed ONLY for Device Service and Console Service.
- Launch installer WorkspaceONE_UEM_Application_18X.11X.0X.3X_Full_Install. Choose Continue setup without importing/exporting config file;
- In modules selection choose only Device Services, select This feature will not be available for Admin Console, continue installation;