EYah, check DB connectivity using the start --> programs -- hp openview service desk 4.5 --> application server --> server settings editor. You can test the connectivity there itself. Also, make that as the default, if you have multiple databases configured and then start the applciation server. If you are using a single account for both data and repo, then un-check the repo user check box in the database settings of server settings editor.
The database connection fails. I installed personal edition SQL 2000. I created a database with name Service desk and I created a user and gave him admin right and DB ownership. I am trying to test the connection using same user but it says canot connect. unable to open SD repository.
Does SD application should be started for testing the connection also? when i start the SD application thd DOS window open and says booting then suddenly the windows closes. I am not sure the application is running or not.
yes your application server is not running. The DOS prompt goes away quickly because of DB connectivity issues. If it starts successfully, then the DOS prompt will be there until you stop the server again.
And yeah, just by creating the DB, you won't be able to start SD app server. You need to create all the default tabbles/views required by SD. For this, from the start --> hp openview service desk 4.5 --> applciation server --> database configuration wizard, create a new DB for SD. Select new and give the user name and password that you just created. It's a simple UI and self explanatory. Once you complete the DB confgi wizard successfully, you will be able to start the app server and logon through the client.
I went to Database wizard and tried to create a new database and tried to use the user which i already created in SQL Database. But the error i got is Error in openConnection ! Failed to open connection to service desk repository. java.lang.NullPointerException
even if i tried to create new user i get the same error.
Is the SQL server running? As far as I know, you cannot install enterprise edition of SQL server on a Windows XP OS. The version you have installed will support all the connectivity features?? Please check that.