Moving Opmanager Database From SQL2000 to a SQL 2005 server

Moving Opmanager Database From SQL2000 to a SQL 2005 server

Hi, does anyone have any documentation on this, I copied the DB to the new server setup a new admin account and gave it sysadmin role to test.
I ran the DBconfiguration.bat file and changed the info in ti to point to the new server and credentials. however the apache service starts but the opmanger one fails. I look in the log file and has a sql connection error and a heap of java VM errors. As far as i can see my SQL setup is fine and user and login i created is ok.

see part of the log excerpt below, Any advice wouldf be appreciated.

STATUS | wrapper | 2009/02/27 13:29:19 | --> Wrapper Started as Service
STATUS | wrapper | 2009/02/27 13:29:19 | Launching a JVM...
INFO | jvm 1 | 2009/02/27 13:29:20 | Wrapper (Version 3.1.1)


INFO | jvm 1 | 2009/02/27 13:29:20 |
INFO | jvm 1 | 2009/02/27 13:29:20 | inside addon check
INFO | jvm 1 | 2009/02/27 13:29:21 | taryIconProps {DefaultMenuItem=Status, ApplicationName=OpManager, Menu=[{Id=Status, DisplayName=&OpManager Status, RunProcess=ShowOpManagerStatus}, {Id=StartClient, DisplayName=Start &Client, RunProcess=StartOpManagerWebClient}, {Id=ShutDownServer, DisplayName=Sh&ut Down Server, RunProcess=ShutdownOpManager}], EnableIcon=images/logo16x16_green.png, DisableIcon=images/logo16x16_gray.png, ToolTipText=ProductName, MainProcess=StartOpManager}
INFO | jvm 1 | 2009/02/27 13:29:22 | application_name OpManager
INFO | jvm 1 | 2009/02/27 13:29:22 | Windows 2003
INFO | jvm 1 | 2009/02/27 13:29:22 | startAndRun
INFO | jvm 1 | 2009/02/27 13:29:22 | menuName &OpManager Status RunProcess ShowOpManagerStatus
INFO | jvm 1 | 2009/02/27 13:29:22 | menuName Start &Client RunProcess StartOpManagerWebClient
INFO | jvm 1 | 2009/02/27 13:29:22 | menuName Sh&ut Down Server RunProcess ShutdownOpManager
INFO | jvm 1 | 2009/02/27 13:29:22 | setProcessInProgress true
INFO | jvm 1 | 2009/02/27 13:29:22 | SQLException while getting database connection. Check if database daemon is running
INFO | jvm 1 | 2009/02/27 13:29:22 | java.sql.SQLException: Cannot open database "OpManagerDB" requested by the login. The login failed.
INFO | jvm 1 | 2009/02/27 13:29:22 | at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364)
INFO | jvm 1 | 2009/02/27 13:29:22 | at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2778)
INFO | jvm 1 | 2009/02/27 13:29:22 | at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2214)
INFO | jvm 1 | 2009/02/27 13:29:22 | at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:569)
INFO | jvm 1 | 2009/02/27 13:29:22 | at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:336)
INFO | jvm 1 | 2009/02/27 13:29:22 | at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
INFO | jvm 1 | 2009/02/27 13:29:22 | at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:183)
INFO | jvm 1 | 2009/02/27 13:29:22 | at java.sql.DriverManager.getConnection(Unknown Source)
INFO | jvm 1 | 2009/02/27 13:29:22 | at java.sql.DriverManager.getConnection(Unknown Source)
INFO | jvm 1 | 2009/02/27 13:29:22 | at jdbc.CreateSchema.instantiateConnection(CreateSchema.java:146)
INFO | jvm 1 | 2009/02/27 13:29:22 | at jdbc.CreateSchema.init(CreateSchema.java:84)
INFO | jvm 1 | 2009/02/27 13:29:22 | at com.adventnet.nms.startnms.NmsMainBE.main(NmsMainBE.java:371)
INFO | jvm 1 | 2009/02/27 13:29:22 | at com.adventnet.launcher.nms.StartNmsJdbc.run(StartNmsJdbc.java:262)
INFO | jvm 1 | 2009/02/27 13:29:22 | at java.lang.Thread.run(Unknown Source)
INFO | jvm 1 | 2009/02/27 13:29:22 | Exiting OpManager
STATUS | wrapper | 2009/02/27 13:29:25 | <-- Wrapper Stopped




































                  New to ADSelfService Plus?