You may receive the following error when trying to log into your admin server:
Login failed for user 'proguser4' or 'xxxxxx'. Reason: Not associated with a trusted SQL Server connection. Alternatively or in addition, you see an error 900007501
In the server pre-installation checklist, there is an instruction that during the installation of the SQL server, the administrator needs to setup the SQL server for “Mixed Mode” security (Both SQL and Windows). If you skip that instruction, then the error above will occur.
To change these settings:
1. Right-click properties on the server in Enterprise Manager / SQL Server Management Studio.
2. Click Security.
3. Click SQL Server and Windows Authentication.
4. Click OK.
You will need to restart the SQL Server service for the change to take effect.
IF YOU RECEIVE THIS ERROR AFTER RUNNING A DITO IMPORT
This is basically a timing error. The import was attempting to access a table that was simultaneously being accessed by users attempting to log in. To resolve this issue:
1. Go to services on your server.
2. Find and bounce the World Wide Web Service.
3. Try to login again.
IF THE ABOVE STEPS DO NOT WORK
In SQL Server Management Studio, expand the Management section and go to Logins. When you select proguser4 and/or ditouser4, the default database is set to master instead of your database name (default: DyKnow40).
Change the default database to your database name (default: DyKnow40).
If these measures don't resolve the issue, please contact DyKnow support.