Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Mom 2005 SP1 workgroup edition on SQL 2005 silent install?

0 views
Skip to first unread message

bhod...@idirect.ca

unread,
Feb 26, 2007, 5:33:33 PM2/26/07
to
This doesn't work for me. Can anyone help? I ran the prereq and
everything passed. This is a fresh server install. I have the log, and
it is pretty lengthy, should I post it here?

It looks like the installer is having a hard time determining the
version info for SQL.? Here is a snippet of the msi logged lines:


SetSqlProperties: Selected SQL server instance. plasps01\local
MSI (s) (DC!AC) [17:31:27:161]: PROPERTY CHANGE: Deleting
MSSQL_VERSION property. Its current value is '0'.
MSI (s) (DC!AC) [17:31:27:161]: PROPERTY CHANGE: Deleting
MSSQL_CSDVERSION property. Its current value is '0'.
SetSqlProperties: RegOpenKeyEx failed to open CurrentVersion registry
key to get SQL server verion. Error Code: 0x80070002.
MSI (s) (DC:B8) [17:31:27:177]: Machine policy value 'DisableRollback'
is 0
MSI (s) (DC:B8) [17:31:27:177]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE
\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts
3: 2
Action ended 17:31:27: _SetSqlProperties.
5AA3188B_27CE_40D8_B5D2_8D43169A93DA. Return value 3.
MSI (s) (DC:B8) [17:31:27:177]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE
\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts
3: 2
MSI (s) (DC:B8) [17:31:27:177]: No System Restore sequence number for
this installation.
MSI (s) (DC:B8) [17:31:27:177]: Unlocking Server
Action ended 17:31:27: INSTALL. Return value 3.
MSI (s) (DC:B8) [17:31:27:505]: Note: 1: 1708
MSI (s) (DC:B8) [17:31:27:505]: Product: Microsoft Operations Manager
2005 Workgroup Edition -- Installation failed.

MSI (s) (DC:B8) [17:31:27:536]: Cleaning up uninstalled install
packages, if any exist
MSI (s) (DC:B8) [17:31:27:536]: MainEngineThread is returning 1603
MSI (s) (DC:DC) [17:31:27:646]: Destroying RemoteAPI object.

Thanks,

Brad

Anders Bengtsson

unread,
Feb 27, 2007, 2:09:33 AM2/27/07
to
Hi

Is it a requirement to run silent installation? Else try to do it with the
GUI.
Also, paste the command you are using when silent installtion.

--


Regards
Anders Bengtsson [MCSE, MCSA:Security/Messaging] | anders AT contoso.se |
http://www.contoso.se

<bhod...@idirect.ca> wrote in message
news:1172529213.0...@8g2000cwh.googlegroups.com...

bhod...@idirect.ca

unread,
Feb 27, 2007, 10:35:11 AM2/27/07
to
On Feb 27, 2:09 am, "Anders Bengtsson" <and...@contoso.se> wrote:
> Hi
>
> Is it a requirement to run silent installation? Else try to do it with the
> GUI.
> Also, paste the command you are using when silent installtion.
>
> --
>
> Regards
> Anders Bengtsson [MCSE, MCSA:Security/Messaging] | anders AT contoso.se |http://www.contoso.se
>
> <bhodg...@idirect.ca> wrote in message
> > Brad- Hide quoted text -
>
> - Show quoted text -

Apparently MOM2005 SP1 WG will not install normally on SQL 2005, it
has to be done through silent install. When I get to the part of
selecting the database instance, clicking "next" does nothing.

Anders Bengtsson

unread,
Feb 27, 2007, 11:49:50 AM2/27/07
to
Are you running a MOM CD with MOM SP1 included?

Are you running a MSI command like this?
msiexec /i [location of CDImage]\MOMServer.msi /qn /l*v
%TEMP%\MOMWorkgroupEdition.log ENABLE_ERROR_REPORTING=1
SQLSVR_INSTANCE=[MACHINE]\[SQL2005INSTANCE] ACTIONSUSER=[account]
ACTIONSPASSWORD=[password] ACTIONSDOMAIN=[DOMAIN] MOM_2005_SP_INSTALL=1
MS_MPS=[Location of CDImage]\ManagementPacks\Setup

Are you running a "real" version of SQL 2005? Express edition will not work.

--

Regards
Anders Bengtsson [MCSE, MCSA] | anders AT contoso.se |
http://www.contoso.se


