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