SAP TR failure with "Link to database failed"

[former_member208255]

Hi All,

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.

Error screenshot:



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

-> C:\usr\sap\SID\SYS\profile\DEFAULT.PFL

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.

DBMS_TYPE=mss
MSSQL_DBNAME=ERM
MSSQL_SCHEMA=erm
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

Bhaskar N