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

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