- 02 Apr 2024
- 1 Minute to read
- Print
- DarkLight
- PDF
Failed to execute query - Login failed for user ''. The user is not associated with a trusted SQL Server connection.
- Updated on 02 Apr 2024
- 1 Minute to read
- Print
- DarkLight
- PDF
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.
Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)" to "Mixed Mode (Windows Authentication and SQL Server Authentication)".
The servers are not apart of the domain, they are on there own work group
You may be running two server that are on there own local work group
You are logged into both servers as local administrator
The password for the administrator account are not the same on both servers
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