This lesson details the steps that need to be taken in both the SQL & FocalScope installations, to successfully use a SQL security account for FocalScope to authenticate with the SQL server. To see steps on the recommended way to get FocalScope to authenticate with an SQL server (using a Windows account).
During the SQL installation, you will be presented with the screen to select between using a Windows account or mixed mode (SQL Server authentication & Windows authentication). By selecting the [Mixed Mode] option, you can enter the password for th SQL "sa" account (system administrator).
WARNING! This is not recommended as SQL account names and passwords are stored in clear text and a security risk. You are strongly advised to use a windows account as its credentials are not stored as clear text. See the lesson Windows Account to accurately configure the Windows account.
Click [Next] to continue.Finish the installation by viewing the chapter, SQL Installation.
You may decide not to use the "sa" account in SQL and prefer to create a dedicated account in your SQL server, for FocalScope ir you are installing FocalScope to connect to a remote SQL server (this requires a dedicated account for FocalScope).
It is critical that this account be part of the "db_owner" database role in SQL, as FocalScope needs to create and modify tables & procedures, especially during its installation.
Expand the [Security] node, then the [Logins] node. Right click on the [Logins] node and select [New Login...].
The "Login - New" configuration page will open. Here we will configure the account we want FocalScope to use to log into the SQL server instance.
Click [OK] when finished. You have now successfully created a login account for FocalScope in your SQL server instance.
During the FocalScope installation, you will be presented with a choice to use either a Windows security account or SQL security account to authenticate with the SQL server. It is recommended to use a Windows account, as the username and password don't get stored in clear text (as is the case with an SQL account username and password). However, should you choose an SQL account over a Windows account, simply...
Continue the FocalScope installation as detailed in the lesson Configure FocalScope Instance.