You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
Home > Access It! > Access It! Microsoft SQL Server Express Install Summary
Access It! Microsoft SQL Server Express Install Summary
print icon

Overview

When installing Access It! Universal.NET on a server machine, Access It! offers the option to automatically install Microsoft SQL Server 2017 Express. If selected, the installation is automated using the SQL answer file arguments outlined below.

Upgrading SQL

When installing Access It! Universal.NET on a server machine using ASSA ABLOY locksets as well as the Access It! default SQL Server 2008 R2 instance a new SQL instance will be installed. This instance name will be AIUNIVERSAL2017 and after completing the installation the databases will be migrated from the old to new SQL instance.

Login
Beginning with Access It! Universal.NET version 7.1 in an effort to mitigate security concerns, the SQL Express installation will only use Windows authentication. Included with the install the local SYSTEM account is granted administrative rights to the SQL Server as that account is utilized by the Access It! Universal.NET service. 

SQL Answer File Arguments

IACCEPTSQLSERVERLICENSETERMS="True"

IACCEPTPYTHONLICENSETERMS="False"

ACTION="Install"

ROLE="AllFeatures_WithDefaults"

SUPPRESSPRIVACYSTATEMENTNOTICE="True"

IACCEPTROPENLICENSETERMS="True"

ENU="True"

QUIET="False"

QUIETSIMPLE="True"

UpdateEnabled="True"

USEMICROSOFTUPDATE="True"

UpdateSource="MU"

FEATURES=SQLENGINE

HELP="False"

INDICATEPROGRESS="False"

X86="False"

INSTANCENAME="AIUNIVERSAL"

INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server"

INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server"

INSTANCEID="AIUNIVERSAL"

SQLTELSVCACCT="NT Service\SQLTELEMETRY$AIUNIVERSAL"

SQLTELSVCSTARTUPTYPE="Automatic"

INSTANCEDIR="C:\Program Files\Microsoft SQL Server"

AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"

AGTSVCSTARTUPTYPE="Disabled"

COMMFABRICPORT="0"

COMMFABRICNETWORKLEVEL="0"

COMMFABRICENCRYPTION="0"

MATRIXCMBRICKCOMMPORT="0"

SQLSVCSTARTUPTYPE="Automatic"

FILESTREAMLEVEL="0"

ENABLERANU="True"

SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"

SQLSVCACCOUNT="NT AUTHORITY\SYSTEM"

SQLSVCINSTANTFILEINIT="False"

SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" "NT AUTHORITY\SYSTEM"

SQLTEMPDBFILECOUNT="1"

SQLTEMPDBFILESIZE="8"

SQLTEMPDBFILEGROWTH="64"

SQLTEMPDBLOGFILESIZE="8"

SQLTEMPDBLOGFILEGROWTH="64"

ADDCURRENTUSERASSQLADMIN="True"

TCPENABLED="0"

NPENABLED="0"

BROWSERSVCSTARTUPTYPE="Automatic"


scroll to top icon