We tried to migrate the LanCrypt database and administration server from Windows Server 2003 to Windows 2008R2. The original SQL database is stored in MSSQL 2008R2 Express and all LanCrypt tables were created under the 'master' database. We copy all the LanCrypt tables from the 'master' database to a new database called 'sglc'.
Then we backup the 'sglc' database and then restore it into the new Windows 2008R2. We use the 'createtables.exe' to update the database structures and it show successed. We finally start the Administration console and it start the database integrity check but there's error "Cannot insert the value NULL into column 'CM_TREPID', table 'SGLC.dbo.LCGROUPPROFILESMACS', column does not allow nulls. INSERT failed'. comes out. After click the OK button, the program said the database integrity were found and corrected. Afterward We got error message like "Cannot insert the value NULL into column 'CF_ID', table 'SGLC.dob.APPCONFIG'; column does not allow nulls. INSERT failes" in the admin console when we tried to open one of the "Encryption rules". And we also got "Fatal database error (incorrect MAC). The database connection will be closed.
Any one know what's the problem?
This thread was automatically locked due to age.