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 on the computer.

There is a way to do that?

Thank you,

Vincent.

Parents
  • 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

  • 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.

  • 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

Reply
  • 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

Children
No Data