During the install of Inventory manager it say Installation returned error code: 1603
Any suggestions on how to resolve this?
Here is the message from Event Viewer
Product: Idera SQL Inventory Manager — Error 26204. Error -2147217900: failed to execute SQL string, error detail: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name., SQL key: CreateDbUser.SqlAuthentication SQL string: USE [SQLInventoryManagerRepository];
IF NOT EXISTS (SELECT dbusers.principal_id FROM sys.database_principals dbusers
JOIN sys.server_principals slogins ON dbusers.sid = slogins.sid
WHERE slogins.type = 'U' and UPPER(slogins.name) = UPPER('domainusername'))
BEGIN
DECLARE @login NVARCHAR(128)
SELECT @login=name FROM sys.server_principals WHERE type = 'U' and UPPER(name) = UPPER('domainusername')
EXEC ('CREATE USER [' + @login + '] FROM LOGIN [' + @login + '] WITH DEFAULT_SCHEMA=[dbo]');
EXEC ('EXEC sp_addrolemember N''db_owner'', [' + @login + ']');
END