Results 1 to 2 of 2

Thread: SQL Server 2000 RS - Cluster Issue

  1. #1
    Join Date
    Nov 2002
    Location
    Birmingham UK
    Posts
    8

    SQL Server 2000 RS - Cluster Issue

    Hi All,
    I have been handed a problem regarding an old SQL 2000 RS installation. The best plan would be to upgrade, but at the moment that isnt an option, heres the problem:

    RS 2000 is installed stand alone on its own server, the RS databases are on a SQL 2000 Cluster.

    All is fine until the cluster fails over (thats another issue, but not for here!) When the cluster fails over, RS no longer connects to the databases, if we sort the issue and fail back all is fine again.

    I have looked at the RS config file and can't actually see a reference to the cluster:
    <Configuration>
    <Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAANZBOIX9EJECvPdcwjXTBkwQAAAAiAAAAUgBlAHAAb wBy
    AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAM TUZRHx0ihNWd05L1KkUp0AAAAA
    BIAAAKAAAAAQAAAAmI0QlceFJKfCTvNthmifSTgBAADzCdNWa8 GOHsJZKSXi6ZTycjm7bFTMFvP0
    Q9WUOD2ebfJp2auACdZ9iID4+v5N8Suxa1rL2AtE5T+ZrWhHYf QV+NoGu9ajck2ikriCxyuqvgJi
    tA1RmpvbIaqTJlqxpRT1YHF6PD+yXh/M7iEatpIcBdWsr3s2Zce09KK3RkZSHocHImjQgrZECGIc
    8IXdt8BNADitLlt+CKU+OvVXFH4IYtP/wJXhrAMSKB1Bctn74QLpxogxKu7kKDBbiycoRslk5Djs
    zwfT61uT4kr4wEE4uEHvP1CRm+j+WUmww9C03bxwZlxXecxrpt ilONQRQajrdvZIuSELMZQ/55Bl
    D1YTUCVhfisjBlV7ujLvUwCLTP0J6SV4D3E59LSDUvU1YDCvWg YskVx8TNW2X4iKWxekE3/qCSc3
    1HcUAAAAxVDVVfiSb5fB3kVZc6J1Ve7sVac=</Dsn>
    <ConnectionType>Default</ConnectionType>
    <LogonUser>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAANZBOIX9EJECvPdcwjXTBkwQAAAAiAAAAUgBlAHAAb wBy
    AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAC B+rN2ARcpGKhfuMvPdlzcAAAAA
    BIAAAKAAAAAQAAAA2WAYZ58zYAq7+Ak/GXpZTBAAAAC8+giHyMKdzLz5QYIx5UHtFAAAALpR8e0+
    wIccU0d7pRI7AZ7A6c6z
    </LogonUser>
    <LogonDomain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAANZBOIX9EJECvPdcwjXTBkwQAAAAiAAAAUgBlAHAAb wBy
    AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAG bgCrT77wIukOPOi9G5ODYAAAAA
    BIAAAKAAAAAQAAAAqIkXTtNwPZCU1RXW+Gi5oxAAAACT1kzcvd eS2oGHtMcJYnpdFAAAAAfwoUlM
    mXV2kJSmhQZbrrCoo6+Q
    </LogonDomain>
    <LogonCred>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAANZBOIX9EJECvPdcwjXTBkwQAAAAiAAAAUgBlAHAAb wBy
    AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAG kF2PonN0H6xR+fQ7z01D0AAAAA
    BIAAAKAAAAAQAAAAs1vcntb8uzwXGvytmJ/vFhAAAAAv2S+oLJSxoKj4Zzdjuur6FAAAAHwt91E8
    JqX39AJYGMYtH3/mn/CM
    </LogonCred>
    <InstanceId>MSSQL.1</InstanceId>
    <InstallationID>{0d6525d6-24ec-4660-a92f-e34501b198bf}</InstallationID>
    <Add Key="SecureConnectionLevel" Value="0"/>
    <Add Key="InstanceName" Value="MSSQLSERVER"/>
    <Add Key="ProcessRecycleOptions" Value="0"/>
    <Add Key="CleanupCycleMinutes" Value="10"/>
    <Add Key="SQLCommandTimeoutSeconds" Value="60"/>
    <Add Key="MaxActiveReqForOneUser" Value="20"/>
    <Add Key="DatabaseQueryTimeout" Value="120"/>
    <Add Key="RunningRequestsScavengerCycle" Value="60"/>
    <Add Key="RunningRequestsDbCycle" Value="60"/>
    <Add Key="RunningRequestsAge" Value="30"/>
    <Add Key="MaxScheduleWait" Value="5"/>
    <Add Key="DisplayErrorLink" Value="true"/>
    <Service>
    <IsSchedulingService>True</IsSchedulingService>
    <IsNotificationService>True</IsNotificationService>
    <IsEventService>True</IsEventService>
    <PollingInterval>10</PollingInterval>
    <MemoryLimit>60</MemoryLimit>
    <RecycleTime>720</RecycleTime>
    <MaximumMemoryLimit>80</MaximumMemoryLimit>
    <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
    <MaxQueueThreads>0</MaxQueueThreads>
    <UrlRoot>http://LNPERPWCW01/ReportServer</UrlRoot>
    <UnattendedExecutionAccount>
    <UserName></UserName>
    <Password></Password>
    <Domain></Domain>
    </UnattendedExecutionAccount>
    <PolicyLevel>rssrvpolicy.config</PolicyLevel>
    </Service>
    <Extensions>
    <Delivery>
    <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliver yProvider.FileShareProvider,ReportingServicesFileS hareDeliveryProvider">
    <MaxRetries>3</MaxRetries>
    <SecondsBeforeRetry>900</SecondsBeforeRetry>
    <Configuration>
    <FileShareConfiguration>
    <ExcludedRenderFormats>
    <RenderingExtension>HTMLOWC</RenderingExtension>
    <RenderingExtension>NULL</RenderingExtension>
    </ExcludedRenderFormats>
    </FileShareConfiguration>
    </Configuration>
    </Extension>
    <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryPro vider.EmailProvider,ReportingServicesEmailDelivery Provider">
    <MaxRetries>3</MaxRetries>
    <SecondsBeforeRetry>900</SecondsBeforeRetry>
    <Configuration>
    <RSEmailDPConfiguration>
    <SMTPServer></SMTPServer>
    <SMTPServerPort></SMTPServerPort>
    <SMTPAccountName></SMTPAccountName>
    <SMTPConnectionTimeout></SMTPConnectionTimeout>
    <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
    <SMTPUseSSL></SMTPUseSSL>
    <SendUsing></SendUsing>
    <SMTPAuthenticate></SMTPAuthenticate>
    <From></From>
    <EmbeddedRenderFormats>
    <RenderingExtension>MHTML</RenderingExtension>
    </EmbeddedRenderFormats>
    <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
    <ExcludedRenderFormats>
    <RenderingExtension>HTMLOWC</RenderingExtension>
    <RenderingExtension>NULL</RenderingExtension>
    </ExcludedRenderFormats>
    <SendEmailToUserAlias>True</SendEmailToUserAlias>
    <DefaultHostName></DefaultHostName>
    <PermittedHosts></PermittedHosts>
    </RSEmailDPConfiguration>
    </Configuration>
    </Extension>
    <Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProv ider.NullProvider,ReportingServicesNullDeliveryPro vider"/>
    </Delivery>
    <Render>
    <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.XmlDat aRenderer.XmlDataReport,Microsoft.ReportingService s.XmlRendering"/>
    <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRe nderer.NullReport,Microsoft.ReportingServices.Null Rendering" Visible="false"/>
    <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRen derer.CsvReport,Microsoft.ReportingServices.CsvRen dering"/>
    <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageR enderer.ImageReport,Microsoft.ReportingServices.Im ageRendering"/>
    <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageR enderer.PdfReport,Microsoft.ReportingServices.Imag eRendering"/>
    <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRe nderer.Html40RenderingExtension,Microsoft.Reportin gServices.HtmlRendering" Visible="false"/>
    <Extension Name="HTML3.2" Type="Microsoft.ReportingServices.Rendering.HtmlRe nderer.Html32RenderingExtension,Microsoft.Reportin gServices.HtmlRendering" Visible="false"/>
    <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRe nderer.MHtmlRenderingExtension,Microsoft.Reporting Services.HtmlRendering"/>
    <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelR enderer.ExcelRenderer,Microsoft.ReportingServices. ExcelRendering"/>
    <Extension Name="HTMLOWC" Type="Microsoft.ReportingServices.Rendering.HtmlRe nderer.HtmlOWCRenderingExtension,Microsoft.Reporti ngServices.HtmlRendering">
    <Configuration>
    <OWCConfiguration>
    <OWCDownloadLocation language="de">http://office.microsoft.com/germany/downloads/2002/owc10.aspx</OWCDownloadLocation>
    <OWCDownloadLocation language="en">http://office.microsoft.com/downloads/2002/owc10.aspx</OWCDownloadLocation>
    <OWCDownloadLocation language="ja">http://office.microsoft.com/japan/downloads/2002/owc10.aspx</OWCDownloadLocation>
    <OWCDownloadLocation language="zh-chs">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
    <OWCDownloadLocation language="zh-cht">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
    <OWCDownloadLocation language="es">http://office.microsoft.com/spain/downloads/2002/owc10.aspx</OWCDownloadLocation>
    <OWCDownloadLocation language="ko">http://office.microsoft.com/korea/downloads/2002/owc10.aspx</OWCDownloadLocation>
    <OWCDownloadLocation language="fr">http://office.microsoft.com/france/downloads/2002/owc10.aspx</OWCDownloadLocation>
    <OWCDownloadLocation language="it">http://office.microsoft.com/italy/downloads/2002/owc10.aspx</OWCDownloadLocation>
    </OWCConfiguration>
    </Configuration>
    </Extension>
    </Render>
    <Data>
    <Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.S qlConnectionWrapper,Microsoft.ReportingServices.Da taExtensions"/>
    <Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.O leDbConnectionWrapper,Microsoft.ReportingServices. DataExtensions"/>
    <Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.O racleClientConnectionWrapper,Microsoft.ReportingSe rvices.DataExtensions"/>
    <Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.O dbcConnectionWrapper,Microsoft.ReportingServices.D ataExtensions"/>
    </Data>
    <Security>
    <Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.Wi ndowsAuthorization, Microsoft.ReportingServices.Authorization"/>
    </Security>
    <Authentication>
    <Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.W indowsAuthentication, Microsoft.ReportingServices.Authorization"/>
    </Authentication>
    <EventProcessing>
    <Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistoryS napShotCreatedHandler,ReportingServicesLibrary">
    <Event>
    <Type>ReportHistorySnapshotCreated</Type>
    </Event>
    </Extension>
    <Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSub scriptionHandler,ReportingServicesLibrary">
    <Event>
    <Type>TimedSubscription</Type>
    </Event>
    </Extension>
    <Extension Name="Cache Update Extension"

    I thought of using rsconfig to confirm the virtual instance name, but rsconfig in Sql 2000 doesnt allow named instances!

    Any advice would be gratefully received.

    Thanks
    Tom
    Tom Willetts - Birmingham UK

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Did you check it in Reporting Server configuration manager?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •