SIMS SQL 2005 --> 2008 migration
I'm just in the planning stages of moving SIMS from SQL 2005 to SQL 2008 (both full versions not express). At one point the documentation says "In order for the redirection service to operate, SQL 2005 must be left running for a suitable period of time, i.e. until all users have logged into SIMS." As I'm performing the upgrade early in the summer holiday most staff won't login for a long time. How essential is this part of the process and what does it actually change for each user?
If you need more details ask away.
Oh I think I've found an explanation now it remaps the connect.ini file to the new instance name.