I am currently working on moving the BESMgmt database to a full version SQL Server. I successfully migrated and had the BES Management application working on our test SQL Server, but when I do the same procedures to the live SQL Server I get this error. Any ideas on why. I can change parameters back to test and it works. I have tried w/ a restore from the test DB as well as directly from the original BES Server.


[20000] (04/09 14:19:51.360):{0x1744} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 23000 Native error: 547 Message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_RelationSCMDS_ServerConfig". The conflict occurred in database "BESMgmt", table "dbo.ServerConfig", column 'Id'.

I would maybe try to get a new backup of the database, and then restore it. The error you posted looks like you are trying to do a hack to the database schema