PortSight Secure Access Documentation

KB-SA-0007-Connection to the database failed



September 1, 2004


Applies to:

Secure Access 2.1 and any later version



I have installed the standard version (version 2.1) and followed the instructions, but I cannot start the web interface due to following error: Login failed for user 'Michael Brown'. Reason: Not associated with a trusted SQL Server connection. The SQL is installed on the same server as the web site. What should I do?



This error occurs because of the default SQL 2000 does not support SQL Server authentication and it supports only Windows authentication. It is necessary to have your SQL Server configured for the 凪ixed authentication mode?


To overcome this limitation:

  1. Enter SQL Enterprise Manager.
  2. Find your server name in the tree on the left.
  3. Right mouse click on the server name and select properties.
  4. Click the Security folder.  You should now see the screen below with "Windows Only" set as the default authentication.
  5. Check SQL Server and Windows as the Authentication.
  6. Click OK.
  7. Click Yes to restart SQL.