Openfire database Microsoft

Hi,
I am using Openfire 4.1.4 and using MSSQL database. Connections worked fine and install worked fine.
I was using the embedded database before on a previous install and I could view all the MUC chat in ofMucConversationLog but now there are no entries for any group chat in the MS database. I am using SQL Server Autehntication

Can anybody help with this or describe what is happening.

Also I am curious where does spark save the private messages when not using group chat?

thanks

Spark saves transcripts locally at C:\Users\user\AppData\Roaming\Spark\user\user@domain\transcripts