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

 

 

Keywords

Installation SQL Database usergroup