Idera finally came out with a Mobile Manager that works on mobile devices other than a BlackBerry – because they are an American company they concentrated on BlackBerry functionality just when the rest of the world was changing or starting to use iPhones.
I have not used it much yet so cannot give any pros and cons but basically it is a web based tool running as an app on MS IIS which produces web pages enhanced for your particular mobile platform – you would still want to use VPN to access your network first.
Had some problems setting it up though – we were getting an error when trying to load the front screen of the website either via mobile or IE: get a standard HTTP 500 server error.
Turns out we had to tweak the IIS settings slightly. Recommendation from Idera was the following:
Click on server – top level and choose “Modules”
Right click on DynamicCompressionModule and choose “Unlock”
Right click on StaticCompressionModule and choose “Unlock”.
Select the SQLDm website under Sites, Default Website and choose Modules
Right click on DynamicCompressionModules and choose “Remove”
Right click on StaticCompressionModule and choose “Remove”
We actually changed the default website modules which filtered down automatically to the SQLDm modules – should work for just SQLDm though.
I believe the problem lay with the fact that we also had WSUS installed on the same server and although WSUS is installed as a separate application it makes changes to the IIS global configuration i.e. Dynamic Compression is turned off by default when IIS is installed but WSUS turns it on. This then conflicted with the SQLDm application.