• My xml file has the default setup like

    <Name>MSDB</Name>

    <ServerName>.</ServerName>

    ....

    this means that now it connects to default (active) server and on failover the passive becomes active and it should be the default instance now. why it is not like that?