How to Manually Install SQL Server 2022 Express and Management Studio for Digital Takeoff
Important Notes
Estimation Desktop 13.2 or later will automatically perform a silent install of SQL Express 2022 & Management Studio by default. For previous versions and other various reasons, a user may want to manually install SQL Server 2022. In these situations, the below instructions for installing SQL Server Express 2022 & Management Studio should be performed to install the DIGITALTAKEOFF SQL instance before Estimation Desktop DataSetup.exe is installed (versions 13.1.2 and earlier.). When DataSetup.exe sees that the DIGITALTAKEOFF SQL instance is already installed, installation of SQL 2014 will be skipped.
NOTES
- These instructions are advanced in nature and it is recommended they be performed by someone with an IT background and/or experience with installing and configuring SQL Server. Please contact Trimble Tech Support for any assistance by visiting https://my.trimble.com to send us a message or chat with a support tech, or send an email to MEPsupport@trimble.com or call Trimble support 800-234-3758.
- It is recommended to be logged into Windows with administrator rights for this installation.
- This installation will require .Net Framework 4.8 installed.
- This installation may require one or more restarts of the computer used for the installation. Be sure to save any changes to documents and close any open files before beginning.
Install SQL Server
- Navigate to https://www.microsoft.com/en-us/download/details.aspx?id=104781
- Click Download.
- From your default Downloads location, run install file.
- Click Download Media.
- Click Download.
- Click Open Folder.
- Run SQLEXPR exe.
- Click OK.
- Select New SQL Server standalone installation or add features to an existing installation.
- Check I accept… and click Next.
- If prompted to Check for Updates, check box and click Next.
- Click Next.
- Uncheck Azure Extension for SQL Server. Click Next.
- Confirm Database Engine Services and SQL Server Replication are checked. Click Next.
- Change Named Instance to DIGITALTAKEOFF. Click Next.
- Confirm Startup Type for both Services are Automatic.
- Change Authentication Mode to Mixed Mode. Enter password and Confirm password. Make notation of password for safe keeping. Click Next.
[Note: if you receive an error regarding .Net 2.0 and 4.0, cancel the installation.
1. Make sure the .Net Frameworks are installed. If not, install both then repeat the installation.
2. If so, uninstall any of the following two files from Apps and Features.
3. Run the installation again As an Administrator.]
- Confirm all installations succeeded. Click Close.
Install SQL Management Studio
- Visit https://learn.microsoft.com/en-us/ssms/install/install
- Under Installation overview, click Release History next to Database Engine compatibility.
- Under Fixed version installers, click version 20.2.1.
- Run vs_SSMS.exe in download files.
- Click Install
- Restart Windows if prompted
Configuration
(NOTE: images may reference DIGITALTAKEOFF5, but follow instructions for DIGITALTAKEOFF)
- Open SQL Server 2022 Configuration Manager
[NOTE: if installed as an Administrator, must be run here as an Administrator.] - Expand the SQL Server Network Configuration. Click on Protocols for DIGITALTAKEOFF. Change the Status from Disabled to Enabled.
- Click on SQL Server Services. Right-click on SQL Server (DIGITALTAKEOFF) and choose Restart. If this is not successful, or if the instance is stopped, contact Support at https://my.trimble.com.
- Open SQL Server Management Studio 20
- Select server Name. Expand for DIGITALTAKEOFF. Change Encryption to Optional. Click Connect.
- Under Object Explorer, Expand Security. Right click on Logins. Choose New Login…
- Enter Login name: LogisticsDT. Select SQL authentication. Leave Password blank. Uncheck Enforce password policy
- Under Select a page, choose Server Roles. Check sysadmin box. Click OK.
- Click Yes on blank password box
- Close Management Studio.
SQL instance is now ready to deploy.