I am trying to get access to Database Views to extract SQLdata for reporting. I can't reset the password due to complexity rules not being met. I've tried multiple variations of passwords including and excluding special characters. See attached error.
This is a bug.
Click the "clear" button, then create a new password.
Either way, the Database Access routine will just create a new user in SQL and give this user the rights to see the Database Views.
You can follow theses steps to have this user create in SQL directly:
After creating the user, you will be able to access the database views from Microsoft Excel, for example.