Return
-
Title
SQL Processing Wizard fails with the error "Login failed for user 'username'. The user is not associated with a trusted SQL Server connection" -
Description
When attempting to process a SQL Server using the SQL Processing Wizard, the task fails with the following log line appearing in the SQLWiz.log file:
"Login failed for user 'username'. The user is not associated with a trusted SQL Server connection"
-
Cause
This is due to the SQL Processing Task being configured to use SQL Authentication when attempting to connect and process the desired SQL instance. However, if the SQL instance has not been configured to use Mixed Mode Authentication this error will be encountered, additionally if there is no SQL Authentication login created this will also be encountered. -
Resolution
To resolve this issue, either create a new SQL Processing Task and use Windows Authentication (ensuring this account does also have a security logon account created within SQL with sysadmin rights granted). Or, enable Mixed Mode Authentication (SQL Server and Windows Authentication Mode).
As well, the following external Microsoft Knowledge Base article discusses some further causes: