Teradata on Windows - Single Sign On - Help

Connectivity

Teradata on Windows - Single Sign On - Help

Hello,

I've installed teradata Express 13 on a Windows XP SP3 machine to try the Single Sign On feature from ODBC and JDBC applications. I tried first ODBC and I'm not able to make any progress. The External Authentication at the database is ON ( Gateway Control Options), the ODBC data source ( on Windows 7) is set with Integrated Security, and there is a user name at the database that matches my Windows user name. However, every attempt to connect ends up with an error message from the driver:

dbc:  szSqlState = "HY000", *pfNativeError = 0, *pcbErrorMsg = 126, *ColumnNumber = -1, *RowNumber = -1

          MessageText = "[Teradata][ODBC Teradata Driver] Major Status=0xd0000 Minor Status=0x80090303-The specified target is unknown or unreachable

Does anyone have an experience with this feature ? Any help is appreciated.

Cheers,

Val

Tags (1)
2 REPLIES

Re: Teradata on Windows - Single Sign On - Help

I've got this working by adding the teradata SPN to the Active Directory. The SPN format is described in the Security Administration gude, Configuring Active Directory; I didn't expect I have to do anything, because my Teradata runs on Windows, not Linux.

Re: Teradata on Windows - Single Sign On - Help

better to contact the moderator for this query you wowwuld get the best advice of it