Moved SUA server and database from local BigFix to new server - having communication problems with the databases

Usage and Config BFI
1

Working installation of SUA on BigFix server. Now trying to install to a new server. SUA installation 9.2.02 (Windows 2008 R2/SQL 2008 R2) and thr database installed with no errors. At the datasource connection parameters to connect to BigFix server database I am receiving the following error…

[9/25/15 18:01:59:962 UTC] 00000021 com.ibm.ws.webcontainer.webapp I SRVE0292I: Servlet Message - [tema]:.[ERROR] SQL: {call [dbo].etl_raw_datasource_analysis_activations}

[9/25/15 18:01:59:963 UTC] 00000021 com.ibm.ws.webcontainer.webapp I SRVE0292I: Servlet Message - [tema]:.[ERROR] Batch execution error:

[9/25/15 18:01:59:991 UTC] 00000021 com.ibm.ws.webcontainer.webapp I SRVE0292I: Servlet Message - [tema]:.[INFO] Completed 500 Internal Server Error in 5039.0ms

[9/25/15 18:02:00:003 UTC] 00000021 com.ibm.ws.webcontainer.webapp I SRVE0292I: Servlet Message - [tema]:.[FATAL]
Java::JavaSql::BatchUpdateException (Cannot insert the value NULL into column ‘id’, table ‘temadb.dbo.raw_datasource_analysis_activations’; column does not allow nulls. INSERT fails.):
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch

Have a PMR open but not making headway.

Any thoughts?

2

I assume your database is remote and you used the same user to run the service who has permissions to read/write to the DB?

3

I have a local db server for BigFix and installed a new SQL server for SUA (local). I am using the same user account on both servers and their services. For kicks I created an ODBC connector and it connected just fine. If you look at the FATAL error its referring to the SUA db.