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('domain\username')) BEGIN DECLARE @login NVARCHAR(128) SELECT @login=name FROM sys.server_principals WHERE type = 'U' and UPPER(name) = UPPER('domain\username') EXEC ('CREATE USER [' + @login + '] FROM LOGIN [' + @login + '] WITH DEFAULT_SCHEMA=[dbo]'); EXEC ('EXEC sp_addrolemember N''db_owner'', [' + @login + ']'); END
There may be a few scenarios where you may run into this error: if app is already installed or previously installed, folder or path is encrypted, account used does not have permissions. Check out the installation section - http://wiki.idera.com/display/SQLInventoryManager/Installing+SQL+Inventory+Manager
Curious, what version of SQL Server are you using to install SQL Inventory Manager?
SQL 2016