ERROR: environment variable dbms_type is not set (but it is)

[Former Member]

After performing client copies from our production SAP system to our QA SAP system I now get this error when I run an STMS test in the QA system:

This is tp version 372.04.57 (release 701)

ERROR: No connect due to DbSl Load Lib Failure

ERROR: environment variable dbms_type is not set.

ERROR: Connect to ABC failed (20100104110445).

INFO: no trace information stored

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0249

standard output from tp and from tools called by tp:

https://service.sap.com/sap/support/notes/128126 explains the problem and says that these environment variables are needed (for user SIDADM) on the Windows server u2013 and they are:

Important environment variables for SQL Server:

u2022 dbms_type

Must be always set to "mss" for SQL Server.

u2022 MSSQL_SERVER

Name of the SQL Server instance. E.g. "SQLSERVER" (default instance on server "SQLSERVER") or "SAPSQL\PRD" (named instance "PRD" on server "SAPSQL")

u2022 MSSQL_DBNAME

Name of the database, usually <SID> in uppercase letters.

u2022 MSSQL_SCHEMA

Name of the database schema, usually "dbo" in lowercase letters. With an MCOD system, the database schema is <sid> in lowercase letters.

Nothing has changed on the Windows servers, only the SAP systems (client copies from another SAP system). So I donu2019t know what is causing this.

What could be causing this?

Thanks.

[Former Member]

I have resolved this.

I had to point the STMS configuration to a different QA server (in the same cluster).

I did this in client 000 of the Dev system.