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).

In order to use SQL Server authentication you must first configure your server using the steps below.

1. Right-click on the server node and select Properties.

2. Select Security from the left menu under Select a page.

1. Under Server Authentication, select the SQL Server and Windows Authentication mode option.

2. Click OK to close the dialog.

3. Right click on the server node and choose Restart for the changes to take affect.

 

Enable SQL Server login

1. In the server node expand Security and Logins.

2. Right click on the login name and select Properties.

3. Enter a password and confirm the password for the login.

4. Select Status from the left menu under Select a page.

1. Set the Login option to Enabled.

2. Click OK to close the dialog.