<bhod...@idirect.ca> wrote in message
news:1172590511....@a75g2000cwd.googlegroups.com...

bhod...@idirect.ca

unread,
Feb 28, 2007, 10:25:50 AM2/28/07
to
On Feb 27, 11:49 am, "Anders Bengtsson" <and...@contoso.se> wrote:
> Are you running a MOM CD with MOM SP1 included?
>
> Are you running a MSI command like this?
> msiexec /i [location of CDImage]\MOMServer.msi /qn /l*v
> %TEMP%\MOMWorkgroupEdition.log ENABLE_ERROR_REPORTING=1
> SQLSVR_INSTANCE=[MACHINE]\[SQL2005INSTANCE] ACTIONSUSER=[account]
> ACTIONSPASSWORD=[password] ACTIONSDOMAIN=[DOMAIN] MOM_2005_SP_INSTALL=1
> MS_MPS=[Location of CDImage]\ManagementPacks\Setup
>
> Are you running a "real" version of SQL 2005? Express edition will not work.
>
> --
>
> Regards
> Anders Bengtsson [MCSE, MCSA] | anders AT contoso.se |http://www.contoso.se
>
> > selecting the database instance, clicking "next" does nothing.- Hide quoted text -

>
> - Show quoted text -

Yes, I am running the above script. I am installing MOM 2005 SP1
workgroup edition to a fresh server running SQL 2005 Workgroup
edition.
Here are some of the errors in the log I was ableto pick out. I'm not
sure why they are there, or how relevant they are to the failed
install:

CPreReqVerifier::CheckCurrentUserIsDBAdmin: Setup registry key not
found. Error Code: 0x80070002.
CPreReqVerifier::ExclusiveChecksfailed: hr: -2147024894

(I do have SA rights to the database)

and:

SetSqlProperties: RegOpenKeyEx failed to open CurrentVersion registry
key to get SQL server verion. Error Code: 0x80070002.

Any of this make sense or should I post the whole log? (I'm reluctant
to do this, it's pretty long)

Cheers,

Brad


Anders Bengtsson

unread,
Feb 28, 2007, 2:39:32 PM2/28/07
to
Have you had MOM installed on that server before?

--

Regards
Anders Bengtsson [MCSE, MCSA] | anders AT contoso.se |
http://www.contoso.se


<bhod...@idirect.ca> wrote in message
news:1172676350.2...@a75g2000cwd.googlegroups.com...

bhod...@idirect.ca

unread,
Mar 1, 2007, 11:46:46 AM3/1/07
to
On Feb 28, 2:39 pm, "Anders Bengtsson" <and...@contoso.se> wrote:
> Have you had MOM installed on that server before?
>
> --
>
> Regards
> Anders Bengtsson [MCSE, MCSA] | anders AT contoso.se |http://www.contoso.se
>

No this is a clean, newly rebuilt server.

Anders Bengtsson

unread,
Mar 1, 2007, 12:09:55 PM3/1/07
to
If you want to you can post your command so we can see if it look right.

--

Regards
Anders Bengtsson [MCSE, MCSA] | anders AT contoso.se |
http://www.contoso.se


<bhod...@idirect.ca> wrote in message
news:1172767606.4...@31g2000cwt.googlegroups.com...

bhod...@idirect.ca

unread,
Mar 1, 2007, 2:59:40 PM3/1/07
to
On Mar 1, 12:09 pm, "Anders Bengtsson" <and...@contoso.se> wrote:
> If you want to you can post your command so we can see if it look right.
>
> --
>
> Regards
> Anders Bengtsson [MCSE, MCSA] | anders AT contoso.se |http://www.contoso.se
>
> > No this is a clean, newly rebuilt server.- Hide quoted text -

>
> - Show quoted text -

Anders,

Thanks for making me take another look. I had 2 instances of SQL on
this server as it is also running Backup Exec, which has it's own SQL
back end. My mistake was specifying the server and instance, when I
should have been specifying just the server as it is the default
instance. I removed the "local" from the lines below, and now it
works!

Thanks,

Brad

msiexec /i G:\MOM2005\MOMServer.msi /qn /l*v %TEMP%
\MOMWorkgroupEdition.log ENABLE_ERROR_REPORTING=1
SQLSVR_INSTANCE=plasps01\local ACTIONSUSER=administrator
ACTIONSPASSWORD=******** ACTIONSDOMAIN=plaspscc MOM_2005_SP_INSTALL=1
MS_MPS=G:\MOM2005\ManagementPacks\Setup

0 new messages