Reporting services addressed to cluster address
Hello! To begin with, I have a small design flaw to be dealt with. An SQL Reporting Services has been configured to work from an cluster address (mycluster.com:port) instead of the local address (clusternode1:port). This is a problem when the cluster services (SQL mainly) switches from node to another and therefor the address mycluster.com:port will answer from the clusternode2 which doesnt have the reporting services installed (since it is not supported to cluster reporting services). I thought the easiest way would be to redirect this 'call' for reporting services to this clusternode1 which holds the installation of reporting services -> IP:port redirection to another IP:port. How do I accomplish this in Windows Server 2008 DNS? I hope that wasn't too confusing. Thanks for any help.
November 24th, 2010 9:51am

Hi vellun, You are right. The easiest way to redirect to call for reporting services to clusternode1 is that, create a new Host A record in the DNS server, point it to the clusternode1 directly. This allow us the visit the report server via the new DNS A record directly. For more information about how to create a DNS alias record, please see: Creating a DNS Alias Record: http://support.microsoft.com/kb/168322 If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 25th, 2010 6:46am

Thanks for your reply Jin Chen! I'll try to be more specific so I know exactly what you mean Case scenario: clusterservices.x.com for the cluster service clusternode1.x.com for the reporting services clusternode2.x.com for failover An installation of application x is set to call for SQL reporting services from the clusterservices.x.com. The application will only receive an answer if the clusterservices.x.com is currently hosted on clusternode1.x.com. If I do an alias for clusterservices.x.com which directly points to clusternode1.x.com will it work (application x still points to clusterservices.x.com)? Won't it break some of the functionalities of the cluster service? What I was hoping for is only to forward the calls to specific port but I guess that's not what the DNS A record does.
November 26th, 2010 3:09am

Suggestions are still welcome.
Free Windows Admin Tool Kit Click here and download it now
December 1st, 2010 5:59am

Hi there, If I do an alias for clusterservices.x.com which directly points to clusternode1.x.com will it work (application x still points to clusterservices.x.com)? It won't work, as the clusternode1.x.com is a clustered resource, and it will be redirect to clusternode2.x.com in case of failover. Why not creating a alias for clusternode1.x.com directly for the reporting services? Thanks, Jin ChenJin Chen - MSFT
December 3rd, 2010 3:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics