How can I install SQL Server for Wasp On-Prem on a different drive? (SQL Server Wasp On-Prem User Guide)

Answer

manuals.plus

Mar 04, 2025 - 12:36 AM

To install SQL Server for Wasp On-Prem on a different drive than the system drive, you can follow these steps:

1. Prepare your server features and roles as required by the Wasp On-Prem system.

2. Update the operating system.

3. Locate the Wasp AC or IC OP installation files, which can be from an optical disc, zip archive, or mounted ISO image.

4. Navigate to the ISSetupPrerequisites folder.

5. Copy the folder named "SqlExpress" to a local drive, such as the server's Downloads folder. Ensure that the folder is local to the server and not on a network drive. If needed, unblock the folder depending on your Windows version.

6. Navigate to the newly copied SqlExpress folder.

7. Open the file named "ConfigurationFile.ini" for editing.

8. Add the following lines to the [OPTIONS] section of the file, modifying the path to your desired location:

INSTALLSHAREDDIR="E:\bin\Microsoft SQL Server"

INSTALLSHAREDWOWDIR="E:\bin (x86)\Microsoft SQL Server"

INSTANCEDIR="E:\bin\Microsoft SQL Server"

The modified file should look similar to this:

[OPTIONS]

INSTALLSHAREDDIR="E:\bin\Microsoft SQL Server"

INSTALLSHAREDWOWDIR="E:\bin (x86)\Microsoft SQL Server"

INSTANCEDIR="E:\bin\Microsoft SQL Server"

9. Save the file.

10. Find the file named "Launch64.bat" and right-click on it. Select "Run as administrator".

11. The SQL Express setup will start and the installation process will begin. This may take some time to complete.

12. Once the installation is finished, the SQL Express installer will exit.

13. Close the command prompt.

14. Optionally, you can install SQL Server Management Studio (SSMS) on the server if desired. SSMS can be useful for managing SQL Server.

15. Note that the Wasp On-Prem installer will handle the setup of the databases, so there is no need to run any database setup scripts.

By following these steps, you will have successfully installed SQL Server for Wasp On-Prem on a different drive than the system drive. The use of the configuration file ensures that the collation sequence, SA account, and communication protocols are configured for use.