Error While installing WSUS Reporting Rollup Sample tool

Hi everybody!
While installing the WSUS Reporting Rollup Sample tool, I'm getting the
error message:

Error -2147467259: failed to create SQL database: WsusRollupdatabase, error
detail: unknown error.

I have tried with SQL 2005 express edition and SQL MSDE. Bothe were failed
with same error.

Any help?

[[ Right pew, wrong church. Forwarded to WSUS newsgroup
(microsoft.public.windows.server.update_services) via crosspost as a
convenience to OP.

On the web:
http://www.microsoft.com/communities...pdate_services

In your newsreader:
news://msnews.microsoft.com/microsof...pdate_services
]]


jagan wrote:
> Hi everybody!
> While installing the WSUS Reporting Rollup Sample tool, I'm getting the
> error message:
>
> Error -2147467259: failed to create SQL database: WsusRollupdatabase,
> error
> detail: unknown error.
>
> I have tried with SQL 2005 express edition and SQL MSDE. Bothe were failed
> with same error.
>
> Any help?

"PA Bear [MS MVP]" <> wrote in message
news:...

>> While installing the WSUS Reporting Rollup Sample tool,

The WSUS Reporting Rollup Sample tool is a =WSUS v2= tool, designed to work
against a SQL 2000 database.

The tool was deprecated when Reporting Rollup was built-in to WSUS v3.

Please refer to the WSUS Deployment Guide : Create Replica Servers
[http://technet.microsoft.com/en-us/l...5(WS.10).aspx]
for more information concerning Reporting Rollup configuration in WSUS v3.

--
Lawrence Garvin, M.S., MCITP:EA, MCDBA
Principal/CTO, Onsite Technology Solutions, Houston, Texas
Microsoft MVP - Software Distribution (2005-2009)

My Blog: http://onsitechsolutions.spaces.live.com
Microsoft WSUS Website: http://www.microsoft.com/wsus
My MVP Profile: http://mvp.support.microsoft.com/pro...awrence.Garvin