To prepare a Sybase ASE (Adaptive Server Enterprise) server for SPP, refer to the documentation for your Sybase ASE server for information about how to setup and secure encryption. Make sure the service account you use has the sso_role assigned.
To enable SSL server certificate validation, add the server’s signing authority certificate to the Trusted Certificates store in SPP. For more information, see Trusted CA Certificates.
For more information about how SPP database servers use SSL, see How do SPP database servers use SSL.
SPPsupports SonicOS Internet appliances. SPP uses the SSH protocol to connect to SonicOS devices.
To prepare a SonicOS device for SPP
- Create the service account as a local user on the managed system and assign it a password.
-
Add the service account to the SonicWALL Administrators group. This allows the service account to access the device with SSH to manage users.
IMPORTANT: SPP can only manage passwords for users that are members of the SonicWALL Administrators group.
- Enable and configure the SSH server to allow the service account to log in remotely.
- Add the SonicOS device to SPP using password authentication.
Here are some important notes about configuring a SonicWALL SMA or CMS appliance for SPP:
- Use the local admin account as the service account.
- SPP can only manage the admin account; it cannot manage other local accounts or accounts from external providers.
To prepare a MicrosoftSQL Server for SPP, refer to the documentation for your SQL server for information about how to set up and secure encryption.
To enable SSL server certificate validation, add the server’s signing authority certificate to the Trusted Certificates store in SPP. For more information, see Trusted CA Certificates.
For more information about how SPP database servers use SSL, see How do SPP database servers use SSL.
To configure a SQL Server for SPP (with an authentication type of Local System Account)
NOTE: To manage a Microsoft SQL server asset with the authentication type of Local System Account, you need a local Windows account that is a Security Admin in SQL. In order to use this authentication type, you must add a Windows asset and an SQL Server asset to SPP.
- Log in to the SPP client as an Asset Administrator.
- Navigate to Asset Management > Assets.
- Add a Windows asset that matches the OS of the server that is hosting the SQL database.
- On the Connection tab:
- Authentication Type: Set to Password.
- Service Account: Set to a local user that is a member of the Administrator's group.
-
Add other accounts as needed.
Save the asset.
- Add an SQL Server asset.
-
On the Connection tab:
- Authentication Type: Set to Local System Account.
-
Service Account: Click Select Account and select a local system account from the list.
The accounts available for selection are Windows accounts that are linked to the Windows asset you added in Step 3.
- Run Test Connection and verify the connection works.
Save the asset.
To configure a SQL Server for SPP (with an authentication type of Directory Account)
NOTE: To manage a Microsoft SQL asset with the authentication type of Directory Account, you need a domain account that is a Security Admin in SQL. In order to use this authentication type, you must add a directory and directory users to SPP.
- Add a directory and directory users.
- Log in as an Asset Administrator.
- Navigate to Asset Management > Assets to add a directory for your domain.
- Once added, select the domain and open the Accounts tab to add domain user accounts. For more information, see Adding an account to an asset.
- Add an SQL Server asset and account information.
- Log in to the SPP client as an Asset Administrator.
- From Asset Management > Assets, add an SQL Server asset.
-
On the Connection tab, complete the following:
- Authentication Type: Set to Directory Account.
-
Service Account: Click Select Account and select a domain user account from the list.
The accounts available for selection are domain user accounts that are linked to the directory you added in Step 1.
- Run Test Connection and verify the connection works.
- Save the asset.
To configure a SQL Server for SPP (with an authentication type of Password)
NOTE: To manage a Microsoft SQL server asset with the authentication type of Password, you need a local database account that is a Security Admin in SQL.
- Log in to the SPP client as an Asset Administrator.
- Navigate to Asset Management > Assets.
- Add an SQL Server asset.
-
On the Connection tab:
- Save the asset.