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.