SAP TR failure with “Link to database failed”
We had an issue with transport issue in our environment, from the logs we noticed that system is trying to connect from other DB system. On further investigation we found that MSSQL_SERVER parameter is pointing to other system in environmental variables.
Please follow the below steps to fix the issue:
How to check the error:
Goto –> STMS –> systems–> Click once to select the system you need to check and navigate to menu SAP System -> Check -> Transport Tool.
Link to database failed.
Checking the variables:
In SAP system we all know how to check the paramerts, below is the path to check them
dbms/type = mss
dbs/mss/dbname = ERM
dbs/mss/schema = erm
dbs/mss/server = VM-MSS
- To check the Environment variables of user <sid>adm in windows server, please see the below screenshot.
MSSQL_SERVER=VM-MSS-OLD (Highlighted parameter in below screenshot) it is referring to other system.
Changed to correct DB host name and able to import the transport😊.
The system and services must be restarted after changing the variables.
Thanks & regards