Skip to main content
Delphix

Receiving the following error "Attempting to use an NT account name with SQL Server Authentication" but no Issue Reported by the Delphix Engine (KBA6832)

 

KBA

KBA#6832

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.0.0, 6.0.1.0, 6.0.1.1

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1 ,5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

4.3

4.3.1.0, 4.3.2.0, 4.3.2.1, 4.3.3.0, 4.3.4.0, 4.3.4.1, 4.3.5.0

4.2

4.2.0.0, 4.2.0.3, 4.2.1.0, 4.2.1.1, 4.2.2.0, 4.2.2.1, 4.2.3.0, 4.2.4.0 , 4.2.5.0, 4.2.5.1

4.1

4.1.0.0, 4.1.2.0, 4.1.3.0, 4.1.3.1, 4.1.3.2, 4.1.4.0, 4.1.5.0, 4.1.6.0

Troubleshooting why the SQL Server Error log is receiving "Login failed for user 'ac\delphix_svc'. Reason: Attempting to use an NT account name with SQL Authentication."

The Delphix Engine did not report any issue. 

Since SQL Server is reporting the issue, please review following: 

  • SQL Server ERRORLOG

You can see in the Windows application log that SQL Server is reporting the error below:

SQLServerAppLog.png

The frequency of the errors is about 4 per minute for every SQL Server instance on the environment configured in this manner.

Since only the SQL Server instance is reporting the issue and not Delphix,  please check you Database user configuration for this dataset on the Delphix Engine and be sure the user is configured with a Database user and not a domain account:

 

We can see this dataset is configured with a domain user account and not a database user as seen in the SQL Server instance error:

Login failed for user 'ac\delphix_svc'. Reason: Attempting to use an NT account name with SQL Server Authentication.

Resolution

At this point, you need to change the domain user account to a 'SQL login user' as suggested in our documentation:

Database User Requirements for SQL Server

Once you make this change, then the SQL Server instance errors should stop.