topic HP Sim 5.1 SQL Database Installation in Server Management - Systems Insight Manager

HP Sim 5.1 SQL Database Installation

Woodie — Fri, 16 Feb 2007 05:36:56 GMT

Hello

When I install HP Sim 5.1 and get to the stage where I am prompted to install a database to an SQL server I seem to be getting errors. I have created a blank database on our SQL server with admin rights (dbo). When I input the details into the HP Sim installation and click next a pop up box displays 'Insufficient rights to database'. I have also tried the sa username and password and still have no joy.

For testing purposes I have created an ODBC connection with making sure the admin username was chosen with it's password. I also made sure it was connecting to the hpsim database on our SQL server. When I went to test the connection it passed without error.

Is there a bug in the HP Sim 5.1 installation, or do I need to install some SQL software before I can perform this task.

Look forward to hearing from you.

James

Our SQL server is Windows 2003. The HP Sim server is Windows 2000 Server.

Re: HP Sim 5.1 SQL Database Installation

Daniel Leblanc — Fri, 16 Feb 2007 13:44:18 GMT

Hope you re not using SQL 2005 Express?

Re: HP Sim 5.1 SQL Database Installation

Rob Buxton — Sun, 18 Feb 2007 14:00:47 GMT

HPSIM creates its own database. I stay with using Windows credentials and use a Domain Account that has Admin rights to the SQL Server box.
If you are using a remote SQL Server DB, no additional software is required, just the access rights.

Re: HP Sim 5.1 SQL Database Installation

James Kennedy_5 — Tue, 20 Feb 2007 07:27:05 GMT

make sure you leave the database name as "master". SIM will create its own database name.

The account you are using must have full rights to the SQL server. Make it an admin of the SQL server and DB Admin as well. You can remove some rights later.

Re: HP Sim 5.1 SQL Database Installation

Christian Douma — Tue, 27 Feb 2007 09:05:24 GMT

Does anybody know how I could change the database name. The name created automatically by the installer isnt compliant with our name convensions.