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"
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.