Hi all,
I'm currently working for a customer that is looking to connect to their production SSRS instance using a new load balanced VIP with associated DNS alias rather than the use the SQL cluster network name
At the moment they use the following URL:
http://<SQL network name>/ReportServer_PRODSQL/reportexecution2005.asmx
What they would like to use is the following:
http://<DNS Alias>/ReportServer_PRODSQL/reportexecution2005.asmx
Both the <SQL network name> and <DNS Alias> resolve to the same IP address. Can anyone explain why all attempts to connect to the SSRS instance using the DNS alias only display a dialog box requesting username and password credentials?
Regards,
Paul