Related issues. No data in DW and no reports

Discussion:

(too old to reply)

Mark

2007-07-05 13:20:01 UTC

I get numerous of these data warehouse errors:

Failed to enumerate (discover) Data Warehouse objects and relationships
among them. The operation will be retried.
Exception 'SqlException': Management Group with id
'961D1028-7908-6622-623E-9251D56B5682' is not allowed to access Data
Warehouse under login 'OpsMgrDW'

Failed to obtain synchronization process state information from Data
Warehouse database. The operation will be retried.
Exception 'SqlException': Management Group with id
'961D1028-7908-6622-623E-9251D56B5682' is not allowed to access Data
Warehouse under login 'OpsMgrDW'

Failed to enumerate Data Warehouse components for deployment. The operation
will be retried.
Exception 'SqlException': Management Group with id
'961D1028-7908-6622-623E-9251D56B5682' is not allowed to access Data
Warehouse under login 'OpsMgrDW'
-----------------------

Also whe I try and run a report I get a failed to initialize report error.

I have tried using a domain account, but then I get login errors to the
database.

please help. these error cause the Health Service on the RMS to fail.

--
Mark

Marcus

2007-07-05 15:26:05 UTC

Permalink

Mark,

don't know if this helps but take a look
http://support.microsoft.com/kb/938627/en-us

We had a hard time reinstalling the whole infrastructure 5 times because we
thought the reporting installation issue had to do with going to x64, SQL
2005 SP2 2003 SP2.

Marcus
--
"Alway look at the bright side of life..."

Post by Mark
Failed to enumerate (discover) Data Warehouse objects and relationships
among them. The operation will be retried.
Exception 'SqlException': Management Group with id
'961D1028-7908-6622-623E-9251D56B5682' is not allowed to access Data
Warehouse under login 'OpsMgrDW'
Failed to obtain synchronization process state information from Data
Warehouse database. The operation will be retried.
Exception 'SqlException': Management Group with id
'961D1028-7908-6622-623E-9251D56B5682' is not allowed to access Data
Warehouse under login 'OpsMgrDW'
Failed to enumerate Data Warehouse components for deployment. The operation
will be retried.
Exception 'SqlException': Management Group with id
'961D1028-7908-6622-623E-9251D56B5682' is not allowed to access Data
Warehouse under login 'OpsMgrDW'
-----------------------
Also whe I try and run a report I get a failed to initialize report error.
I have tried using a domain account, but then I get login errors to the
database.
please help. these error cause the Health Service on the RMS to fail.
--
Mark

Mark

2007-07-06 07:46:06 UTC

Permalink

Hi
Tried that already. Got invalid login erros on sql with sdk service account.
The account is a domain account.
--
Mark

Post by Marcus
Mark,
don't know if this helps but take a look
http://support.microsoft.com/kb/938627/en-us
We had a hard time reinstalling the whole infrastructure 5 times because we
thought the reporting installation issue had to do with going to x64, SQL
2005 SP2 2003 SP2.
Marcus
--
"Alway look at the bright side of life..."

Vitaly Filimonov [MSFT]

2007-07-06 20:50:05 UTC

Permalink

Check ManagementGroup table in the DW. What is the WriterLoginName column
value? THat's the account that should be associated with "Data Warehouse
Account" Run-As Profile
--
Vitaly Filimonov [MSFT]
-------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Mark

2007-07-09 16:12:01 UTC

Permalink

Hi

Thanks for the reply.
I did all that, everything matches. We now get erros saying that the login
is not associated with a trusted sql server connection. The user is a domain
account, and I set the sql authentication to windows only. the use has dbo
access to the database.

regards
--
Mark

Post by Vitaly Filimonov [MSFT]
Check ManagementGroup table in the DW. What is the WriterLoginName column
value? THat's the account that should be associated with "Data Warehouse
Account" Run-As Profile
--
Vitaly Filimonov [MSFT]
-------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Vitaly Filimonov [MSFT]

2007-07-09 18:50:02 UTC

Permalink

Check the following things:

1) Open console and switch to the "Administration" tab;
2) Click on Run-As Accounts and double click "Data Warehouse SQL Server
Authentication Account"
3) Switch to the Account tab and confirm the account name is single space (I
suspect it is not - if that's the case, set it to single space)
4) Check the account is associated to same-name profile (on the "Run As
Profile" tab)

What I think is hapenning, you have instructed SCOM to use SQL Server native
auth to DW (by setting the account above to non-empty account).
--
Vitaly Filimonov [MSFT]
-------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Post by Mark
Hi
Thanks for the reply.
I did all that, everything matches. We now get erros saying that the login
is not associated with a trusted sql server connection. The user is a domain
account, and I set the sql authentication to windows only. the use has dbo
access to the database.
regards
--
Mark

Mark

2007-07-10 08:44:02 UTC

Permalink

Thankyou very much.

That fixed the problem.

Regards
--
Mark

Post by Vitaly Filimonov [MSFT]
1) Open console and switch to the "Administration" tab;
2) Click on Run-As Accounts and double click "Data Warehouse SQL Server
Authentication Account"
3) Switch to the Account tab and confirm the account name is single space (I
suspect it is not - if that's the case, set it to single space)
4) Check the account is associated to same-name profile (on the "Run As
Profile" tab)
What I think is hapenning, you have instructed SCOM to use SQL Server native
auth to DW (by setting the account above to non-empty account).
--
Vitaly Filimonov [MSFT]
-------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Thresa Ellis

2010-09-01 18:18:39 UTC

Permalink

What type of authentication should the Data Warehouse SQL Server Authentication Account be using? I have set the name to a single space, using simple authentication but I am still having the same problem.

Thank you,

Post by Mark
Hi
Tried that already. Got invalid login erros on sql with sdk service account.
The account is a domain account.
--
Mark

Post by Mark
Thankyou very much.
That fixed the problem.
Regards
--
Mark
Submitted via EggHeadCafe - Software Developer Portal of Choice
A Comparison of Managed Compression Algorithms
http://www.eggheadcafe.com/tutorials/aspnet/71485ecc-2d2d-435a-9c35-3d12b279f9ae/a-comparison-of-managed-compression-algorithms.aspx