topic Re: USING SQLEXPRESS 2005 in Server Management - Systems Insight Manager

USING SQLEXPRESS 2005

Waldorf — Mon, 23 Oct 2006 18:30:11 GMT

I currently have an sql server that i have also installed SQLEXPRESS onto. I am attempting to install SIM onto this server, when i get to the select DB, i try to select express but i get an error, "unable to get information from the specified database server". When i select the full version of SQL it works no problems. I have tried to change ports but i still get the same error. I currenty have SIM on a test server running just fine using SQLEXPRESS. Does anyone know a way around this. thanks

Re: USING SQLEXPRESS 2005

ramesh_naik_ — Tue, 24 Oct 2006 07:02:08 GMT

Hi Waldorf,

What is the version of the HP SIM and the SP?

Support for SQL Server 2005 was introduced with hp SIM 5.0 SP5.

SQL Server 2005 Express Edition may not supported as of now with SIM 5.0 SP5.

If you feel if it is something to do with the port then you could change the port by editing the file database.props found under /config folder.

Modify the line hp.Database.portnumber= to the new port. By default, it is 1433.

Then, Restart the HP Systems Insight Manager service and the HP Virtual Machine Management Service service, if installed.

Hope this answers!!!!

Regards,
rmn

Re: USING SQLEXPRESS 2005

Daniel Leblanc — Tue, 24 Oct 2006 14:55:57 GMT

In the Technical Specifications

Minimum Hardware and Software Requirements for HP Systems Insight Manager
Windows Central Management Server

In the software there is BIG comment in BLEU:
NOTE: SQL Server 2005 Express Edition is not supported.

http://h18004.www1.hp.com/products/quickspecs/11824_div/11824_div.html

You have the answer!

Re: USING SQLEXPRESS 2005

waldorf_1 — Tue, 24 Oct 2006 19:51:43 GMT

Thank you both for your imput, i am some what confused, when you say its not supported does this mean i cant get help or that it does not work?

if it be the latter then you are incorrect as i mentioned i have it running on a test machine. the only difference is that I installed the Express version first then full SQL. it WORKS.
If i install SQL Full, then SQL Express then SIM, it DOES NOT WORK.

Re: USING SQLEXPRESS 2005

ramesh_naik_ — Wed, 25 Oct 2006 00:30:59 GMT

Hi Waldorf,

No Silver bombs here.........

You have already proved that it can be installed but with a different procedure.

Then why not try the same thing on this server as well.
I think this may be something to do with dependencies with the SQL2005 full version and the SQLEXPRESS 2005.

Not sure about that!!! not tried it personally.

Regards,
rmn