Creating a DBCON Entry

The database multi-connect information is stored in the SAP table DBCON. You can create a DBCON entry as follows:

...

       1.      In the screen Maintain and set monitor multi-connect data, from the menu choose Goto ® Maintain DBCON.

       2.      Choose New DBCON entry.

The dialog box New DBCON entry appears.

       3.      Make entries in the following fields:

Ў        Connection name:

Enter any name. This is the name by which your remote database connection is identified.

Ў        Database system: MSS

This field must display MSS.

Ў        DB server (instance):

Enter the name of the target SQL Server that you want to administer from your local SAP system.

Ў        Database login:

SQL Server login with System Administrator privileges, that is this login should be member of the sysadmin fixed server role on the target SQL Server. If such a login does not exist, you have to create it on the target SQL Server. The SAP multi-connect mechanism allows both integrated security logins and the use of SQL Server authentication. For security reasons, we highly recommend to use integrated security (Windows authentication). If you use Windows security, leave this field empty.

Ў        Password / Re-enter password :

If you have decided to use integrated security, leave these fields empty. Otherwise enter the password of the SQL Server login.

Ў        Database name:

Enter the name of the target database.

Ў        Database user:

For remote database monitoring, leave this field empty. This will ensure that the database connection has dbo privilege.

Ў        Object source schema:

This database schema contains all SAP database monitor objects, for example, stored procedures, user defined functions and tables. They implement the low-level database monitor functions.

Make one of the following entries:

§         If the target server is an SAP ABAP application of the same release than the source application server, and the SAP database objects (tables, views, stored procedure etc.) do not belong to the schema dbo, enter the <sapsid> of the target SAP system.

§         If the target server is an SAP ABAP application of the same release than the source application server, and the SAP database objects (tables, views, stored procedure etc) belong to the schema dbo, leave this field empty.

§         In all other cases, enter any name for the schema. For more information on how to create the schema in the target database and to fill it with the necessary monitoring objects, see Creating an Object Source Schema and the SAP TSQL Objects.

Ў        Keep connection open:

Leave this field empty. 

Ў        Other parameters:

Leave this field empty.

       4.      Choose SAVE.