SQL Server 2000 Clustering Issues

• tomwbhx

  SSC Enthusiast

  Points: 107

  More actions

  November 5, 2010 at 3:11 am

  #231301

  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+sBAAAANZBOIX9EJECvPdcwjXTBkwQAAAAiAAAAUgBlAHAAbwBy

  AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAMTUZRHx0ihNWd05L1KkUp0AAAAA

  BIAAAKAAAAAQAAAAmI0QlceFJKfCTvNthmifSTgBAADzCdNWa8GOHsJZKSXi6ZTycjm7bFTMFvP0

  Q9WUOD2ebfJp2auACdZ9iID4+v5N8Suxa1rL2AtE5T+ZrWhHYfQV+NoGu9ajck2ikriCxyuqvgJi

  tA1RmpvbIaqTJlqxpRT1YHF6PD+yXh/M7iEatpIcBdWsr3s2Zce09KK3RkZSHocHImjQgrZECGIc

  8IXdt8BNADitLlt+CKU+OvVXFH4IYtP/wJXhrAMSKB1Bctn74QLpxogxKu7kKDBbiycoRslk5Djs

  zwfT61uT4kr4wEE4uEHvP1CRm+j+WUmww9C03bxwZlxXecxrptilONQRQajrdvZIuSELMZQ/55Bl

  D1YTUCVhfisjBlV7ujLvUwCLTP0J6SV4D3E59LSDUvU1YDCvWgYskVx8TNW2X4iKWxekE3/qCSc3

  1HcUAAAAxVDVVfiSb5fB3kVZc6J1Ve7sVac=</Dsn>

  <ConnectionType>Default</ConnectionType>

  <LogonUser>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAANZBOIX9EJECvPdcwjXTBkwQAAAAiAAAAUgBlAHAAbwBy

  AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAACB+rN2ARcpGKhfuMvPdlzcAAAAA

  BIAAAKAAAAAQAAAA2WAYZ58zYAq7+Ak/GXpZTBAAAAC8+giHyMKdzLz5QYIx5UHtFAAAALpR8e0+

  wIccU0d7pRI7AZ7A6c6z

  </LogonUser>

  <LogonDomain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAANZBOIX9EJECvPdcwjXTBkwQAAAAiAAAAUgBlAHAAbwBy

  AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAGbgCrT77wIukOPOi9G5ODYAAAAA

  BIAAAKAAAAAQAAAAqIkXTtNwPZCU1RXW+Gi5oxAAAACT1kzcvdeS2oGHtMcJYnpdFAAAAAfwoUlM

  mXV2kJSmhQZbrrCoo6+Q

  </LogonDomain>

  <LogonCred>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAANZBOIX9EJECvPdcwjXTBkwQAAAAiAAAAUgBlAHAAbwBy

  AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAGkF2PonN0H6xR+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&gt;

  <UnattendedExecutionAccount>

  <UserName></UserName>

  <Password></Password>

  <Domain></Domain>

  </UnattendedExecutionAccount>

  <PolicyLevel>rssrvpolicy.config</PolicyLevel>

  </Service>

  <Extensions>

  <Delivery>

  <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">

  <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.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">

  <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.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>

  </Delivery>

  <Render>

  <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/>

  <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>

  <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>

  <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering"/>

  <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/>

  <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>

  <Extension Name="HTML3.2" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>

  <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>

  <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>

  <Extension Name="HTMLOWC" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExtension,Microsoft.ReportingServices.HtmlRendering">

  <Configuration>

  <OWCConfiguration>

  <OWCDownloadLocation language="de">http://office.microsoft.com/germany/downloads/2002/owc10.aspx</OWCDownloadLocation&gt;

  <OWCDownloadLocation language="en">http://office.microsoft.com/downloads/2002/owc10.aspx</OWCDownloadLocation&gt;

  <OWCDownloadLocation language="ja">http://office.microsoft.com/japan/downloads/2002/owc10.aspx</OWCDownloadLocation&gt;

  <OWCDownloadLocation language="zh-chs">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation&gt;

  <OWCDownloadLocation language="zh-cht">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation&gt;

  <OWCDownloadLocation language="es">http://office.microsoft.com/spain/downloads/2002/owc10.aspx</OWCDownloadLocation&gt;

  <OWCDownloadLocation language="ko">http://office.microsoft.com/korea/downloads/2002/owc10.aspx</OWCDownloadLocation&gt;

  <OWCDownloadLocation language="fr">http://office.microsoft.com/france/downloads/2002/owc10.aspx</OWCDownloadLocation&gt;

  <OWCDownloadLocation language="it">http://office.microsoft.com/italy/downloads/2002/owc10.aspx</OWCDownloadLocation&gt;

  </OWCConfiguration>

  </Configuration>

  </Extension>

  </Render>

  <Data>

  <Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

  <Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

  <Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

  <Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>

  </Data>

  <Security>

  <Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization, Microsoft.ReportingServices.Authorization"/>

  </Security>

  <Authentication>

  <Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication, Microsoft.ReportingServices.Authorization"/>

  </Authentication>

  <EventProcessing>

  <Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">

  <Event>

  <Type>ReportHistorySnapshotCreated</Type>

  </Event>

  </Extension>

  <Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">

  <Event>

  <Type>TimedSubscription</Type>

  </Event>

  </Extension>

  <Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">

  <Event>

  <Type>SnapshotUpdated</Type>

  </Event>

  </Extension>

  </EventProcessing>

  </Extensions>

  </Configuration>

  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

• Steve Newton

  SSCommitted

  Points: 1944

  More actions

  December 12, 2010 at 12:10 pm

  #1261448

  Its encrypted so you wont see it in a readable format. Assuming you can access the databases via SSMS when it fails over then it suggests it pointing at the primary node and not the virtual name. Pretty sure you can identify this in rsconfig.

  I have never used SSRS 2000 so can't physically see anything this side to confirm this but hope it helps.

  Steve.