Gather Database Information

If you are configuring a connection to a database, gather the following information:

Host name—Identify the name of the database host system.
Port—Identify the port on which the database is listening.
(Microsoft SQL Server) Database name—Identify the name of database.
(Oracle) Service name—Identify the service name of the database.
Database user credentials—Identify the credentials of a user account that has read/write permissions to the database.
Important! If you are configuring a connection to Oracle, be sure to set the default schema for this user. The default schema must be the schema that is associated with the table that contains the administrative users. If you do not set the default schema for this user, the Administrative Authentication wizard cannot locate users in the database.