I’ve installed AD360 and changed DB server for MS SQL, I’ve followed your guide ( https://www.manageengine.com/active-directory-360/help/getting-started/migrating-pgsql-to-mssql.html), so far so good BUT now I can´t make backups.

The application is working but I cannot make backups. Can anyone help on this?

The error log (backuplog) is: 

[09:54:43:440]|[08-28-2015]|[com.adventnet.mfw.BackupDB]|[INFO]|[10]: BackingUp DB Started|

[09:54:43:502]|[08-28-2015]|[com.adventnet.mfw.Server]|[INFO]|[10]: Creating new Server instance|

[09:54:44:112]|[08-28-2015]|[com.zoho.framework.utils.crypto.EnDecrypt]|[SEVERE]|[10]: Encryption failed|

[09:54:44:112]|[08-28-2015]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[10]: Reading C:\ManageEngine\AD360\bin\\..\conf\database_params.conf |

[09:54:44:143]|[08-28-2015]|[com.adventnet.ds.DefaultDataSourcePlugIn]|[INFO]|[10]: ConnectionPoolParams :: minSize :: [20], maxSize :: [1], idleTimeout :: [1,800 seconds], blockingTimeout :: [30 seconds]|

[09:54:44:237]|[08-28-2015]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[10]: Archive Adapter class ::: com.adventnet.db.archive.DefaultArchiveAdapter|

[09:54:44:237]|[08-28-2015]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[10]: Storage Adapter class ::: null|

[09:54:44:237]|[08-28-2015]|[com.adventnet.db.api.RelationalAPI]|[SEVERE]|[10]: haltjvm.on.dbcrash is set to [false]|

[09:54:44:237]|[08-28-2015]|[SYSOUT]|[INFO]|[10]: shutDownStrings :: []|

[09:54:44:237]|[08-28-2015]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[INFO]|[10]: BackUp/Restore Version handler :::: null|

[09:54:44:237]|[08-28-2015]|[com.adventnet.db.adapter.Jdbc20DBAdapter]|[WARNING]|[10]: AUTO_QUOTE_IDENTIFIERS not supported for this DB...|

[09:54:44:346]|[08-28-2015]|[com.adventnet.mfw.BackupDB]|[INFO]|[10]: Problem while BackingUp DB. | 

org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.))

 I have a couple of questions too that I need to know the answer.

1º - When I moved the ad360 database to MS SQL, it includes all databases from all components (ADaudit, ADmanager, etc)?? I only see one database (default named “ads”) but I can´t figure out if it contains everything.

2º - Using MS SQL database, your script “backupDB.bat” should work?

 

Regards.