topic Re: IM 7 sp2 / win2003 / sql2000 in Server Management (Insight Manager 7)

IM 7 sp2 / win2003 / sql2000

PeteW_1 — Mon, 08 Sep 2003 17:43:30 GMT

I have sql2000 with sp3. My application needs to have sql as default instance. I choose to install insight manager database into my sql, however error "unable to install database schema column name "devicekey" does not exist in target table". Everything else with sql is working without problems. I am choosing correct sa. Have attempted sa with and without passwords.
I then attempt to install insight manager with the msde. However the msde must have the default instance name. Any thoughts?? Attachement contains error...Thanks..

Re: IM 7 sp2 / win2003 / sql2000

Jadrice Toussaint — Mon, 08 Sep 2003 19:36:52 GMT

Peter -

Try removing the Insight database from the SQL server then retry the installation. That's if one was created.

Let me know how you make out.

Re: IM 7 sp2 / win2003 / sql2000

PeteW_1 — Tue, 09 Sep 2003 12:37:25 GMT

Jadrice. Thanks for the response. I am in no way a SQL person, however Im able to get my app up and running, Copying a SQL 7 database to a new SQL 2000 server. not sure what Im missing. I had reinstalled Insight Manager, without deleting the database and during install IM will ask to delete the existing database which I choose to do. The problem occurs at the end of install trying to update schema. With the above error. IM install process hangs, and I have to end process. I then attempt to uninstall and receive error that the uninstall file is corrupt. Like I mentioned Im not exactly a SQL expert...any thoughts would be appreciated...Pete

Re: IM 7 sp2 / win2003 / sql2000

Jadrice Toussaint — Tue, 09 Sep 2003 13:00:21 GMT

Is the SQL server on the same box as Insight Manager or is it on a different server?

Re: IM 7 sp2 / win2003 / sql2000

PeteW_1 — Tue, 09 Sep 2003 13:01:26 GMT

Same machine...

Re: IM 7 sp2 / win2003 / sql2000

Jadrice Toussaint — Tue, 09 Sep 2003 14:13:24 GMT

create a new login on the SQL server and give that user database creation and owner access. Make sure that user matches the same user you're installing Insight Manager with. In that case a domain account I'm assuming.

Once you've created the account in SQL, reinstall IM7 using the same domain account.

Re: IM 7 sp2 / win2003 / sql2000

Jadrice Toussaint — Tue, 09 Sep 2003 14:13:48 GMT

Re: IM 7 sp2 / win2003 / sql2000

PeteW_1 — Tue, 09 Sep 2003 16:41:43 GMT

Again same problem. I had followed your instructions..

"Unable to install database schema. Column name 'deviceKey' does not exist in target table. 1> 2> 3> 4> 5> 6>....
Please see attachment.
thank you for the help.

Re: IM 7 sp2 / win2003 / sql2000

Rigo Tamas — Sat, 30 Oct 2004 01:42:46 GMT

I'have this problem, too.
Is there the resolution?

Re: IM 7 sp2 / win2003 / sql2000

Mark Roberts_6 — Wed, 17 Nov 2004 12:07:36 GMT

I've had this problem with IM 7 SP1 and I found that I could install it successfully when I had a default installation of SQL2000. However, I later needed to change the collation of my SQL2000 install to 'SQL_Latin1_General_CP850_BIN' (which required a complete uninstall and re-install of SQL choosing the 'Binary order for use with the 850 Multilingual Character Set' option).

After doing this I found that I could no longer install IM7 SP1 as I had the error 'Unable to install database schema'.

I dunno whether this'll help anyone, but it might be a place to start for you.

Re: IM 7 sp2 / win2003 / sql2000

Ritter Philippe — Fri, 03 Dec 2004 03:20:18 GMT

Hello,

I have the same Problem.I have the same configuration, but I don't install SQL as default, because I had to change the sort order and character set to 1252.

Does someone know a fix for this problem ?

Thanks
Philippe RITTER

Re: IM 7 sp2 / win2003 / sql2000

Rigo Tamas — Fri, 03 Dec 2004 03:45:20 GMT

Solution to SQL server uninstall and install (or Master table rebuild)

Re: IM 7 sp2 / win2003 / sql2000

Ritter Philippe — Fri, 03 Dec 2004 06:08:15 GMT

It is a fresh install from SQL Server. I cannot uninstall it and install again with defaults value, because I need this sort order.

Re: IM 7 sp2 / win2003 / sql2000

Ritter Philippe — Fri, 03 Dec 2004 08:48:38 GMT

OK, i resolved the problem of install if the default value are not the same :
Install IM7, after error, restart again. When prompted, delete database and IM7 will create a new one. After that, you will have a prompt for continuing. At this time open an sql query analyzer and execute following command :
alter database INSIGHT_DB_V32 collate French_CI_AS
And continue the setup.

Re: IM 7 sp2 / win2003 / sql2000

David Claypool — Mon, 06 Dec 2004 11:02:10 GMT

All, please be aware that IM7 is end-of-life and has been replaced by HP Systems Insight Manager - http://www.hp.com/go/hpsim - which is releasing its third release this week, HP SIM 4.2. There is a data migration tool to make moving to SIM 4.2 easier.