MOM 2005 & SQL Server 2005

[andy89]

When i try to install MOM 2005 on SQL server 2005 beta 2, the installation fails and i get the error "Error 25153. Failed to setup database security. Error Code: -2147217900 (User, group, or role 'SC DW DTS' already exists in the current database.Cannot grant, deny, or revoke permissions to owner, dbo, information_schema, sys, or yourself.Cannot grant, deny, or revoke permissions to owner, dbo, information_schema, sys, or yourself.)"

Ive had a look around google and only found one reference to this specific error here, ive also tried the microsoft beta.yukon newsgroup- no joy there either. Ive tried installing on sql server 2000 sp3 and upgrading to sql server 2005 and that just didnt work. Has anybody got a workaround for this?

Cheerz :D

[andy89]

Ok ive solved it now. For those that wanna know how........

1) Install SQL Server 2000 with a specific named instance ie "MYSQLSERVER" then install SP3a.

2) Install MOM 2005 as you would normally.

3) Backup the SQL Server 2000 "Onepoint" database and save it to a safe backup location.

4) Uninstall SQL Server 2000, delete the SQL Server prog directory.

5) Install SQL Server 2005 Beta 2 using the specified named instance in the SQL Server 2000 install

6) Import the backup of the "Onepoint" database into the new database using the sql server management studio.

Finished!