Initial Catalog means that you are by default connecting to that DB. When you change your initial catalog to some other DB, and then try to execute the same SP,...
what your vendor told makes perfect sense. This is what you call a mirror account. the only thing is that the mirror account (sql user) should have the same User Id and...