How do I configure SQL Server 2005 to accept SQL Authentication?

The information in this article applies to:

  • GFI EndPointSecurity 3
  • GFI EndPointSecurity 4
  • GFI EventsManager 7
  • GFI EventsManager 8
  • GFI LANguard 9.0
  • GFI LANguard Network Security Scanner 7
  • GFI LANguard Network Security Scanner 8

Article ID: KBID002804

Query keywords: database, logon, SQL Server

There are 2 methods of authentication by which GFI ReportCenter can authenticate to SQL Server 2005. 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'. Server Properties - Security
     
  3. Under 'Server Authentication', select the 'SQL Server and Windows Authentication mode option'.
     
  4. Click 'OK' to close the dialog.
     
  5. 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'. Login Properties - Status 
     
  5. Set the 'Login' option to 'Enabled'.
      
  6. Click 'OK' to close the dialog.