CIM7 SP1 upgrade fails due to database problem

[Ayman Altounji]

I have been trying to upgrade my CIM7 install to SP1. Everything goes ok until I get to the part that asks me for my database info. It is defaulting to a database name of Insight_DB_V31 and is grayed out so I cannot change it. The problem is that my actual database (SQL2000 on a seperate server) is named Insight_DB_V3. It also defaults to 'sa' for my SQL user account. We do not use 'sa'. It too is grayed out and cannot be changed. I unistalled CIM7 and reinstalled the SP1 version but the problem still exisits. I thought there must be something left over in the registry but when I tried installing CIM on a completely different server, I still had the same problem. Any ideas? Thanks.

[Ayman Altounji]

If your DB settings are greyed out, it is because you cannot acces it !
Under SQL 2000, the default security setiing is "Windows only". So you take the Enterprise manager, select the server, properties, change it to "both". You **MUST** know the password of SA, to install CIM7.
You say it is an upgrade ? How come it worked before ? Did you upgrade SQL7 to SQL 2000 ???
hth

[Ayman Altounji]

I can't solve your problem but I can make a suggestion...

You can try to manipulate your ODBC connection to the SQL server so that a connection exists that CIM can use for the upgrade.

[Ayman Altounji]

I'm also experiencing the SAME EXACT problem... I'm on Windows 2000 and work with SQL Server 7.CIM7 SP1 with MSDE works perfectly but won't work with SQL Server 7...

Anybody have cues ?

[Ayman Altounji]

The database name seems to be hardcoded to INSIGHT_DB_V31. I installed it as an upgrade over my existing CIM7 and the setup created the new database and migrated over all the existing data and settings from the legacy database. I then detached the old database. You shouldn't worry about the new name.
In regards to the 'SA' account. I don't think there's any way around that either. When I originally tried to install CIMXE, it defaulted to SA but let you change it. I tried to change it and the install kept failing until I used the SA account. I guess now, they just don't let you change it. You could probably create an SA account and give it SysAdmin rights temporarily. Once CIM7 is installed, you can change the account it uses in the WebGUI. SQL2000 defaults to NT Only security, but CIM7 needs SQL logins so you'll have to switch over to Mixed Mode.

[Ayman Altounji]

Is there any Compaq Staff on the Forum which can help us solve that one... Can't resolve that one... Have been working on it for a full week

[Ayman Altounji]

ksq
Did you try the hint suggested in reply 1 ?

I know for sure that the settings on W2K will not work with CIM7 unless you change the SQL server properties as explained.

[Ayman Altounji]

I think ajhva in reply # 4 has hit the mark. CIM was not trying to access my old database but rather create a new one. That's why it needed sa. It would then migrate the old data over. Since I uninstalled the old version and was doing a fresh install, I was able to let it create the new database and then change the system dsn and CIM7SP1 to use the alternate account that we had used before. All is well now.

[Ayman Altounji]

I experienced all these problems and the way to ensure that it works that that you comply with all the DATABASE PREREQUISITES in the CIM7UG.PDF section. Then ensure that the sa account on sql and cim7 match. SQL Enterprise Mgr; Register or ReRegister the SQL server using sa (with mixed mode set)...then go to cim7 Setting|Server|Database and reenter the sa account password with the one used in SQL Enterprise Mgr. THEN, More importantly, go to the ODBC SYSTEM DSN tab and connect it to the correct SQL server using sa account, the correct default database, and perform a TEST database. This will more than likely ensure the upgrade works flawlessly.
Oh by the way, if you blank out the sa account password in CIM7|Settings|Server|database, it will connect to the SQL database with a trusted account (If Mixed Mode is set).