I have restored OVSD database in development server and after that I am not able to login to OVSD on developement server. It is saying Application Server is not running.
I also tried to start OVSD services but it is getting started and automatically stopping when I try to open OVSD client. I have also tried to start OVSD application server. It is getting started but still not able to login to OVSD client.
OVSD 4.5 SP18 OS: Windows 2003 Database: MS SQL 2000
A very common issue with the restores is that the database account that you have specified is not the owner of the database and therefore cannot see the correct tables. In a SQL environment I find that it helps to detach the restored database and then re-attach specifying the database user that I have specified in the app server settings. Does the Server log give any indication about why it is stopping or not starting.
When you restored the DB onto Development, did you change the DB password? If you donâ t remember the password, try to change the password on the Database as well as change the password on OVSD Database configuration wizard. Hope this should resolve the problem.
Thanks a lot for your reply. I have tried detaching and re attaching the Database with the user specified in OVSD Server Settings.
I have also tried starting server from command prompt. Found follwing error
hp OpenView service desk 4.5 Copyright (c) 2004 Hewlett-Packard Development Company, L.P. All Rights Reserved . booting...............running Unable to start server java.lang.ExceptionInInitializerError The repository is not loaded at com.hp.ifc.bus.AppSrvDispatch.invoke(Unknown Source) at com.hp.ifc.rep.AppRepository.refresh(Unknown Source) at com.hp.ifc.rep.AppAbstractInfoManager.refreshLocalScheduledTasksData( Unknown Source) at com.hp.ifc.rep.AppAbstractInfoManager.getLocalScheduledTasksInfo(Unkn own Source) at com.hp.ifc.util.taskman.AppScheduledTasksInfoManager.getLocalSchedule dTasks(Unknown Source) at com.hp.ifc.util.taskman.AppScheduledTasksQueue.startup(Unknown Source ) at com.hp.ifc.bus.AppServer$1.run(Unknown Source) at java.lang.Thread.run(Thread.java:534) -------------------
Found following common error in Server log when I try to start OVSD services.
Mon, 23/04/2007 09:51:38 Initialized Opta SQL Server JDBC Driver DataSource Mon, 23/04/2007 09:51:38 Connection to service desk repository was not added to the pool because of [SGX-BAC\DEVELOPMENT]Cannot open user default database. Login failed. Mon, 23/04/2007 09:51:38 Failed to open connection to service desk repository. [SGX-BAC\DEVELOPMENT]Cannot open user default database. Login failed. Mon, 23/04/2007 09:51:38 End session.