The Scottish Government said the MoD could not provide the support it asked for but has offered alternative help.