HPSIM5 just sits at "Checking HTTP Server Status"

[Jonathan Clark_2]

any ideas. I try to goto http://localhost:280 or http://127.0.0.1:280 and I get page cannot be found.

Please assist.

[Darrin Rawls]

Make sure that "localhost" can be resolved locally (try pinging it). Check to see if the MSSQLSVR service is running - that's what that check is doing. If its running, cycle MSDE/SQL - something is not responding.

Check Internet Explorer, can it get to localhost or is that being blocked by a firewall, or other software. I.e. do you have a proxy connection and localhost isn't in the 'No Proxy' list...

[Jonathan Clark_2]

did all of that, still same issue.

[Darrin Rawls]

can you open another browser, type in https://hostname:50000 or https://ipaddress:50000 and get in?

[Jonathan Clark_2]

nope, same issue....

[Darrin Rawls]

Is the HP Systems Insight Manager service actually showing running in Admin Tools/Services?

[Jonathan Clark_2]

yes, it appears there and It is started and running under the Domain Admin account I used to install with.

[Jonathan Clark_2]

ok I did a reinstall and now I get this:

[08-22-2005][17:54:04][HP Systems Insight Manager]HP Systems Insight Manager installation completed.
Configuring Server Components (15):
1. Node Security File
- Successful
2. Server Property File
- Successful
3. Server Authentication Keys
- Successful
4. SSH Keys
- Successful
5. Status Property File
- Successful
6. Task Results Output Cleanup
- Successful
7. Database Configuration
[08-22-2005][17:57:58][HP Systems Insight Manager]Error:Database initialization failed
[08-22-2005][17:57:58][HP Systems Insight Manager]Error:Database initialization failed
[08-22-2005][17:58:01][HP Systems Insight Manager]Shutdown.

so if that happened the first time. I judging it is because of this error. PLEASE ASSIST.

Database is MSDE on the same server as SIM

[Zach Richardson]

Hey Jon,
I've found that you need to assign admin rights to the domain account that your installing SIM with on the database server. At least, that's what worked for me.

[Jonathan Clark_2]

already logged in as domain admin. I did some more searching on the logs and found something about not a SQL Trusted Connection.

Google search turned up a regedit to set the sql authentication to mixed.

I'm reinstalling now and hoping it will work.. If it does, I'll provide more details.

[Darrin Rawls]

Okay, let us know. Shouldn't need that though, something is definetly hosing MSDE up. I'm assuming you are using the MSDE from the SIM 'kit' and are using the HPSIM installer to install MSDE.

Just have to ask. :)

[Jonathan Clark_2]

using MSDE from the SIM kit, however I'm just browsing to the MSDE folder under database and doing an install after editing the setup.ini file to include the needed instance name and sa password.

did i do this wrong? Please assist

[Darrin Rawls]

Ah, you can't do that. There are actually parameters passed through the SIM installer to get that installed. Need to do it that way....

[Jonathan Clark_2]

which brings me to the next question of How???

[Darrin Rawls]

