For several reasons, e.g. database refreshes, the SQL Server login that Ignite utilizes for monitoring can be deleted. The following script can be used to re-create that user with proper rights and privileges. To run this script connect as a SYSADMIN user to the monitored database, replace the <username> and <password> with the proper credentials for the Ignite user:
Create Ignite Login
CREATE LOGIN [<username>] WITH
PASSWORD=N'<password>',
DEFAULT_DATABASE=[master],
DEFAULT_LANGUAGE=[us_english],
CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
Give SYSADMIN rights to the Ignite User
EXEC sys.sp_addsrvrolemember @loginame = N'<username>', @rolename = N'sysadmin'
GO
Create ignite_temp Table
USE [master]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [<username>].[ignite_temp](
[index_val] [tinyint] NULL,
[name] [varchar](50) NULL,
[internal_value] [int] NULL,
[char_value] [varchar](255) NULL
) ON [PRIMARY]
GO