Database Connection
Enter the SQL Server name, port number, select the authentication mode and the name of the database you are connecting to. If you select SQL Authentication, enter the username and password before you click Test Connection to verify that you can connect to the SQL Server. The configuration wizard does not proceed until the connection is successful. When AppScan® Enterprise Server creates the database in SQL Server, it automatically configures the collation for it.
Note:
- AppScan Enterprise supports Windows Authentication and SQL authentication to connect to SQL Database. Refer to Microsoft's article on Authentication Mode and choose the authentication mode that fits your requirement. You can change from one authentication mode to another, but make sure to re-run the configuration wizard.
- The user must be assigned a sysadmin server role on the SQL server. The user must also have access to the database and must be granted a minimum of db_ddladmin, db_datawriter, and db_datareader rights or the db_owner rights.
- The syntax for the SQL Server name has changed with the introduction of Liberty support. ".\SQL_SERVER_NAME" no longer works. Use "HOSTNAME\SQL_SERVER_NAME" instead.
- If your environment uses a named SQL Server instance for the AppScan Enterprise database, make sure that TCP/IP is enabled in the SQL Server configuration manager, and restart the SQL services for SQL Server. Use the port number of the named SQL Server instance instead of the default port number (1443).
- If you have multiple instances and want to remove an instance that is no longer required:
- Clear the Use default name check box.
- Select the name of the relevant instance, click Remove, confirm the removal when prompted, and finish the wizard.
- The Set Recovery Mode to "Simple" checkbox
- This option does not have any impact in case of an upgrade to an existing database.
- When you create or erase a database:
- Select the checkbox to run the database recovery in Simple mode.
- Clear the checkbox, to run the database recovery in the database's default recovery mode. For more information, contact your Database Administrator.
- While running the configuration wizard, clear the Set Recovery Mode to "Simple" checkbox if you use the Azure SQL managed database instance.