Showing posts with label sql2005. Show all posts
Showing posts with label sql2005. Show all posts

Wednesday, March 28, 2012

Report Web Viewer Control Error - SQL2005 September CTP

I am trying to use the Report Viewer Control in an ASPX page but getting the following error :- "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method. ". This is with the SQL Server 2005 September CTP. Is there any option that i should turn on or off?...

Thanks,
Krishna

see
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=101047&SiteID=1

I will try this tomorrowsql

Report Web Viewer Control Error - SQL2005 September CTP

I am trying to use the Report Viewer Control in an ASPX page but getting the following error :- "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method. ". This is with the SQL Server 2005 September CTP. Is there any option that i should turn on or off?...

Thanks,
Krishna

see
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=101047&SiteID=1

I will try this tomorrow

Wednesday, March 21, 2012

Report usage in SQL2005 RS

Is there a SSIS equivalent to the information in DTS package described at
http://msdn2.microsoft.com/en-us/library/aa972246(SQL.80).aspx '
If not, is it possible to install the DTS package and migrate it to SSIS?Make sure Samples are installed on your MSSQL 2005 server. Then go to:
C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Report
Samples\Server Management Sample Reports
There's a solution (Server Management Sample Reports.sln) that contains an
SSIS package and some sample reports. Read the
readme_ServerManagementReports.htm file for instructions.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"William" <William@.discussions.microsoft.com> wrote in message
news:B0511D2D-77F1-4FFC-A070-A8FE2C47C567@.microsoft.com...
> Is there a SSIS equivalent to the information in DTS package described at
> http://msdn2.microsoft.com/en-us/library/aa972246(SQL.80).aspx '
> If not, is it possible to install the DTS package and migrate it to SSIS?

Saturday, February 25, 2012

REPORT SERVER

Hi - I am trying to access the report server installed by SQL2005 for the first time and keep receiving this error message: using url -http://localhost/reports

Failed to map the path '/Reports/App_GlobalResources/

Have you gone through the configuration yet?

Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > Reporting Services Configuration

I hope this helps

Monday, February 20, 2012

Report Response Times

Have a report written in SQL2005 that has 12 parameters, 3 of which are date
pickers. The client is complaining that once clicking on the link for the
report that it takes nearly 10 seconds to open the parameter page up. Does
anybody else have any probs with this sort of thing or does anybody have an
answer as to why it would take so long for the report to open.If a report has not been run in awhile then IIS unloads reporting services.
If this is what is happening then the second time any report is opened it
will open fast.
You can set the timeout period in IIS (this is an IIS thing, not Reporting
Services per se). Reporting Services is an asp.net application.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nat Johnson" <NatJohnson@.discussions.microsoft.com> wrote in message
news:4B42CBAA-6BD5-4EAA-AE13-489E95EB6EAA@.microsoft.com...
> Have a report written in SQL2005 that has 12 parameters, 3 of which are
> date
> pickers. The client is complaining that once clicking on the link for the
> report that it takes nearly 10 seconds to open the parameter page up.
> Does
> anybody else have any probs with this sort of thing or does anybody have
> an
> answer as to why it would take so long for the report to open.