[810143] Database error 4060: Cannot open database "TEMPDB" requested by the login. The login failed. (189378)

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

[810143] Database error 4060: Cannot open database "TEMPDB" requested by the login. The login failed.
Description

When trying to create a new D1IM database using the Configuration Wizard, the following error may be shown:
[810143] Database error 4060: Cannot open database "TEMPDB" requested by the login. The login failed.
Login failed for user '<USERNAME>'.
at ... <STACK TRACE>

Cannot open database "TEMPDB" requested by the login. The login failed.
Login failed for user 'tec-de-ffm-D1IDMP'.
at <STACK TRACE>
Cause

The cause may be that the database is in the incorrect collation, for example, "Latin1_General_100_CS_AS_SC" which is case sensitive collation and requires the "TEMPDB" to match exactly to the case, for example "TempDB".
Resolution

Change the collation of the database to the supported and recommended collation of "SQL_Latin1_General_CP1_CI_AS".
The collation "SQL_Latin1_General_CP1_CI_AS" is expected on One Identity Manager schema installation and applied to the database as required.