MS SQL Setup with SQL Server Management Studio
The instructions provided describe how to customize the MS SQL Server database services for Appspace, using SQL Server Management Studio.
Warning
Ensure the SQL root account created during installation has been granted System Administrator privileges in Windows before proceeding.
The instructions provided describe how to configure SQL Server Management Studio for Appspace:
Start SQL Server Management Studio.
In the ‘Connect to Server’ window, select Database Engine from the ‘Server type’ drop-down menu and select Windows Authentication from the Authentication drop-down menu. Click Connect to continue.
Note
Take note of the Server Name field, as it will be used again at a later point.
Once connected to the server, expand the Security folder tree within the Object Explorer. Right-click the Logins folder and select New Login.
In the ‘Login Properties’ window, select General in the ‘Select a page’ pane. Input the Login name as “root”, select the ‘SQL Server authentication’ option, and input a new password of your choice.
Warning
- SQL passwords should NOT contain shell metacharacters such as !#’”`&; or spaces.
- Uncheck the ‘Enforce password policy’ and ‘Enforce password expiration’ options, before clicking OK.
Proceed to select Server Roles in the ‘Select a page’ pane, and ensure the root login is given ‘sysadmin’ permissions.
In the Object Explorer, right-click on the server instance and select Properties.
In the ‘Server Properties’ window, select Connections in the ‘Select a page’ window. In the ‘Default connection options’ section, check the box to select ‘quoted identifier’ and click OK when finished.
In the ‘Server Properties’ window, select Security in the ‘Select a page’ pane. In the ‘Server authentication’ section, select the ‘SQL Server and Windows Authentication mode’ option, and click OK.
Proceed to the Install Appspace Installation Center section.