Error: Not Associated with a Trusted SQL Server

Follow

SUMMARY: 

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

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


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

 

SOLUTION

Change the default database to your database name (default: DyKnow40). 


If these measures don't resolve the issue, please contact DyKnow support.

Have more questions? Submit a request

Comments

Powered by Zendesk