Knowledge Base >> Recreate Ignite Monitor User for SQL Server

Recreate Ignite Monitor User for SQL Server - Confio Article 1567

Confio Article: 1567 Published: Oct 12 2009 7:56 AM
Version: >= 4.3 Topic(s): Install and Setup Ignite Management
Product(s): Ignite
Database(s): MS SQL

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