Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 08 Dec 2014 @ 21:32:10 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Upg to SQLa and with teradata.net - cant change passwd when prompted
From:   Anomy Anom

<-- Anonymously Posted: Monday, December 08, 2014 11:18 -->

Hi all,

We have recently upgraded from V2R13 to V2R14.10.03.10 and to SQLa, Teradata.net

The security settings on our system require the user to reset their passwd every 30 days. Users are logging on using Teradata.net and not ODBC.

Following the upgrade - the first user to attempt to reset their passwd following a system prompt that outlined that their password had expired and needed resetting - encountered the following error and was unable to reset their password;-

     Invalid connection string.
     Unexpected Error.  Refer to the following file for details:
     C:\Users\28134\AppData\Roaming\Teradata\SQL Assistant\SQLAError.Txt

The SQLAError.Txt was as follows;-

     SQLA Version:
     System.InvalidOperationException: Invalid connection string.
        at Teradata.Client.Provider.TdConnection.Open()
        at Teradata.SQLA.TdConnectInfo.GetSession() in V:\cm.client.ttu141.efix\tdcli\qman\sqla\TdConnectInfo.vb:line 162

Upon investigation - users can issue the SQL 'Modify user as password =' statement and change their password with no issue and can use the option -> tools -> change password in SQLa and again change their password with -> no issue.

However if the system prompts with the message box to enter your password and re-enter the new one - then the above message results.

If the user then changes to attempt to logon using ODBC connection - the prompt to change password presents and the user can change their password with no issue.

Has anyone encountered this issue of not being able to change their password whilst logging on via Teradata.net when the password change has been prompted by the database but they are able to change the password via ODBC net when the password change has been prompted by the database


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020