Well I've learned the hard way about deleting encrypted content and now that I've done it, and recovered, here is the synopsis for recovery.
1. Recreate the connection string as described by Eugene.
2. Reset the Permissions in the Home Folder.
a. {597F9D98-356F-4186-8712-4F020F2D98B4} Checked Checked Checked Checked Checked
b. {2537B367-6D74-4110-B0B5-1F51C1B1B09E} Checked Unchecked Checked Unchecked Checked
3. Reset the individual DataSources in each report that are not linked to DataWarehouseMain, e.g. DataWarehouseAlert, DataWarehousePerf..., so that they do not require credentials.
Now if anyone can script #3 that would be great but if not a little clickity clicking will eventually get you there.
Eugene Bykov [MSFT] wrote:
Hi Dan,You can try "reanimating" SSRS instance using ResetSRS.
09-Jul-07
Hi Dan,
You can try "reanimating" SSRS instance using ResetSRS.exe support tool
shipped with SCOM. (SupportTools directory on CD).
--
Eugene Bykov [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
"Dan Sikorski" <***@discussions.microsoft.com> wrote in message news:2F627514-997C-4D65-A49F-***@microsoft.com...
Previous Posts In This Thread:
On Tuesday, June 19, 2007 2:53 PM
Ida wrote:
Opsmgr 2007 reports problems
Hello,
1.
In MOM 2005 there was report "Software and Application installations under
Microsoft Windows Base Operating System, is any one know where this report in
Opsmgr 2007 ?
2.
When I click on report in the Opsmgr I'm getting error message
Value cannot be null, parameter name: GroupList
Thanks
Idan
On Tuesday, June 26, 2007 2:10 PM
Eugene Bykov [MSFT] wrote:
Hi Idan,1.
Hi Idan,
1. There is no analog of "Software and Application installations" report in
SCOM 2007 as far as I know.
2. "Value cannot be null, parameter name: GroupList" indicates that
something is wrong with your SSRS installation encrypted content. Did you
change SSRS web pool account password recently or did you do anything with
the SSRS instance directly? Try to go to the SSRS Report Manager, click
"Show Details" button in the top right corner and open properties for "Data
Warehouse Main" data source. Do you see connection string there?
--
Eugene Bykov [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
"Idan" <***@discussions.microsoft.com> wrote in message news:286AF253-2FD4-42D1-A03D-***@microsoft.com...
On Thursday, June 28, 2007 4:42 PM
Dan Sikorsk wrote:
I am having a similar problem to #2 below. My connection string box is blank.
I am having a similar problem to #2 below. My connection string box is
blank. What should be in there?
"Eugene Bykov [MSFT]" wrote:
On Thursday, June 28, 2007 8:05 PM
Eugene Bykov [MSFT] wrote:
Re: Opsmgr 2007 reports problems
Hi Dan,
The format of the connection string is:
data source=<Server Name>;initial catalog=<DW Database Name>;Integrated
Security=SSPI
Where <Server Name> is name of your DB server and <DW Database Name> is name
of your data warehouse database. You must also set "Credentials are not
required" option.
I assume that since your connection string is wiped out you most likely
deleted the encrypted content from the SSRS server and report local data
sources are also broken now. The easiest way to fix them is to redeploy all
reports. To "force" SCOM redeploying all reports remove all Management Pack
report folders from SSRS (make sure you have a backup of SSRS content just
in case).
--
Eugene Bykov [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
"Dan Sikorski" <Dan ***@discussions.microsoft.com> wrote in message news:A207F798-5E52-4D6C-BC33-***@microsoft.com...
On Monday, July 02, 2007 4:56 PM
DanSikorsk wrote:
Thanks Eugene!
Thanks Eugene!
I put that string in, deleted the reports, waited for them to be recreated,
but i'm still getting the same error when i try to run one. What do i look
at next?
"Eugene Bykov [MSFT]" wrote:
On Monday, July 09, 2007 2:10 PM
Eugene Bykov [MSFT] wrote:
Hi Dan,Go to your reporting server machine and find web.
Hi Dan,
Go to your reporting server machine and find web.config for the SSRS web
service. It is usually located under <Drive>:\Program Files\Microsoft SQL
Server\MSSQL.<N>\Reporting Services\ReportServer. Find appSettings section
in it and look for the ManagementGroupId key.
<appSettings>
<add key="ManagementGroupId" value="MG-GUID" />
</appSettings>
Grab value from this key, post it in the script bellow and run the script on
the data warehouse main database.
------------
declare @ManagementGroupGuid uniqueidentifier
declare @DatasetTypeId uniqueidentifier
declare @DatasetType table (DatasetTypeId uniqueidentifier)
set @ManagementGroupGuid = ' MG-GUID'
insert @DatasetType
exec DatasetTypeIdGet
@ManagementPackSystemName=N'Microsoft.SystemCenter.DataWarehouse.Library',
@DatasetTypeSystemName=N'Microsoft.SystemCenter.DataWarehouse.Dataset.State'
select @DatasetTypeId = DatasetTypeId FROM @DatasetType
select @DatasetTypeId as DatasetTypeId
exec DataRouteGetNeighbors @ManagementGroupGuid, @DatasetTypeId
------------
You should see valid dataset type id returned in the first record-set and
valid management group information in the second.
Let me know if this script executes okay for you.
--
Eugene Bykov [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
"Dan Sikorski" <***@discussions.microsoft.com> wrote in message news:28D53FFA-DBC5-4865-96F3-***@microsoft.com...
On Monday, July 09, 2007 3:44 PM
DanSikorsk wrote:
Well, unfortunately, this morning, before you replied, i decided to try and
Well, unfortunately, this morning, before you replied, i decided to try and
uninstall the reporting component, and reinstall it.
I am now getting an error when i try to install it, after specifying the sql
server reporting services server, i get a message that says: "Setup was
unable to validate SQL Reporting Services. Please use the Reporting Services
Configuration tool which is installed with SQL Server to validate your SQL
Reporting Services Configuration."
When i go into the Reporting Services Configuration tool, everything looks
fine.
At this point, should i just wipe the box and start over? I really don't
have much put into this at this point, so starting over wouldn't be the end
of the world to me.
-Dan
On Monday, July 09, 2007 4:35 PM
Eugene Bykov [MSFT] wrote:
Hi Dan,You can try "reanimating" SSRS instance using ResetSRS.
Hi Dan,
You can try "reanimating" SSRS instance using ResetSRS.exe support tool
shipped with SCOM. (SupportTools directory on CD).
--
Eugene Bykov [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
"Dan Sikorski" <***@discussions.microsoft.com> wrote in message news:2F627514-997C-4D65-A49F-***@microsoft.com...
EggHeadCafe - Software Developer Portal of Choice
How To Create a Custom IE8 Accelerator
http://www.eggheadcafe.com/tutorials/aspnet/8ae07577-f1c5-498b-a7da-11c3e7cc2a61/how-to-create-a-custom-ie.aspx