Ask the Community
Groups
Database views (KaseyaViews) password fails due to "Windows complexity rules" - Connect IT Community | Kaseya
<main> <article class="userContent"> <h1 data-id="problem">Problem:</h1> <p>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.</p> <p> </p> <p><img src="https://us.v-cdn.net/6032361/uploads/migrated/W1QKRC2CJXWD/3-13-2018-7-20-17-am.png" alt="3-13-2018_7-20-17_AM.png" class="embedImage-img importedEmbed-img"></img></p> <p> </p> <h1 data-id="solution">Solution:</h1> <p> </p> <p>This is a bug.</p> <p>Click the "clear" button, then create a new password.</p> <p>Also:<br>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.</p> <p>You can follow theses steps to have this user create in SQL directly:</p> <p><img src="/attachments/token/qmlId6DgQ9uJVLXQKrbULmWW2/?name=agent1.png" alt="agent1.png" class="embedImage-img importedEmbed-img"></img></p> <p><img src="/attachments/token/NU24OXWOP9UgjbVl80vrX2Vir/?name=agent2.png" alt="agent2.png" class="embedImage-img importedEmbed-img"></img></p> <p> </p> <p><img src="/attachments/token/krHSC5V1KN5obF4VjnF1Jmg6s/?name=9-17-2015+8-48-00+AM.png" alt="9-17-2015_8-48-00_AM.png" class="embedImage-img importedEmbed-img"></img></p> <p> </p> <p> </p> <p>After creating the user, you will be able to access the database views from Microsoft Excel, for example.</p> </article> </main>