Today MS released updated version of the “Operations Manager 2007 Data Warehouse Library Management Pack” and the “System Center Operations Manager 2007 Management Pack Update”.
You can get hold of these by going to the download catalogue here:
http://www.microsoft.com/technet/prodtechnol/mom/catalog/catalog.aspx
If you are installing the web console on a server other than your root
management server using the Windows Authentication method and when you try to connect you recieve a "Your login attempt was not successful" error and your username and password are both greyed out then you are probably experiencing a Kerberous double hop
issue.
In short you supply your credentials to IIS and it then tries to pass them
onto SQL but cannot hence the double hop.
You therefore have a couple of options, you can switch authentication on
your IIS server to basic, which is not obviously ideal from a security
standpoint as you are authenticating with your username and password in
clear text, or you can go with the official, CSS supported approach which is
use forms based authentication, although this requires you to enable SSL and
means you have to go through the process of creating and installing a secure
server certificate.