Actually I fixed part of this.  I had to use the old desktop application central point configurator application to do the initial configuration.  Now, the error when I try to log in says. 

Invalid column name 'DOMAIN_ID'.

Invalid column name 'DOMAIN_ID'.

Same issue here. Please help.

Hi,

Seems like missing column, a lot of columns in fact.

I have no idea why.

Running:

```

ALTER TABLE dbo.SEC_USERS ADD [DOMAIN_ID] [nvarchar](64) NULL;

```

Solved my issue.

I have no idea what's the proper way so if anyone can chime in from technical perspective it would be appreciated.

Compared with fresh install of new SEI with ancient copy of SEI 8.

new SEI:

Ancient copy:

---

New SEI Table code for dbo.SEC_USERS

```

USE [SEI]
GO

/****** Object: Table [dbo].[SEC_USERS] Script Date: 11/8/2023 4:13:34 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SEC_USERS](
[ID] [nvarchar](45) NOT NULL,
[USERNAME] [nvarchar](256) NOT NULL,
[DOMAIN] [nvarchar](256) NULL,
[PASSWORD] [nvarchar](128) NULL,
[NAME] [nvarchar](256) NULL,
[EMAIL] [nvarchar](256) NULL,
[DESCRIPTION_INTERNAL] [nvarchar](2000) NULL,
[TITLE_INTERNAL] [nvarchar](128) NULL,
[LANGUAGE] [nvarchar](20) NOT NULL,
[CULTURE] [nvarchar](20) NOT NULL,
[IS_APPROVED] [bit] NOT NULL,
[IS_LOCKED_OUT] [bit] NOT NULL,
[CREATED_DATE] [datetime] NOT NULL,
[LAST_LOGIN_DATE] [datetime] NULL,
[LAST_ACTIVITY_DATE] [datetime] NULL,
[LAST_PASSWORD_CHANGE_DATE] [datetime] NULL,
[LAST_LOCK_OUT_DATE] [datetime] NULL,
[FAILED_PASSWORD_ATTEMPT_COUNT] [int] NOT NULL,
[FAILED_PASSWORD_ATTEMPT_START] [datetime] NULL,
[GENERAL_ROLE_ID] [nvarchar](45) NULL,
[PROCESS_ROLE_ID] [nvarchar](45) NULL,
[DISPLAY_LEVEL] [tinyint] NOT NULL,
[EDIT_LEVEL] [tinyint] NOT NULL,
[IS_ACTIVE_DIRECTORY] [bit] NOT NULL,
[IS_VIEWER_ONLY] [bit] NULL,
[LAST_UPDATE] [datetime] NULL,
[UPDATED_BY] [nvarchar](50) NULL,
[DOMAIN_ID] [nvarchar](64) NULL,
[ADMIN_USER_TYPE] [nvarchar](20) NOT NULL,
[SECURITY_STAMP] [nvarchar](45) NULL,
[EXPIRED] [bit] NOT NULL,
CONSTRAINT [PK_SEC_USERS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY],
CONSTRAINT [UQ__SEC_USERS__30641768] UNIQUE NONCLUSTERED
(
[USERNAME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[SEC_USERS] ADD CONSTRAINT [DF_SEC_USERS_CULTURE] DEFAULT (N'en-US') FOR [CULTURE]
GO

ALTER TABLE [dbo].[SEC_USERS] ADD CONSTRAINT [DF_SEC_USERS_DISPLAY_LEVEL] DEFAULT ((0)) FOR [DISPLAY_LEVEL]
GO

ALTER TABLE [dbo].[SEC_USERS] ADD CONSTRAINT [DF_SEC_USERS_EDIT_LEVEL] DEFAULT ((0)) FOR [EDIT_LEVEL]
GO

ALTER TABLE [dbo].[SEC_USERS] ADD CONSTRAINT [DF_ADMIN_USER_TYPE] DEFAULT (N'Normal_User') FOR [ADMIN_USER_TYPE]
GO

ALTER TABLE [dbo].[SEC_USERS] ADD CONSTRAINT [DF_SEC_USERS_EXPIRED] DEFAULT ((0)) FOR [EXPIRED]
GO

```

Ancient SEI Table code for dbo.SEC_USERS

```

USE [SEI]
GO

/****** Object: Table [dbo].[SEC_USERS] Script Date: 8/11/2023 4:17:57 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SEC_USERS](
[ID] [nvarchar](45) NOT NULL,
[USERNAME] [nvarchar](256) NOT NULL,
[DOMAIN] [nvarchar](256) NULL,
[PASSWORD] [nvarchar](128) NULL,
[PASSWORD_SALT] [nvarchar](128) NULL,
[NAME] [nvarchar](256) NULL,
[EMAIL] [nvarchar](256) NULL,
[DESCRIPTION_INTERNAL] [nvarchar](2000) NULL,
[TITLE_INTERNAL] [nvarchar](128) NULL,
[LANGUAGE] [nvarchar](20) NOT NULL,
[CULTURE] [nvarchar](20) NOT NULL,
[IS_APPROVED] [bit] NOT NULL,
[IS_LOCKED_OUT] [bit] NOT NULL,
[CREATED_DATE] [datetime] NOT NULL,
[LAST_LOGIN_DATE] [datetime] NULL,
[LAST_ACTIVITY_DATE] [datetime] NULL,
[LAST_PASSWORD_CHANGE_DATE] [datetime] NULL,
[LAST_LOCK_OUT_DATE] [datetime] NULL,
[FAILED_PASSWORD_ATTEMPT_COUNT] [int] NOT NULL,
[FAILED_PASSWORD_ATTEMPT_START] [datetime] NULL,
[GENERAL_ROLE_ID] [nvarchar](45) NULL,
[PROCESS_ROLE_ID] [nvarchar](45) NULL,
[DISPLAY_LEVEL] [tinyint] NOT NULL,
[EDIT_LEVEL] [tinyint] NOT NULL,
[IS_ACTIVE_DIRECTORY] [bit] NOT NULL,
[IS_VIEWER_ONLY] [bit] NULL,
CONSTRAINT [PK_SEC_USERS] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY],
CONSTRAINT [UQ__SEC_USERS__30641767] UNIQUE NONCLUSTERED
(
[USERNAME] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[SEC_USERS] ADD CONSTRAINT [DF_SEC_USERS_CULTURE] DEFAULT (N'en-US') FOR [CULTURE]
GO

ALTER TABLE [dbo].[SEC_USERS] ADD CONSTRAINT [DF_SEC_USERS_DISPLAY_LEVEL] DEFAULT ((0)) FOR [DISPLAY_LEVEL]
GO

ALTER TABLE [dbo].[SEC_USERS] ADD CONSTRAINT [DF_SEC_USERS_EDIT_LEVEL] DEFAULT ((0)) FOR [EDIT_LEVEL]
GO

```

Talked with Sage support, seems like upgrade process is:

From SQL Server, restore SEI DB from old SEI.

From File Explorer on Central Point folder (which is currently being shared), replace the current Central Point config file's `nec-centralpoint.xml` with the old Central Point config file's `nec-centralpoint.xml`. Wholesale. Then, update details inside to point to current server hostname.

From browser of choice, open Central Point Configurator (localhost:8133) and configure accordingly.

Uninstall and install SEI.

Login to SEI (localhost:81).

Accept SEI update.