Forum Discussion

DVincent's avatar
DVincent
Ideator I
7 years ago

To create a new Data Base without administrative rights on the computer

Hello, I would like to add new data bases in my ARAS Innovator 11 SP12, with corresponding  selection at login popup windows, but without using installation wizard that needs administrative rights ...
Database Management
christopher_gillis's avatar
christopher_gillis
New Member
7 years ago

Hi Vincent,

You can check out this blog post for information on how to restore an Innovator database from a backup. In order to add a new database to the dropdown on the login screen, you will need permission to edit the InnovatorServerConfig.xml in the installation directory of your Innovator instance (C:\Program Files (x86)\Aras\Innovator\ by default). You should see a <DB-Connection/> tag near the bottom of this file.

You can add multiple <DB-Connection/> tags to support multiple databases, and you can use the existing one as a template for any new connections you add. The only thing you should need to change if both databases exist on the same SQL Server instance is the name of the database.

Chris

Christopher Gillis

Aras Labs Software Engineer

  • DVincent's avatar
    DVincent
    Ideator I
    7 years ago

    Hi Christopher,

    thank you for the link and explanations, I will try it and leave feedback.

    Vincent.

    • DVincent's avatar
      DVincent
      Ideator I
      7 years ago

      Indeed, after verification, I can execute Innovator installer wizard, but not to modify configuration XML files since they are located on C: system directories...

      Can I move these files elsewhere?

      But, even if it doesn't solve my problem, it is good to have another way to manage databases.

      Thank you,

      Vincent.

      • christopher_gillis's avatar
        christopher_gillis
        New Member
        7 years ago

        Hi Vincent,

        The configuration files at the root of your install directory should not be moved. If you have permissions to run the Aras Innovator installer, one solution would be to install another instance to a different folder where you do have permissions to edit.

        Chris

  • Akhilesh's avatar
    Akhilesh
    Ideator I
    6 years ago

    Hi Christopher,

    Can we add multiple DB's in Self Service Reports Config.xml file and could you please mention the exact syntax which helps to add multiple DB's.

    • christopher_gillis's avatar
      christopher_gillis
      New Member
      6 years ago

      Hello,

      It is possible to add multiple databases to the SelfServiceReportConfig.xml. If you have access to the Aras CD Image, you can find the exact syntax in the Self Service Reporting Administrator's Guide in the Documentation folder.

      If you look at the default config file, you will see that there is a <connectionStrings/> tag with a single <add/> tag like the example below.

          <connectionStrings>
              <add connectionString="Data Source=(local);Initial Catalog=120SP5;Persist Security Info=True;Pooling=False;User ID=innovator_regular;Password=YOUR_INN_REG_PASSWORD;" name="120SP5" />
          </connectionStrings>

      To add a new database, you simply need to add another <add/> tag following the same format as the existing one. If your second database exists in the same SQL Server as the first database, this should be as simple as changing the Inital Catalog and the name like in the example below.

          <connectionStrings>
              <add connectionString="Data Source=(local);Initial Catalog=120SP5;Persist Security Info=True;Pooling=False;User ID=innovator_regular;Password=YOUR_INN_REG_PASSWORD;" name="120SP5" />
              <add connectionString="Data Source=(local);Initial Catalog=120SP5_SecondDB;Persist Security Info=True;Pooling=False;User ID=innovator_regular;Password=YOUR_INN_REG_PASSWORD;" name="120SP5_SecondDB" />
          </connectionStrings>

      Chris