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.
Leave a Comment
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- Contact Us
- Technical Support
- View All
- Product(s):
-
Identity Manager
7.0.1, 7.0
- Topic(s):
- Troubleshooting
- Article History:
- Created on: 3/9/2016
Last Update on: 3/9/2016
- Author:
- Dax Turner
- Search All Articles
-