Symptom
When setting up an ODBC connection to the AccessControl database, a SQL Server Error is generated when either clicking the dropdown to choose the default database, or when testing the connection.
Connection failed:
SQLState: '28000'
SQL Server Error 18456
[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed
for user 'LENEL'.
Resolution
- Open the Microsoft SQL Server Management Studio application.
- Right-click on the server name in the Object Explorer and select Properties.
- From the Select a page panel, navigate to Security.
- Verify that SQL Server and Windows Authentication mode are selected.
- Restart the SQL Server Service and test again.
- If the same error occurs again, select File > Connect To Object Explorer.
- Change the Authentication method to SQL Server Authentication.
- Test the Lenel user's password to ensure it is correct.
Applies To
OnGuard (all versions)
Additional Information
None
