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

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