Trusted Connection in .Net data provider Driver
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


Trusted Connection in .Net data provider... Expand / Collapse
Author
Message
Posted 9/8/2009 2:17:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 10/5/2009 3:27:02 AM
Posts: 2, Visits: 11
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.

Thanks
Post #16782
Posted 9/10/2009 2:03:40 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 11/16/2009 3:03:20 PM
Posts: 152, Visits: 454
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.






--Cal
Post #16800
Posted 9/17/2009 1:51:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 10/5/2009 3:27:02 AM
Posts: 2, Visits: 11
Thanks Cal
Post #16858
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 10:29pm

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.125. 10 queries. Compression Disabled.