Uninstall MSDE from Add/Remove Programs (shouldn't need a reboot but sometimes with Windows 2000 its needed if prompted).

Make sure there is no "Insight..." ODBC connection setup.

Run SETUP.EXE from the SIM kit. It should detect that there is no MSDE/SQL installed locally and prompt you to install MSDE in the SIM installer.

[Jonathan Clark_2]

thats the problem. There are already instances of MSDE installed that i need to keep. This is the same machine that we use for our veritas that runs off of MSDE.

[Darrin Rawls]

Okay. If you have the download kit extracted, go to the 'temp' area (dependent on your temp path) and check the HPSIMICF file directory.

There should be a MSDE.ICF file there. Open it in notepad, tweak the install setup path to add your named instance switches there, then run SIM (or just run that complete path manually).

[Jonathan Clark_2]

this is what that file contains. I have no clue what to change:

//
// Installation Configuration File for MSDE
//
//
function ()
{
var index = 0;
var TXT_PROD_NAME = index++;
var TXT_PROD_DESCRIPTION = index++;
var TXT_STATUS_SUCCESS = index++;
var TXT_STATUS_REBOOT = index++;
var TXT_STATUS_FAILED = index++;
var TXT_STATUS_UNKNOWN = index++;

this.CanInstall = function(sCfgDir) {if (!oFSO.FileExists(sCfgDir + this.SetupFile) || (this.ProductVersion() == this.InstalledVersion())) return false; else return true;}
this.ConfigFileType = function() {return SYSCHECK_SHELL;}
this.ConfigFileVersion = function() {return "2.01.00";}
this.DefaultFolder = function() {return oShell.ExpandEnvironmentStrings("%programfiles%")+"\\Microsoft SQL Server";}
this.InstallCmd = function(sCfgDir) {return oFSO.GetAbsolutePathName(sCfgDir + this.SetupFile);}
this.InstallDiskSpace = function() {return 18;}
this.InstalledVersion = function() {var ver = ""; try{ver = oShell.RegRead("HKLM\\Microsoft\\Windows\\CurrentVersion\\Uninstall\\{E09B48B5-E141-427A-AB0C-D3605127224A}\\DisplayVersion");}catch(err){} return ver;}
this.InstallOrdinal = function() {return 100;}
this.InstallSupport = function() {return 0;}
this.LogFile = function() {return oShell.ExpandEnvironmentStrings("%systemdrive%") + "\\msde.log";}
this.ProductDescription = function() {return this.MsgText(TXT_PROD_DESCRIPTION);}
this.ProductID = function() {return "0565E735-6353-4211-1234-0FD5101C873E";}
this.ProductName = function() {return this.MsgText(TXT_PROD_NAME);}
this.ProductVersion = function() {return "8.00.761";}
this.SetupFile = '\\..\\database\\msde2000\\setup.exe';
this.SilentInstallCmd = function(sCfgDir) {return oFSO.GetAbsolutePathName(sCfgDir + this.SetupFile) + ' -silent';}
this.SilentUninstallCmd = function() {return "MsiExec.exe /q /x{E09B48B5-E141-427A-AB0C-D3605127224A}";}
this.SystemDiskSpace = function() {return 0;}
this.TempDiskSpace = function() {return 10;}
this.UninstallCmd = function() {return "MsiExec.exe /x{E09B48B5-E141-427A-AB0C-D3605127224A}";}
this.ExitCodeString = function (nExitCode)
{
switch (nExitCode)
{
case 0 : return this.MsgText(TXT_STATUS_FAILED);
case 0 : return this.MsgText(TXT_STATUS_SUCCESS);
case 3010: return this.MsgText(TXT_STATUS_REBOOT);
default:return this.MsgText(TXT_STATUS_UNKNOWN);
}
}
this.MsgText = function(nIndex)
{
switch (window.navigator.userLanguage.substr(0,2))
{
case "fr":
case "it":
case "es":
case "de":
case "ja":
switch(nIndex)
{
case TXT_PROD_NAME: return "MSDE";
case TXT_PROD_DESCRIPTION: return "MSDE";
case TXT_STATUS_SUCCESS: return " ³ íâ Ã Æ CÆ â Æ XÆ g [Æ â ¹â ³â êâ à ⠵⠽ B";
case TXT_STATUS_REBOOT: return "Æ CÆ â Æ XÆ g [Æ â ¹â ðŠ®â ¹â ³â ¹â éâ ½â à â à â à  à ⠹N⠮⠪⠢Kâ vâ à â · B";
case TXT_STATUS_FAILED: return "Æ ZÆ bÆ gÆ AÆ bÆ vâ à  Iâ Â¹Æ R [Æ h: ";
default: return "Unknown text string " + nIndex;
}
break;
default:
switch(nIndex)
{
case TXT_PROD_NAME: return "MSDE";
case TXT_PROD_DESCRIPTION: return "MSDE";
case TXT_STATUS_SUCCESS: return "Installed Successfully.";
case TXT_STATUS_REBOOT: return "A restart is required to complete the install.";
case TXT_STATUS_FAILED: return "Setup failed.";
default: return "Unknown text string " + nIndex;
}
break;
}
}
};

[Darrin Rawls]

Okay, maybe that wasn't the best suggestion. :)

How about just running this command instead (tweaking for your named instance of course):

setup.exe DISABLENETWORKPROTOCOLS=0 REBOOT=ReallySuppress SAPWD="pwdâ INSTANCENAME="InstanceName" (you can add the SILENT switch if you want to; doesn't matter if you are manually doing it)

[Jonathan Clark_2]

nope install still fails with: Database initialization failed for URL: jdbc:jtds:sqlserver://CTXTEST1:1433/Insight_v50_0_13573671;domain=NAI;instance=InsightMgr5 Ex: java.sql.SQLException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Error accessing database

[Darrin Rawls]

Are you logged in to the server as an 'administrator'? Is it local or domain?

[Jonathan Clark_2]

logged in on the server the domain administrator. The same account I used to install MSDE

[Darrin Rawls]

Just to be clear, MSDE is installed okay. Then when you run the SIM installer, you get this. Right?

[Jonathan Clark_2]

as far as I know it is. It goes through the entire fine, no problems. I even don't get the "Invalid Credentials" message that I used to.

I run the setup.exe install for msde using the switches you gave me. That runs and I reboot.

Than in the bottom right i have my sql service manager that comes up and I can stop, pause, and restart the service without errors.

I run the install for HP SIM and it runs through fine until it gets to Populating Database(Initializing database). It sits there for about 2 minutes than errors out and says to look at the log. When I do I see those errors I posted above.

Please assist.

[Darrin Rawls]

Okay, thanks. hmmm