Exception occured in Microsoft SQL Server Native Client 10.0: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

Ranjeet_Singh · ‎05-23-2015

I am using UDL file to connect to SQL server. Using UDL file I am able to connect to database but when I am using same file in labview to connect, I am getting above message.

Attached UDL file for better understanding

Suggest how to make it work.

(WIN-7, SQL-2008,LV-2011)

--------------------------------------------------------------------------------------------------------
Kudos are always welcome if you got solution to some extent.

I need my difficulties because they are necessary to enjoy my success.
--Ranjeet

Rob_Calhoun · ‎05-23-2015

Your connection string is telling SQL Server Native Client to use NTLM/integrated security. You need to use SQL Server authentication (i.e. username/password.) See http://www.connectionstrings.com/sql-server/ for examples.

Ranjeet_Singh · ‎05-23-2015

I am using ID password to connect.I am not sure why it was not there in UDL.

--------------------------------------------------------------------------------------------------------
Kudos are always welcome if you got solution to some extent.

I need my difficulties because they are necessary to enjoy my success.
--Ranjeet

LabVIEW

Exception occured in Microsoft SQL Server Native Client 10.0: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

Exception occured in Microsoft SQL Server Native Client 10.0: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

Re: Exception occured in Microsoft SQL Server Native Client 10.0: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

Re: Exception occured in Microsoft SQL Server Native Client 10.0: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.