Skip to end of metadata
Go to start of metadata

OVERVIEW

An issue belongs to this topic, if it is related with initial configuration or configuration changing of Managed Systems Configuration.
E.g.: Remote System connection cannot be created

The following pictures shows the main components involved by using the SOLMAN_SETUP transaction during managed system configuration:

 

TABLE OF CONTENTS

KNOWN ISSUES:

1. Error during initiating a remote system connection

Symptom:

There is problem during creating a new database connection to a remote system. 

List of related issues:
1.1. Connection error

Symptom:

A similar error occurs during setup the managed system connection: 

"DBA cockpit connection XXX cannot be established" 

Solution:

Check the following SAP Note:   

1904412 - DBA cockpit connection XXX cannot be established

1.2. SQL error 15063

Symptom:

The following error message appears: 

"SQL error 15063 : The login already has an account under a different user name" 

Solution:

Check the following SAP Note: 

2190129 - SQL error 15063 during SolMan configuration 

1.3. There is problem with Windows Authentication

Symptom:

The Windows Authentication does not work during setup the remote system connection parameters. 

Solution:

Check the following SAP Note: 

1923571 - Windows Authentication as monitor login in Managed Systems Configuration Wizard 

In some cases the Windows Authentication is also not allowed.  The related part from the SAP Note 

1458291 - SolMan 7.1 Database Warehouse and Alerting for MSSQL  is the following: 

"...  There are some known cases where you absolutely cannot use Windows Authentication for the monitor account. These are:  i.If you plan to setup monitoring for multiple databases in one single SQL Server instance, you cannot use Windows authentication for the monitor login.  ii.If you are setting up monitoring for the local Solution Manager SQL Server database system, you cannot use Windows authentication for the monitor login.  iii.If the Solution Manager systems runs on Linux and you use the directions in SAP Note 1644499 to configure a connection, you must use a SQL Server account for the monitor login.  ..." 

Common suggestions:
Check for possible known bug

Description:

Check for possible bug as it is described in the COMMON SOLUTION part.

 

2. Error during recreating a remote system connection

Symptom:

You would like to recreate an earlier existed remote system connection (e.g. after a system copy), but it is not possible,  because of error or other reason. 

List of related issues:
2.1. Login name and schema cannot be changed

Symptom:

You are configuring the Database Performance Warehouse in the Managed System Configuration wizard of a Solution Manager 7.1.  In the Enter System Parameters screen, the fields Monitor login name and Object source schema do not allow any changes to be made (the text fields display a blue background). 

Solution:

SAP Note: 

1744830 - How to reset DBACockpit settings in order to rerun the Solution Manager Wizard 

Common suggestions:
If the SAP Note 1744830 does not help

Description:

Check whether a system reboot can solve the issue. 

Check for possible known bug

Description:

Check for possible bug as it is described in the COMMON SOLUTION part.

 

COMMON SOLUTIONS:

1. Check for bug in SAP_BASIS

Description:

There were several bug fixed in the related component SAP_BASIS regarding this topic. Check that you are on the latest SP of the SAP_BASIS in order to avoid any already known bug. If the SP update currently not possible, search for related SAP Note or KBA as it is mentioned in the section NOTE/KBA SEARCH. If you find a relevant SAP Note or KBA, check that your SP level of the SAP_BASIS component is equal or higher than the SP level of the bugfix.

Implication:

If issue found as a bug, apply the SAP Note or apply the SP of the SAP_BASIS, which contains the bugfix. 

 

NOTE/KBA SEARCH:

In case that the above solutions are not relevant, the following search keys are suggested for note and KBA search:

Component area: BC-DB-MSS*

Search keys:
- SOLMAN_SETUP
- "Managed Systems Configuration Wizard"

 

 

RELATED SAP NOTES/KBAs


SAP Note 1458291 - SolMan 7.1 Database Warehouse & Alerting for MSSQL

Feedback

Please provide any feedback or questions regarding the content under the current page comments. If you have an issue or is looking for help, try to post your question on SAP community with Microsoft SQL Server tag.

In order to leave comments, you must be logged on with your SAP account.

  • No labels