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