Have lost the facility to select a Report Model DataSource Type?

I am trying to create a report from a Report Model, but when I try to select
the Datasource Type I find the Report Model DataSource Type is no longer
available to select. It definitely used to be there.
I have recently been experimenting with the Custom Report Items and modified
the configs etc as per instructions. The Polygons example appeared to work
eventually but at around the same time as experimenting with that, the Report
Model DataSource Type dissapeared. I have restored the config files back to
what they were, but still lost my DataSource Types. I suspect the only real
answer is to reinstall, however, I need to understand how to fix, and how I
have broken it. Where are the datasource types drop downs picked from? and
how best to fix this without reinstall. Any experts out there please help!Unsure how on earth lost the Report Model DataSource Type and the only way I
could find of restoring it was to uninstall all of SQL and reinstall it
again. Lost my Report Server Database, since cannot be restored.
Custom Report Items Health warning - tread carefully... suspect the
RSReportDesigner.config was the one that was clobbered in the process -
losing the RS Data extension. Unclear if it could be recreated somehow
without all this pain. Maybe a repair facility on Business Intelligence
Studio WOULD HAVE HELPED!
"Steve Giergiel" wrote:
> I am trying to create a report from a Report Model, but when I try to select
> the Datasource Type I find the Report Model DataSource Type is no longer
> available to select. It definitely used to be there.
> I have recently been experimenting with the Custom Report Items and modified
> the configs etc as per instructions. The Polygons example appeared to work
> eventually but at around the same time as experimenting with that, the Report
> Model DataSource Type dissapeared. I have restored the config files back to
> what they were, but still lost my DataSource Types. I suspect the only real
> answer is to reinstall, however, I need to understand how to fix, and how I
> have broken it. Where are the datasource types drop downs picked from? and
> how best to fix this without reinstall. Any experts out there please help!

Has anyone used Security Filters?

Dear Anyone,

Has anyone here have ever actually used the Security Filters of a report model? Can you please direct us to some more articles or maybe samples of the subject. The ones that are in Books Online are somewhat limited and does not have any samples.

Thanks,

Joseph

I think Security Filters would be the subject of a great article or FAQ/Wiki/whatever. For me, it causes endless confusion and angst when trying to create report models...not to mention the fact that there is also Model Item Security available within the Management Studio.|||

I will be posting on my blog shortly on this topic.

http://blogs.msdn.com/bobmeyers

|||Your the man BOB!!! |||

FYI: there is a known bug in security filters which will be fixed in Yukon SP1.

|||Any details about that bug? Is it already in the support site?sql

Hardware Failure, Help w/recover of the msdb database

We lost the hard drive on a dev server. All the databases where backed up
with the exception of Master, Model, and MSDB. I was able to recover the
msdbdata.mdf and msdblog.ldf from the hard drive the crashed.
Is it possible to recover the DTS packages from these files? or am I hosed?
Any help would be greatly appreciated.
Thanks
Kevin
You should be able to attach the old MSDB back to the server.
http://www.databasejournal.com/featu...le.php/3379901
http://www.support.microsoft.com/?id=224071
Andrew J. Kelly SQL MVP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:0C69CE35-574E-49D5-810E-06854EE51460@.microsoft.com...
> We lost the hard drive on a dev server. All the databases where backed up
> with the exception of Master, Model, and MSDB. I was able to recover the
> msdbdata.mdf and msdblog.ldf from the hard drive the crashed.
> Is it possible to recover the DTS packages from these files? or am I
> hosed?
> Any help would be greatly appreciated.
> Thanks
> Kevin

Hardware Failure, Help w/recover of the msdb database

We lost the hard drive on a dev server. All the databases where backed up
with the exception of Master, Model, and MSDB. I was able to recover the
msdbdata.mdf and msdblog.ldf from the hard drive the crashed.
Is it possible to recover the DTS packages from these files? or am I hosed?
Any help would be greatly appreciated.
Thanks
KevinYou should be able to attach the old MSDB back to the server.
http://www.databasejournal.com/features/mssql/article.php/3379901
http://www.support.microsoft.com/?id=224071
--
Andrew J. Kelly SQL MVP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:0C69CE35-574E-49D5-810E-06854EE51460@.microsoft.com...
> We lost the hard drive on a dev server. All the databases where backed up
> with the exception of Master, Model, and MSDB. I was able to recover the
> msdbdata.mdf and msdblog.ldf from the hard drive the crashed.
> Is it possible to recover the DTS packages from these files? or am I
> hosed?
> Any help would be greatly appreciated.
> Thanks
> Kevin

Hardware Failure, Help w/recover of the msdb database

We lost the hard drive on a dev server. All the databases where backed up
with the exception of Master, Model, and MSDB. I was able to recover the
msdbdata.mdf and msdblog.ldf from the hard drive the crashed.
Is it possible to recover the DTS packages from these files? or am I hosed?
Any help would be greatly appreciated.
Thanks
KevinYou should be able to attach the old MSDB back to the server.
http://www.databasejournal.com/feat...cle.php/3379901
http://www.support.microsoft.com/?id=224071
Andrew J. Kelly SQL MVP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:0C69CE35-574E-49D5-810E-06854EE51460@.microsoft.com...
> We lost the hard drive on a dev server. All the databases where backed up
> with the exception of Master, Model, and MSDB. I was able to recover the
> msdbdata.mdf and msdblog.ldf from the hard drive the crashed.
> Is it possible to recover the DTS packages from these files? or am I
> hosed?
> Any help would be greatly appreciated.
> Thanks
> Kevin