Password for database user account for SQL Server

User_7ZIMJ

It appears the password for a database account to deploy Oracle Analytics Server in a SQL Server environment is limited to 16 characters. Can this be extended? Internally, we have a password standard of 30 characters or less. Thanks.

Gianni Ceresa

we have a password standard of 30 characters or less

If that's really the standard, 16 being less than 30, it does still match with your standard.

I didn't go reading details of where that limits come from, but you could try to test if it's just the RCU having that limit.

Create the schemas with a short (<=16 characters), and when OAS is fully installed you can proceed with an update of the passwords for the schemas created by the RCU. If the 16 characters limit was only a thing forced by the RCU itself, you will then be able to use longer password.

Can't exclude that something else also has that 16 chars limit, and it's the case, you will kill your environment in the process, therefore take backups or test it with a sandbox first.