SUPPORT Q&A - How to change password of Innovator Vault server

sshsu - Friday, May 22, 2009 10:52 PM:

Hi,

I failed to view any files in Innovator, system prompt wth "Authentication failed for vadmin".

I use "aras" as password for 'sa' account in the "Database config' step when intall Innovator the first time, but after that I retore Demo910 database, which set 'innovator' as the default password.I figure out this may be the problem cause.

Question is, How to change the password for Innovator Vault server, is reconfig database use "Configure only (no validations)" or "Use an existing database" work?

I didn't do this because I am not sure what will go wrong. Just confirm to you before do it.

Best Regards,

SS Hsu

PeterSchroer - Monday, May 25, 2009 8:07 PM:

In the last release of the demo database Demo910,  I had changed the password for user  vadmin  to "innovator".    When the vadmin password changes,  it is important to document this change also in the Configuration file named   VaultServerConfig.xml   which is in the root installation folder for Innovator.

If you edit the VaultServerConfig.xml file,  then  you can use the demo database.    Or you can use SQL to change the password in DEMO910 to match the default password (you can see this with SQL looking at InnovatorSolutions database).

jcarty - Monday, June 1, 2009 7:43 AM:

Hi all;

I had the same issue with the same error message. i'm wondering if i didn't skip a step on the installation.

sshsu - Wednesday, May 27, 2009 2:41 AM:

Hi Peter,

The viewer is work well now. There is one thing to add in this procedure.

Since I keep to use the same database name (InnovatorSolutions) when restore DEMO910 database, I must also change the directory name of Vault,

from "D:ArasVaultDemo910" to "D:ArasVaultInnnovatorSolutions".

Thanks,
SS

sshsu - Tuesday, June 2, 2009 5:41 AM:

Dear Peter,

I restore Demo910-4, everything is fine except view documents, system prompt wth "Authentication failed for vadmin" again.

Since I have same experience in previous demo910, I already change the password in 'VaultServerConfig.xml' to 'innovator', and the directory of vault is 'D:ArasVaultInnnovatorSolutions', because I keep same database name InnovatorSolutions

Here is VaultServerConfig.xml I modified

<?xml version="1.0" encoding="UTF-8"?>
<VaultServer>
    <AppServerURL>localhost/.../AppServerURL>
    <LocalPath>D:ArasVault</LocalPath>
    <login_name>vadmin</login_name>
    <name>Default</name>
    <password>innovator</password>
    <version>9.1</version>
</VaultServer>

Am I miss any other setting?

Best Regards,
SS Hsu

PeterSchroer - Tuesday, June 2, 2009 7:34 AM:

A good test is to try an logon to Aras Innovator using the  Vault's credentials.

For example:  try to logon as    vadmin / vadmin   -- this is the standard default username+password.     If this fails,  then try  vadmin / innovator  which is the password my Demo script was setting.     Whichever username + password combination that works....  then put this value into  VaultServerConfig.xml

sshsu - Wednesday, June 3, 2009 3:16 AM:

Hi Peter,

I try to logon as vadmin / innovator, response with 'Authentication failed to vadmin', then try vadmin / vadmin, response with 'You are disconnected', account vadmin is no way to logon Innovator. In TOCadministrationUsers, 'vadmin' is an user account with vault permission there. I leave the password of account vadmin unchanged.

I also test several user account to logon and test view document function, all get the same failure.(below message)

*******************************************************

- <SOAP-ENV:Envelope xmlns:SOAP-ENV="schemas.xmlsoap.org/.../">
 - <SOAP-ENV:Body>
  - <SOAP-ENV:Fault xmlns:af="www.aras.com/InnovatorFault">
      <faultcode>SOAP-ENV:Server</faultcode>
      <faultstring>Authentication failed for vadmin</faultstring>
      <faultactor>localhost/.../faultactor>
    - <detail>
          <af:legacy_detail>Authentication failed for vadmin</af:legacy_detail>
     </detail>
    </SOAP-ENV:Fault>
   </SOAP-ENV:Body>
  </SOAP-ENV:Envelope>

******************************************************************************************

What is the difference between Demo901 and Demo910-4 build?

I may try to create a new database with name  DEMO910 to try if the document view is work.

Best Regards,
SS Hsu

sshsu - Thursday, June 4, 2009 7:51 AM:

Dear Peter,

I install a new innovator database neme DEMO910, and restore 'Demo910-4-DB.bak' back to DEMO910 according to the 7 steps in 'Aras Innovator Demo910-4 README.txt', then test view document function. It work well now.

Another interesting thing, when I logon to InnovatorSolutions database, the view documents functions become work again !!! What I can tell is due to new DEMO910 database install, the 'VaultSeverConfig.xml' retore password tag to 'vadmin', before was change to 'innovator' by me. 

It raise to another question, why I have to change pasword in   'VaultSeverConfig.xml'  on last build DEMO910, but in no need to DEMO910-4?

Best Regards,
SS Hsu

PeterSchroer - Thursday, June 4, 2009 8:17 AM:

Ah,  good question.   "Why did you need to change the password on the first build of Demo910,  and not on the 2nd build".  The answer is in the SQL script that I distribute with the demo.  Whenever you move a SqlServer backup file from one serve to another,  you have to run a SQL script to set the Sql Server internal Innovator logon account ID's.          In the first build of Demo910,  you can see that the script also resets all the internal passwords for Innovator system users to  "innovator"     this is just a convenience when we are sharing development and demo databases.    but I should not have been changing the VADMIN password.        Look in the SQL script  (FixDB.SQL) with the Demo910-4 build,  I am now skipping the VADMIN user account when I reset passwords.        This is a much better approach !