16. Create the database links
You will now be asked to create the database links. A database link is required to allow tables and views from one database be used by another.
Database links can be configured automatically, Where the configuration application is provided with administrator details for each database server and it runs the necessary procedure, or manually, where you create the links manually on each database server and the configuration application confirms if they are setup correctly.
Please click on the relevant section below to expand its instructions:
SQL Server 2008 R2
To automatically link the database servers:
- Select Automatically from the Would you like to setup your database links: option.
You will be shown an entry for each database server used in your installation. So you could have one entry, similar to below, or you could have several entries.
For each entry the Databases on the Server section will identify which database(s) can be found on the server identified in the Database Server Name.
- When creating the links to the server, you will need to login as an administrator. Select how you connect to the database server using the I connect using drop-down list. If you login using:
Windows authentication - You will need to enter the windows username and password associated with the system administrator for the database server. If you are using a domain server, remember that you should use the fully-qualified domain name: <domain>\<username>. For example: myorganization\dbsysadmin
SQL Server authentication - You will need to enter the database system administrator and password. For example, on SQL Server 2008 R2 you will typically use the sa user.
- Repeat the above steps for each database entry and click Create
Now you can continue on to step 17 using the link below to finish installing Perception.
For instructions about setting up you database links manually, please refer to the following before completing the steps below:
ADV13. Manually link the databases
To manually link the database servers:
- Select Manual from the Would you like to setup your database links: option
- Click Verify to check the linking is successful
Now you can continue on to step 17 using the link below to finish installing Perception.