Hello!

 

I was using the trial version of service desk plus professional with the PostgreSQL backend installed on a windows 7 machine.  After our trial expired we decided to go with the free edition.  We have installed the free version on a windows 2008R2 server and have gone with a MSSQL backend.  I have attempted to follow the documentation for restoring the data to the new server but we are getting lots of errors and the process is failing.  the error messages are as follows

 

any ideas would be welcome.

 

WARNING: AUTO_QUOTE_IDENTIFIERS not supported for this DB...
Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.mssql.Ms
sqlSQLGenerator javax.naming.NoInitialContextException: Need to specify class na
me in environment or system property, or as an applet parameter, or in an applic
ation resource file:  java.naming.factory.initial
Mar 25, 2013 10:44:44 AM com.adventnet.db.adapter.Jdbc20DBAdapter setUpDB
SEVERE: Start DBServer operation is not supported
Active DB Server = mssql
Database connectionProp : null
Error while trying to instantiate SQLGeneratir com.adventnet.db.adapter.SQLGener
ator java.lang.InstantiationException: com.adventnet.db.adapter.SQLGenerator
Database started
Backup build number not compatible with existing build
Backup build number not compatible with existing build

Mar 25, 2013 10:44:51 AM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: dbadapter :: [com.adventnet.db.adapter.mssql.MssqlDBAdapter@69d4eeb5], sta
rtDBServer :: [true], dbProp :: {BlockingTimeoutMillis=30000, ManagedConnectionF
actoryProperties=
, Criteria=ByContainer, LocalTransactions=true, MinSize=0, Password=3tv02mgg, Jn
diName=MSSQLDS, MaxSize=20, SecurityDomainJndiName=DBPwdEncrypt, DriverClass=net
.sourceforge.jtds.jdbc.Driver, TrackConnectionByTx=true, IdleTimeoutMinutes=15,
UserName=Servicedesk, ConnectionURL=jdbc:jtds:sqlserver://pella-sqldb01:1433;Dat
abaseName=Servicedesk;Tds=8.0;PrepareSql=3;XaEmulation=false;}
Mar 25, 2013 10:44:51 AM com.adventnet.db.adapter.Jdbc20DBAdapter shutDownDBForc
eFully
SEVERE: Stop DBServer operation is not supported in Jdbc20DBAdapter
Mar 25, 2013 10:44:51 AM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: waitAfterDBStop :: val :: [5]
Mar 25, 2013 10:44:51 AM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Thread is going to sleep for [5] seconds
Mar 25, 2013 10:44:56 AM com.adventnet.updatemgr.util.ConfUtils stopDB
INFO: Coming out of stopDB