Microsoft SQL Server

CAUTION:Do not use the sa user ID to run Databridge Client. The sa user ID typically owns tables that Databridge Client should not have access to.

If you are the Microsoft SQL Server database administrator (DBA) or if you have a user ID with DBA privileges, set up a user ID for Databridge Client that has the following:

(Required) The ability to select from any table, including system tables. Databridge reads the data dictionary to determine if a table or procedure exists.
(Required) The ability to create tables, stored procedures, and indexes for tables that the user ID owns.
(Optional) Unlimited space usage. This is recommended because of the large amounts of data that can be replicated from a DMSII database.

To include rights to modify the database as needed, use the Databridge owner (db_owner) to set up the user ID. After you set up the user ID, you must configure the user ID, password, server, and database. For instructions, see Signon Configuration.