DB Connection

This section provides the fundamental data enabling the Aras Innovator server to connect to the Aras Innovator database. Use this section to manually create custom connections to existing databases.

Table 6: Definitions of DB variables

The following is an example of a properly formatted DB Connection section of the InnovatorServerConfig.xml.

Microsoft SQL Server database

<DB-Connection

id="Innovator”

database="InnovatorSolutions”

server="localhost”

regular_uid="innovator_regular” regular_pwd="innovator_regular”
dbo_uid="innovator”
dbo_pwd="innovator” />

Edit the InnovatorServerConfig.xml file located in root of the install directory.

C:\Program Files\Aras\Innovator

1. Id = Innovator -> Name you wish to appear in the drop-down list when accessing Innovator. If the id attribute is not present in the entry, then database name is used to identify the database when using Innovator. Select this name carefully, as it is also the name of the folder you vault files are stored in.
2. database = InnovatorSolutions -> name of the database you are connecting to.
3. server = Localhost -> the name of the SQL Server instance where the database is installed.
4. regular_uid = innovator_regular -> the login to connect to the innovator_regular database user.
5. regular_pwd = innovator_regular -> the password to connect to the innovator_regular database user.
6. dbo_uid = innovator -> the login to connect to the innovator database user.
7. dbo_pwd = innovator -> the password to connect to the innovator database user.