Return
-
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.