Error during Password Manager logging database creation: " SQL error (0xD0). Invalid object name 'dbo.EMailNotifications' "
This issue may be caused by a capital 'M' in the query 'dbo.EMailNotifications', since the database table was probably created as 'dbo.EmailNotifications' if the database collation is case sensitive, it cannot be referred to using any other format.
This issue is related to the database collation that SQL Server is using by default. This would have to be changed in SQL Server as a global change. For example, the default SQL collation most often used is: "SQL_Latin1_General_CP1_CI_AS". Notice the part that indicates Case Insensitive (_CI_). That is, SQL Server may be in a Case Sensitive collation.
Because the scripts used to create and access the database for Password Manager are hard-coded in the back-end, the only way to resolve this is to change the collation on SQL Server to a Case Insensitive collation before creating the database via Password Manager.
To check if this is the problem, right-click on the SQL Server instance name in SQL Server Management Studio and choose "Properties", then check the "Server Collation".
© 2021 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy