IM 7 sp2 / win2003 / sql2000

[PeteW_1]

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..

[Jadrice Toussaint]

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.

[PeteW_1]

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

[Jadrice Toussaint]

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

[PeteW_1]

Same machine...

[Jadrice Toussaint]

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.

[Jadrice Toussaint]

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.

[PeteW_1]

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.

[Rigo Tamas]

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

[Mark Roberts_6]

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.

[Ritter Philippe]

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

[Rigo Tamas]

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

[Ritter Philippe]

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

[Ritter Philippe]

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.

[David Claypool]

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.