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