Scarlett20
asked on
Changing SSRS rendering - problem changing the “rsreportserver.config” file
I'm running SQL 2005 SSRS and am trying to correct report rendering to PDF in landscape. I've found a post in SQL Safety that 'kinda' shows how to change the “rsreportserver.config” file. It seems simple enough, but I probably have some syntax errors going on here. The first portion is just renaming the existing 'PDF' to 'PDF Portrait'. The second is 'PDF Landscape' - it explicitly changes page height and width to landscape. Not only does this not work, it also causes an error when I try choosing a Machine Name Instance in "Reporting Services Configuration Manager".
Here is my code:
<Extension Name="PDF Portrait" Type="Microsoft.ReportingS ervices.Re ndering.Im ageRendere r.PdfRepor t,
Microsoft.ReportingService s.ImageRen dering"
<OverrideNames>
<Name Language="en-US">PDF Portrait</Name>
</OverrideNames>
</Extension>
<Extension Name="PDF Landscape" Type="Microsoft.ReportingS ervices.Re ndering.Im ageRendere r.PdfRepor t,
Microsoft.ReportingService s.ImageRen dering"
<OverrideNames>
<Name Language="en-US">PDF Landscape</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>PDF</OutputF ormat>
<Pageheight>8.5in</PageHei ght>
<PageWidth>11in</PageWidth >
</DeviceInfo>
</Configuration>
</Extension>
Here is my code:
<Extension Name="PDF Portrait" Type="Microsoft.ReportingS
Microsoft.ReportingService
<OverrideNames>
<Name Language="en-US">PDF Portrait</Name>
</OverrideNames>
</Extension>
<Extension Name="PDF Landscape" Type="Microsoft.ReportingS
Microsoft.ReportingService
<OverrideNames>
<Name Language="en-US">PDF Landscape</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>PDF</OutputF
<Pageheight>8.5in</PageHei
<PageWidth>11in</PageWidth
</DeviceInfo>
</Configuration>
</Extension>
ASKER
Hello TempDBA - thanks but I do not understand. The only difference between my original code and yours is the > following ...ImageRendering > (in both locations)
I tried again with these two changes but again I receive msg "An unknown error has occured in the WMI provider error code 80040219".
Please explain when you say "Try with putting tags for both of them".
Thanks so much, I appreciate your help. Scarlett
I tried again with these two changes but again I receive msg "An unknown error has occured in the WMI provider error code 80040219".
Please explain when you say "Try with putting tags for both of them".
Thanks so much, I appreciate your help. Scarlett
I did that because sometime it couldn't figure out the references when provided in one instance and not in other. Anyway as you said, it is not the issue here.
Can you check what other error you are getting along with that in the even manager? That should help us getting in the correct direction. And did you made any other changes that the rendering one, like moving of some stuffs here there or upgrading the edition...
Can you check what other error you are getting along with that in the even manager? That should help us getting in the correct direction. And did you made any other changes that the rendering one, like moving of some stuffs here there or upgrading the edition...
ASKER
Hi TempDBA - went into event viewer and found this msg:
The 'Pageheight' start tag on line 138 does not match the end tag of 'PageHeight'.
Line 139, position 15.
I'm not familiar with xml so I still cannot see what the problem is. Here is my code again.
<Extension Name="PDF Landscape" Type="Microsoft.ReportingS ervices.Re ndering.Im ageRendere r.PdfRepor t,
Microsoft.ReportingService s.ImageRen dering">
<OverrideNames>
<Name Language="en-US">PDF Landscape</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>PDF</OutputF ormat>
<Pageheight>8.5in</PageHei ght>
<PageWidth>11in</PageWidth >
</DeviceInfo>
</Configuration>
</Extension>
The 'Pageheight' start tag on line 138 does not match the end tag of 'PageHeight'.
Line 139, position 15.
I'm not familiar with xml so I still cannot see what the problem is. Here is my code again.
<Extension Name="PDF Landscape" Type="Microsoft.ReportingS
Microsoft.ReportingService
<OverrideNames>
<Name Language="en-US">PDF Landscape</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>PDF</OutputF
<Pageheight>8.5in</PageHei
<PageWidth>11in</PageWidth
</DeviceInfo>
</Configuration>
</Extension>
So thats all what it is... You replied urself..
<Pageheight>8.5in</PageHei ght>
the starting tag is "height" whereas the ending tag is "Height".
xml tags are case sensitive.. change it.
<Pageheight>8.5in</PageHei
the starting tag is "height" whereas the ending tag is "Height".
xml tags are case sensitive.. change it.
ASKER
So I changed it, and now no errors occur when going into Reporting Services Configuration Manager. I stopped/restarted the report server service, but I do not get 'PDF Portrait' and 'PDF Landscape' as export options in Report Manager. The only export option is for "Acrobat (PDF) file" - same as before.
Any ideas? I've been assuming all along that this could be fixed - perhaps I've been delusional!
Any ideas? I've been assuming all along that this could be fixed - perhaps I've been delusional!
I tried and its working for me.. It shouldn't make difference but would you mind pasting my code in the configuration manager?
ASKER
I pasted your code - and am now receiving this error. Here's the log file (says "name element is missing") followed by the entire config file.
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportSe rverServic e__main_09 _19_2011_1 0_59_38.lo g</Path>
<SystemName>DW01</SystemNa me>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072 </OSVersio n>
</Header>
ReportingServicesService!l ibrary!4!9 /19/2011-1 0:59:38:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!l ibrary!4!9 /19/2011-1 0:59:38:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!l ibrary!4!9 /19/2011-1 0:59:38:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!l ibrary!4!9 /19/2011-1 0:59:38:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!l ibrary!4!9 /19/2011-1 0:59:38:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!l ibrary!4!9 /19/2011-1 0:59:38:: i INFO: Initializing WindowsServiceUseFileShare Storage to 'False' as specified in Configuration file.
ReportingServicesService!l ibrary!4!9 /19/2011-1 0:59:38:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!l ibrary!4!9 /19/2011-1 0:59:38:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!l ibrary!4!9 /19/2011-1 0:59:38:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!l ibrary!4!9 /19/2011-1 0:59:38:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!l ibrary!4!9 /19/2011-1 0:59:38:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!l ibrary!4!9 /19/2011-1 0:59:38:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!d iagnostic! 4!9/19/201 1-10:59:38 :: Error loading configuration file: An error occurred while parsing the configuration file. The Name element is missing.
ReportingServicesService!l ibrary!4!9 /19/2011-1 0:59:38:: e ERROR: Throwing Microsoft.ReportingService s.Diagnost ics.Utilit ies.Server Configurat ionErrorEx ception: The report server has encountered a configuration error. See the report server log files for more information., ;
Info: Microsoft.ReportingService s.Diagnost ics.Utilit ies.Server Configurat ionErrorEx ception: The report server has encountered a configuration error. See the report server log files for more information. ---> System.Exception: An error occurred while parsing the configuration file. The Name element is missing.
at Microsoft.ReportingService s.Diagnost ics.RSConf iguration. ThrowEleme ntMissing( String element)
at Microsoft.ReportingService s.Diagnost ics.Extens ionsConfig uration.Pa rseExtensi onElement( XmlNode child, Extension& extension, String childName)
at Microsoft.ReportingService s.Diagnost ics.Extens ionsConfig uration.Pa rseRenderE xtensions( XmlNode child, ExtensionArray array)
at Microsoft.ReportingService s.Diagnost ics.Extens ionsConfig uration.Pa rseExtensi ons(XmlNod e child, ExtensionArray array)
at Microsoft.ReportingService s.Diagnost ics.Extens ionsConfig uration.Pa rseXML(Xml Node node)
at Microsoft.ReportingService s.Diagnost ics.RSConf iguration. ParseDocum ent()
at Microsoft.ReportingService s.Diagnost ics.RSConf iguration. Load()
--- End of inner exception stack trace ---
*************** config file ************************** **
<Configuration>
<Dsn>
AQAAANCMnd8BFdERjHoAwE/Cl+ sBAAAABkf3 usg7zUSA6M rNMwIGrgQA AAAiAAAAUg BlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AG UAcgAAAANm AACoAAAAEA AAAO2N4nqc JQ13fMZkE6 7Qu4gAAAAA
BIAAAKAAAAAQAAAAlSEF+cdXRc yr6YNnM2bq ERgBAADlcF 8pxYvrmZQG j2XGyyKx3N VbaSX3d+0w
kCR6rY1Fe7VcQHVXygOZD2ZDHJ zx2aMgi77o xsKRMo7O+3 3zD0XbzY+u BxhlqB8Dj8 v7/UeQxfEQ
JyXKSf9fNjrMEu9fHMezrJ2B05 SVgHZToUfi OUmEgpCSVO 0gWVA3r6NC kcdIm8KcyY EDvfBo8smi
zXsA6Bb89ZG7a8wxG4dU+pro0I yEYaKSWgaW 82FpyFt1PV s4fAKsKX27 Hf46//v504 fyXUVYRZZy
XhQj3PUpmSBokkPU5pxmC/TnEC BI2Zrm9Gy3 eWtRQdB+J/ r0Q1wxvSRc 5pITPwanSw WnnGyayEVT
SQgibmG94RFpXZBCYqWHg1jQTM 72IPfy0kfw FAAAAENSuZ ULSYP40he0 QKfoAncfij ZO
</Dsn>
<ConnectionType>Default</C onnectionT ype>
<LogonUser></LogonUser>
<LogonDomain></LogonDomain >
<LogonCred></LogonCred>
<InstanceId>MSSQL.3</Insta nceId>
<InstallationID>{1df1a8df- 166b-4e0a- bd4a-22b9f 29dadca}</ Installati onID>
<Add Key="SecureConnectionLevel " Value="0"/>
<Add Key="ProcessRecycleOptions " Value="0"/>
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="SQLCommandTimeoutSeco nds" Value="60"/>
<Add Key="MaxActiveReqForOneUse r" Value="20"/>
<Add Key="DatabaseQueryTimeout" Value="120"/>
<Add Key="RunningRequestsScaven gerCycle" Value="60"/>
<Add Key="RunningRequestsDbCycl e" Value="60"/>
<Add Key="RunningRequestsAge" Value="30"/>
<Add Key="MaxScheduleWait" Value="5"/>
<Add Key="DisplayErrorLink" Value="true"/>
<Add Key="WebServiceUseFileShar eStorage" Value="false"/>
<!-- <Add Key="WatsonFlags" Value="0x0430" /> full dump-->
<!-- <Add Key="WatsonFlags" Value="0x0428" /> minidump -->
<!-- <Add Key="WatsonFlags" Value="0x0002" /> no dump-->
<Add Key="WatsonFlags" Value="0x0428"/>
<Add Key="WatsonDumpOnException s" Value="Microsoft.Reporting Services.D iagnostics .Utilities .InternalC atalogExce ption,Micr osoft.Repo rtingServi ces.Modeli ng.Interna lModelingE xception"/ >
<Add Key="WatsonDumpExcludeIfCo ntainsExce ptions" Value="System.Data.SqlClie nt.SqlExce ption,Syst em.Threadi ng.ThreadA bortExcept ion"/>
<Service>
<IsSchedulingService>True< /IsSchedul ingService >
<IsNotificationService>Tru e</IsNotif icationSer vice>
<IsEventService>True</IsEv entService >
<PollingInterval>10</Polli ngInterval >
<WindowsServiceUseFileShar eStorage>F alse</Wind owsService UseFileSha reStorage>
<MemoryLimit>60</MemoryLim it>
<RecycleTime>720</RecycleT ime>
<MaximumMemoryLimit>80</Ma ximumMemor yLimit>
<MaxAppDomainUnloadTime>30 </MaxAppDo mainUnload Time>
<MaxQueueThreads>0</MaxQue ueThreads>
<UrlRoot>http://dw01/reportserver</UrlRoot>
<UnattendedExecutionAccoun t>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccou nt>
<PolicyLevel>rssrvpolicy.c onfig</Pol icyLevel>
<WebServiceAccount>NT Authority\NetworkService</ WebService Account>
<IsWebServiceEnabled>True< /IsWebServ iceEnabled >
<FileShareStorageLocation>
<Path></Path>
</FileShareStorageLocation >
</Service>
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare" Type="Microsoft.ReportingS ervices.Fi leShareDel iveryProvi der.FileSh areProvide r,Reportin gServicesF ileShareDe liveryProv ider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</S econdsBefo reRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOW C</Renderi ngExtensio n>
<RenderingExtension>NULL</ RenderingE xtension>
<RenderingExtension>RGDI</ RenderingE xtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email" Type="Microsoft.ReportingS ervices.Em ailDeliver yProvider. EmailProvi der,Report ingService sEmailDeli veryProvid er">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</S econdsBefo reRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>10.1.1.7</SMTP Server>
<SMTPServerPort></SMTPServ erPort>
<SMTPAccountName></SMTPAcc ountName>
<SMTPConnectionTimeout></S MTPConnect ionTimeout >
<SMTPServerPickupDirectory >C:\Inetpu b\mailroot \Pickup</S MTPServerP ickupDirec tory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate></SMTPAu thenticate >
<From>Report Server<reports@ppsne.or g></Fro m>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML< /Rendering Extension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderForma ts></Privi legedUserR enderForma ts>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOW C</Renderi ngExtensio n>
<RenderingExtension>NULL</ RenderingE xtension>
<RenderingExtension>RGDI</ RenderingE xtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True </SendEmai lToUserAli as>
<DefaultHostName></Default HostName>
<PermittedHosts></Permitte dHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL" Type="Microsoft.ReportingS ervices.Nu llDelivery Provider.N ullProvide r,Reportin gServicesN ullDeliver yProvider" />
<Extension Name="Report Server DocumentLibrary" Type="Microsoft.ReportingS ervices.Sh arePoint.S harePointD eliveryExt ension.Doc umentLibra ryProvider ,Reporting ServicesSh arePointDe liveryExte nsion">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</S econdsBefo reRetry>
<Configuration>
<DocumentLibraryConfigurat ion>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOW C</Renderi ngExtensio n>
<RenderingExtension>NULL</ RenderingE xtension>
<RenderingExtension>RGDI</ RenderingE xtension>
</ExcludedRenderFormats>
</DocumentLibraryConfigura tion>
</Configuration>
</Extension>
</Delivery>
<Render>
<Extension Name="XML" Type="Microsoft.ReportingS ervices.Re ndering.Xm lDataRende rer.XmlDat aReport,Mi crosoft.Re portingSer vices.XmlR endering"/ >
<Extension Name="NULL" Type="Microsoft.ReportingS ervices.Re ndering.Nu llRenderer .NullRepor t,Microsof t.Reportin gServices. NullRender ing" Visible="false"/>
<Extension Name="CSV" Type="Microsoft.ReportingS ervices.Re ndering.Cs vRenderer. CsvReport, Microsoft. ReportingS ervices.Cs vRendering "/>
<Extension Name="IMAGE" Type="Microsoft.ReportingS ervices.Re ndering.Im ageRendere r.ImageRep ort,Micros oft.Report ingService s.ImageRen dering"/>
<Extension NAME = "PDF Landscape" TYPE = "Microsoft.ReportingServic es.Renderi ng.ImageRe nderer.Pdf Report,Mic rosoft.Rep ortingServ ices.Image Rendering" >
<OverrideNames>
<NAME LANGUAGE = "en-US">PDF Landscape</NAME>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>PDF</OutputF ormat>
<PageHeight>8.27in</PageHe ight>
<PageWidth>11.69in </PageWidth>
</DeviceInfo>
</Configuration>
</Extension>
<Extension NAME = "PDF Portrait" TYPE = "Microsoft.ReportingServic es.Renderi ng.ImageRe nderer.Pdf Report,Mic rosoft.Rep ortingServ ices.Image Rendering" >
<OverrideNames>
<NAME LANGUAGE = "en-US">PDF Portrait</NAME>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>PDF</OutputF ormat>
<PageHeight>11.69in </PageHeight>
<PageWidth>8.27in </PageWidth>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="RGDI" Type="Microsoft.ReportingS ervices.Re ndering.Im ageRendere r.RemoteGd iReport,Mi crosoft.Re portingSer vices.Imag eRendering " Visible="false" LogAllExecutionRequests="f alse"/>
<Extension Name="HTML4.0" Type="Microsoft.ReportingS ervices.Re ndering.Ht mlRenderer .Html40Ren deringExte nsion,Micr osoft.Repo rtingServi ces.HtmlRe ndering" Visible="false" LogAllExecutionRequests="f alse"/>
<Extension Name="HTML3.2" Type="Microsoft.ReportingS ervices.Re ndering.Ht mlRenderer .Html32Ren deringExte nsion,Micr osoft.Repo rtingServi ces.HtmlRe ndering" Visible="false"/>
<Extension Name="MHTML" Type="Microsoft.ReportingS ervices.Re ndering.Ht mlRenderer .MHtmlRend eringExten sion,Micro soft.Repor tingServic es.HtmlRen dering"/>
<Extension Name="EXCEL" Type="Microsoft.ReportingS ervices.Re ndering.Ex celRendere r.ExcelRen derer,Micr osoft.Repo rtingServi ces.ExcelR endering"/ >
</Render>
<Data>
<Extension Name="SQL" Type="Microsoft.ReportingS ervices.Da taExtensio ns.SqlConn ectionWrap per,Micros oft.Report ingService s.DataExte nsions"/>
<Extension Name="OLEDB" Type="Microsoft.ReportingS ervices.Da taExtensio ns.OleDbCo nnectionWr apper,Micr osoft.Repo rtingServi ces.DataEx tensions"/ >
<Extension Name="OLEDB-MD" Type="Microsoft.ReportingS ervices.Da taExtensio ns.AdoMdCo nnection,M icrosoft.R eportingSe rvices.Dat aExtension s"/>
<Extension Name="ORACLE" Type="Microsoft.ReportingS ervices.Da taExtensio ns.OracleC lientConne ctionWrapp er,Microso ft.Reporti ngServices .DataExten sions"/>
<Extension Name="ODBC" Type="Microsoft.ReportingS ervices.Da taExtensio ns.OdbcCon nectionWra pper,Micro soft.Repor tingServic es.DataExt ensions"/>
<Extension Name="XML" Type="Microsoft.ReportingS ervices.Da taExtensio ns.XmlDPCo nnection,M icrosoft.R eportingSe rvices.Dat aExtension s"/>
<Extension Name="SAPBW" Type="Microsoft.ReportingS ervices.Da taExtensio ns.SapBw.S apBwConnec tion,Micro soft.Repor tingServic es.DataExt ensions.Sa pBw"/>
<Extension Name="ESSBASE" Type="Microsoft.ReportingS ervices.Da taExtensio ns.Essbase .EssbaseCo nnection,M icrosoft.R eportingSe rvices.Dat aExtension s.Essbase" />
<!-- <Extension Name="SSIS" Type="Microsoft.SqlServer. Dts.DtsCli ent.DtsCon nection,Mi crosoft.Sq lServer.Dt s.DtsClien t, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd808 0cc91"/> -->
<!-- <Extension Name="SAP" Type="Microsoft.Adapter.SA P.SAPConne ction,Micr osoft.Adap ter.SAP.SA PProvider, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad3 64e35"/> -->
</Data>
<SemanticQuery>
<Extension Name="SQL" Type="Microsoft.ReportingS ervices.Se manticQuer yEngine.Sq l.MSSQL.MS SqlSQComma nd,Microso ft.Reporti ngServices .SemanticQ ueryEngine ">
<Configuration>
<EnableMathOpCasting>False </EnableMa thOpCastin g>
</Configuration>
</Extension>
<Extension Name="ORACLE" Type="Microsoft.ReportingS ervices.Se manticQuer yEngine.Sq l.Oracle.O raSqlSQCom mand,Micro soft.Repor tingServic es.Semanti cQueryEngi ne">
<Configuration>
<EnableMathOpCasting>True< /EnableMat hOpCasting >
<DisableNO_MERGEInLeftOute rs>False</ DisableNO_ MERGEInLef tOuters>
<EnableUnistr>False</Enabl eUnistr>
<DisableTSTruncation>False </DisableT STruncatio n>
</Configuration>
</Extension>
<Extension Name="OLEDB-MD" Type="Microsoft.AnalysisSe rvices.Mod eling.Quer yExecution .ASSemanti cQueryComm and,Micros oft.Analys isServices .Modeling" />
</SemanticQuery>
<ModelGeneration>
<Extension Name="SQL" Type="Microsoft.ReportingS ervices.Se manticQuer yEngine.Sq l.MSSQL.Ms SqlModelGe nerator,Mi crosoft.Re portingSer vices.Sema nticQueryE ngine"/>
<Extension Name="ORACLE" Type="Microsoft.ReportingS ervices.Se manticQuer yEngine.Sq l.Oracle.O raSqlModel Generator, Microsoft. ReportingS ervices.Se manticQuer yEngine"/>
<Extension Name="OLEDB-MD" Type="Microsoft.AnalysisSe rvices.Mod eling.Gene ration.Mod elGenerato rExtention ,Microsoft .AnalysisS ervices.Mo deling"/>
</ModelGeneration>
<Security>
<Extension Name="Windows" Type="Microsoft.ReportingS ervices.Au thorizatio n.WindowsA uthorizati on, Microsoft.ReportingService s.Authoriz ation"/>
</Security>
<Authentication>
<Extension Name="Windows" Type="Microsoft.ReportingS ervices.Au thenticati on.Windows Authentica tion, Microsoft.ReportingService s.Authoriz ation"/>
</Authentication>
<EventProcessing>
<Extension Name="SnapShot Extension" Type="Microsoft.ReportingS ervices.Li brary.Hist orySnapSho tCreatedHa ndler,Repo rtingServi cesLibrary ">
<Event>
<Type>ReportHistorySnapsho tCreated</ Type>
</Event>
</Extension>
<Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingS ervices.Li brary.Time dSubscript ionHandler ,Reporting ServicesLi brary">
<Event>
<Type>TimedSubscription</T ype>
</Event>
</Extension>
<Extension Name="Cache Update Extension" Type="Microsoft.ReportingS ervices.Li brary.Repo rtExecutio nSnapshotU pdateEvent Handler,Re portingSer vicesLibra ry">
<Event>
<Type>SnapshotUpdated</Typ e>
</Event>
</Extension>
</EventProcessing>
</Extensions>
</Configuration>
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.4035.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportSe
<SystemName>DW01</SystemNa
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072
</Header>
ReportingServicesService!l
ReportingServicesService!l
ReportingServicesService!l
ReportingServicesService!l
ReportingServicesService!l
ReportingServicesService!l
ReportingServicesService!l
ReportingServicesService!l
ReportingServicesService!l
ReportingServicesService!l
ReportingServicesService!l
ReportingServicesService!l
ReportingServicesService!d
ReportingServicesService!l
Info: Microsoft.ReportingService
at Microsoft.ReportingService
at Microsoft.ReportingService
at Microsoft.ReportingService
at Microsoft.ReportingService
at Microsoft.ReportingService
at Microsoft.ReportingService
at Microsoft.ReportingService
--- End of inner exception stack trace ---
*************** config file **************************
<Configuration>
<Dsn>
AQAAANCMnd8BFdERjHoAwE/Cl+
AHQAaQBuAGcAIABTAGUAcgB2AG
BIAAAKAAAAAQAAAAlSEF+cdXRc
kCR6rY1Fe7VcQHVXygOZD2ZDHJ
JyXKSf9fNjrMEu9fHMezrJ2B05
zXsA6Bb89ZG7a8wxG4dU+pro0I
XhQj3PUpmSBokkPU5pxmC/TnEC
SQgibmG94RFpXZBCYqWHg1jQTM
</Dsn>
<ConnectionType>Default</C
<LogonUser></LogonUser>
<LogonDomain></LogonDomain
<LogonCred></LogonCred>
<InstanceId>MSSQL.3</Insta
<InstallationID>{1df1a8df-
<Add Key="SecureConnectionLevel
<Add Key="ProcessRecycleOptions
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="SQLCommandTimeoutSeco
<Add Key="MaxActiveReqForOneUse
<Add Key="DatabaseQueryTimeout"
<Add Key="RunningRequestsScaven
<Add Key="RunningRequestsDbCycl
<Add Key="RunningRequestsAge" Value="30"/>
<Add Key="MaxScheduleWait" Value="5"/>
<Add Key="DisplayErrorLink" Value="true"/>
<Add Key="WebServiceUseFileShar
<!-- <Add Key="WatsonFlags" Value="0x0430" /> full dump-->
<!-- <Add Key="WatsonFlags" Value="0x0428" /> minidump -->
<!-- <Add Key="WatsonFlags" Value="0x0002" /> no dump-->
<Add Key="WatsonFlags" Value="0x0428"/>
<Add Key="WatsonDumpOnException
<Add Key="WatsonDumpExcludeIfCo
<Service>
<IsSchedulingService>True<
<IsNotificationService>Tru
<IsEventService>True</IsEv
<PollingInterval>10</Polli
<WindowsServiceUseFileShar
<MemoryLimit>60</MemoryLim
<RecycleTime>720</RecycleT
<MaximumMemoryLimit>80</Ma
<MaxAppDomainUnloadTime>30
<MaxQueueThreads>0</MaxQue
<UrlRoot>http://dw01/reportserver</UrlRoot>
<UnattendedExecutionAccoun
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccou
<PolicyLevel>rssrvpolicy.c
<WebServiceAccount>NT Authority\NetworkService</
<IsWebServiceEnabled>True<
<FileShareStorageLocation>
<Path></Path>
</FileShareStorageLocation
</Service>
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare" Type="Microsoft.ReportingS
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</S
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOW
<RenderingExtension>NULL</
<RenderingExtension>RGDI</
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email" Type="Microsoft.ReportingS
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</S
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>10.1.1.7</SMTP
<SMTPServerPort></SMTPServ
<SMTPAccountName></SMTPAcc
<SMTPConnectionTimeout></S
<SMTPServerPickupDirectory
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate></SMTPAu
<From>Report Server<reports@ppsne.or
<EmbeddedRenderFormats>
<RenderingExtension>MHTML<
</EmbeddedRenderFormats>
<PrivilegedUserRenderForma
<ExcludedRenderFormats>
<RenderingExtension>HTMLOW
<RenderingExtension>NULL</
<RenderingExtension>RGDI</
</ExcludedRenderFormats>
<SendEmailToUserAlias>True
<DefaultHostName></Default
<PermittedHosts></Permitte
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL" Type="Microsoft.ReportingS
<Extension Name="Report Server DocumentLibrary" Type="Microsoft.ReportingS
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</S
<Configuration>
<DocumentLibraryConfigurat
<ExcludedRenderFormats>
<RenderingExtension>HTMLOW
<RenderingExtension>NULL</
<RenderingExtension>RGDI</
</ExcludedRenderFormats>
</DocumentLibraryConfigura
</Configuration>
</Extension>
</Delivery>
<Render>
<Extension Name="XML" Type="Microsoft.ReportingS
<Extension Name="NULL" Type="Microsoft.ReportingS
<Extension Name="CSV" Type="Microsoft.ReportingS
<Extension Name="IMAGE" Type="Microsoft.ReportingS
<Extension NAME = "PDF Landscape" TYPE = "Microsoft.ReportingServic
<OverrideNames>
<NAME LANGUAGE = "en-US">PDF Landscape</NAME>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>PDF</OutputF
<PageHeight>8.27in</PageHe
<PageWidth>11.69in </PageWidth>
</DeviceInfo>
</Configuration>
</Extension>
<Extension NAME = "PDF Portrait" TYPE = "Microsoft.ReportingServic
<OverrideNames>
<NAME LANGUAGE = "en-US">PDF Portrait</NAME>
</OverrideNames>
<Configuration>
<DeviceInfo>
<OutputFormat>PDF</OutputF
<PageHeight>11.69in </PageHeight>
<PageWidth>8.27in </PageWidth>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="RGDI" Type="Microsoft.ReportingS
<Extension Name="HTML4.0" Type="Microsoft.ReportingS
<Extension Name="HTML3.2" Type="Microsoft.ReportingS
<Extension Name="MHTML" Type="Microsoft.ReportingS
<Extension Name="EXCEL" Type="Microsoft.ReportingS
</Render>
<Data>
<Extension Name="SQL" Type="Microsoft.ReportingS
<Extension Name="OLEDB" Type="Microsoft.ReportingS
<Extension Name="OLEDB-MD" Type="Microsoft.ReportingS
<Extension Name="ORACLE" Type="Microsoft.ReportingS
<Extension Name="ODBC" Type="Microsoft.ReportingS
<Extension Name="XML" Type="Microsoft.ReportingS
<Extension Name="SAPBW" Type="Microsoft.ReportingS
<Extension Name="ESSBASE" Type="Microsoft.ReportingS
<!-- <Extension Name="SSIS" Type="Microsoft.SqlServer.
<!-- <Extension Name="SAP" Type="Microsoft.Adapter.SA
</Data>
<SemanticQuery>
<Extension Name="SQL" Type="Microsoft.ReportingS
<Configuration>
<EnableMathOpCasting>False
</Configuration>
</Extension>
<Extension Name="ORACLE" Type="Microsoft.ReportingS
<Configuration>
<EnableMathOpCasting>True<
<DisableNO_MERGEInLeftOute
<EnableUnistr>False</Enabl
<DisableTSTruncation>False
</Configuration>
</Extension>
<Extension Name="OLEDB-MD" Type="Microsoft.AnalysisSe
</SemanticQuery>
<ModelGeneration>
<Extension Name="SQL" Type="Microsoft.ReportingS
<Extension Name="ORACLE" Type="Microsoft.ReportingS
<Extension Name="OLEDB-MD" Type="Microsoft.AnalysisSe
</ModelGeneration>
<Security>
<Extension Name="Windows" Type="Microsoft.ReportingS
</Security>
<Authentication>
<Extension Name="Windows" Type="Microsoft.ReportingS
</Authentication>
<EventProcessing>
<Extension Name="SnapShot Extension" Type="Microsoft.ReportingS
<Event>
<Type>ReportHistorySnapsho
</Event>
</Extension>
<Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingS
<Event>
<Type>TimedSubscription</T
</Event>
</Extension>
<Extension Name="Cache Update Extension" Type="Microsoft.ReportingS
<Event>
<Type>SnapshotUpdated</Typ
</Event>
</Extension>
</EventProcessing>
</Extensions>
</Configuration>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
< Extension NAME = "PDF Landscape" TYPE =
"Microsoft.ReportingServic
< OverrideNames >
< NAME LANGUAGE = "en-US" > PDF Landscape< / NAME >
< / OverrideNames >
< Configuration >
< DeviceInfo >
< OutputFormat > PDF < / OutputFormat >
< PageHeight > 8.27in < / PageHeight >
< PageWidth > 11.69in < / PageWidth >
< / DeviceInfo >
< / Configuration >
< / Extension >
< Extension NAME = "PDF Portrait" TYPE =
"Microsoft.ReportingServic
< OverrideNames >
< NAME LANGUAGE = "en-US" > PDF Portrait< / NAME >
< / OverrideNames >
< Configuration >
< DeviceInfo >
< OutputFormat > PDF < / OutputFormat >
< PageHeight > 11.69in < / PageHeight >
< PageWidth > 8.27in < / PageWidth >
< / DeviceInfo >
< / Configuration >
< / Extension >