SQL Tip - User, group, or role 'XYZ' already exists in the current database when restoring Infiniti database (SQL Server).

Applies to Infiniti v8.0 or later
This often occurs when moving, backing up or restoring existing Infiniti databases, it can be set/repaired with the following or a similar SQL statement.
alter user intelledox with login = intelledox, default_schema = dbo

Related Articles




Installation SQL Database usergroup