SQL Server 2000 Clustering Issues

Question

Post reply

SQL Server 2000 Clustering Issues

tomwbhx

SSC Rookie

Points: 47
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>

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

<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.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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Steve Newton SSCommitted Points: 1864 More actions · Answer 1

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.