Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Address redirection in ISA

Posted on 2009-07-08
4
Medium Priority
?
618 Views
Last Modified: 2012-05-07
Hi I've an issue I'm hoping maybe solved by some ISA configuration chnages, but am no expert on the software and need some help... please.

Background;  Excel spreadsheet with data source set as a SQL box out on the web.  Spreasheet on internal company LAN.  Firewall client installed on workstations that use the spreadsheet.  Company hosting the SQL Db have chnaged the IP address and now have a more sensible DNS name we can use.

Issue;  We have hundreds of spreadsheets with the old, now useless, address in them.  Chnaging them all will be a huge task.

Idea;  Can ISA be used to somehow redirect the connection?  So the spreadsheet still taregts the old IP address, but some sort of ISA rule chnages it so the new location is hit.

I don't hold out much hope for this being a working idea, but I don't fancy telling the users they have to amend all the spreadsheets manually either!

Any help appreciated.

Cheers

Mark.
0
Comment
Question by:dalms
  • 2
4 Comments
 
LVL 16

Expert Comment

by:Wadski
ID: 24805626
Can't you just add the old IP addresses onto the existing Server?

You can give it more than one IP you know.

Choose properties on Internet Protocol (TCP/IP)
Choose Advanced and then add additional IPs in there.
0
 
LVL 29

Expert Comment

by:pwindell
ID: 24805713
No.  ISA is not the source of the solution
You might solve the issue with Hosts Files. Use the Name used by the spreadsheets and associate it with the proper IP of rhte DB Server
You will need to duplicate it on each PC that will be using the spreadsheets.
0
 

Author Comment

by:dalms
ID: 24805842
Thanks for quick repsonse guys,

Wadski - Server is not under my control so can't add another address.  Also addresses are on completely different subnets.

pwindell - Ah, it was worth a punt, but your 'No' is not unexpected.  I have a think about the hosts files idea.

Cheers
0
 
LVL 29

Accepted Solution

by:
pwindell earned 1500 total points
ID: 24806352
The Hosts files should work.  You could try the host File on only the ISA and see what happens.  Unfortuneately with Firewall Clients ISA does not always do the DNS Resolution on behalf of the Client (like the Web Proxy Service does),...hence it would then have to go on the individual Clients.
In the end,...it may be better to adjust the Spreadsheets for the new DNS Name and re-save them. It only has to be done once to each spreadsheet.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

ISA Server detected routes through the network adapter LAN that do not correlate with the network to which this network adapter belongs What does this mean and how can one go about correcting it? In simple terms, this error message indicates t…
There are several problems reported according slow link speeds or poor performance in TMG 2010, UAG 2010 or ISA 2006. I want to collect here some of the common issues together to give a brief overview what can be the reason. Nevertheless, not all of…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses
Course of the Month8 days, 8 hours left to enroll

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question