Answer
There are two authentication methods by which GFI Software products can authenticate to Microsoft SQL Server 2005 or higher. These are:- Windows authentication
- SQL Server authentication (or mixed authentication).
-
Right-click on the server node and select Properties.
-
Select Security from the left menu under Select a page.
-
Under Server Authentication, select the SQL Server and Windows Authentication mode option.
-
Click OK to close the dialog.
-
Right click on the server node and choose Restart for the changes to take affect.
Enable SQL Server login
-
In the server node expand Security and Logins.
-
Right click on the login name and select Properties.
-
Enter a password and confirm the password for the login.
-
Select Status from the left menu under Select a page.
-
Set the Login option to Enabled.
-
Click OK to close the dialog.