Unicode Migration - Password Problem

[Former Member]

Hello, friends.

I've migrated an 7.6.06.03 instance to UNICODE, using db_migratecatalog.

My original DBA password had 10 characters. After migration, I couldn't log into the new UNICODE version, neither through ODBC (unicode or not) nor with SQL Studio. But with dbmcli I was able to do a sql_connect with the old password and then change the DBA password to 9 chars. It's the new max password length, and I can't define a password greater than 9 chars.

The problem is that our applications are configured with the 10 chars password, and it can't logon anymore.

Is there a solution to this, or will I have to reconfigure my applications? (would be a pain... )

Thanks!

[former_member229109 · Accepted solution]

Hello Victor,

yes there is a password length limitation:

Passwords may not have more than 9 characters.

For more information please have a look at documentation at following link:

http://maxdb.sap.com/doc/7_6/default.htm

-> Basic Information -> Concepts of the Database System

-> Administration -> Users, Authentication and Authorizations

-> Conventions for User Names and Passwords

or http://maxdb.sap.com/doc/7_7/default.htm

-> Database Administration -> Managing Users

-> Conventions for User Names and Passwords

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

This document:

Says:

"User passwords may have no more than 18 characters in ASCII databases and no more than 9 in Unicode databases. After the migration, all users can still use their existing passwords to log on, but only the first 9 characters are evaluated."

This statement made me imagine that longer passwords would be truncated and evaluated up to de 9th character, and so the old password would still work.

But it's ok... we'll migrate everything in the applications

Natalia,

Thanks very much for all your attention!