Symptom
saphostctrl is unable to connect to SQL Server database instance:
- "saphostctrl -function GetDatabaseStatus -dbname <SID> -dbtype mss" fails with "Error: Database not found".
- "saphostctrl.exe -function GetDatabaseProperties -dbname <SID> -dbtype MSS" fails with "Error: The MS SQL Server instance <hostname> does not exist."
- When running the "saphostctrl -function ListDatabases" command, multiple instances are returned on the same host:
Instance name: <SID1>, Hostname: <hostname>, Vendor: MSS, Type: mss, Release: xx
Database name: <SID1>, Status: Running
...
Instance name: <SID2>, Hostname: <hostname>, Vendor: MSS, Type: mss, Release: xx
Database name: <SID2>, Status: Running
...
Read more...
Product
SAP NetWeaver all versions
Keywords
KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-CCM-HAG , Host Agent , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.