Hi, I a trying to connect to Teradata using Teradata.Client.Provider driver. When I provide user name and password it connects without any problem, but I want to connect to the database using my OS account. I have my access to the Data base from OS account. I specify Integrated security = YES if I wish to connect to oracle using my OS account. I want to know if I can do same here.
Re: Trusted Connection in .Net data provider Driver
a) The Teradata database version you use with .NET Data Provider for Teradata 12.0 and higher must support Kerberos Authentication and furthermore SPNEGO must be enabled. SPNEGO is not enabled by default. See Teradata Security Administration manual for steps to enable SPNEGO.
b) Set TdConnectionStringBuilder.IntegratedSecurity to true or set the connection string to "Data Source=X; Integrated Security=true;"
Note you are looking for Integrated Security or what is known as Single-Sign-On in Teradata manuals. Trusted Connection is a separate feature in Teradata Database 13.0.