Failed to execute query - Login failed for user ''. The user is not associated with a trusted SQL Server connection.
  • 02 Apr 2024
  • 1 Minute to read
  • Dark
    Light
  • PDF

Failed to execute query - Login failed for user ''. The user is not associated with a trusted SQL Server connection.

  • Dark
    Light
  • PDF

Article summary

Installing 3.5 on a remote SQL server (Fails with the following error from the log file)

Failed to execute query - Login failed for user ''. The user is not associated with a trusted SQL Server connection.


  1. Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)" to "Mixed Mode (Windows Authentication and SQL Server Authentication)".

  2. The servers are not apart of the domain, they are on there own work group

    1. You may be running two server that are on there own local work group

    2. You are logged into both servers as local administrator  

    3. The password for the administrator account are not the same on both servers

    4. You need to make both Administrator passwords match

3. Before installing again you need to delete the server value in the database (the installer will throw another error if this is not completed)

Find Server id  

use psbprint

Select * from servers

Run the following comand to delete the entry

use psbprint

DELETE FROM servers WHERE serverid = x


Was this article helpful?


Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.