May 29, 2012 at 10:24 am
My SYS admins are updating our servers from windows 2000 to windows 2008
We are using mixed mode authentication -
Will I have any login issues?
Anything else I should look for?
Some of the DB's are using SQL2000 comtibility.
May 29, 2012 at 10:38 am
krypto69 (5/29/2012)
My SYS admins are updating our servers from windows 2000 to windows 2008We are using mixed mode authentication -
Will I have any login issues?
You should be fine.
EDIT: forgot to mention, I would stop and disable the SQL Server services before the upgrade begins and only enable and start the services once it is complete. Obligatory comment about backups...take them and construct a proper rollback plan in case the upgrade goes poorly and you ened to rebuild from scratch. This includes making sure you have all the OS and SQL Server binaries needed to rebuild your instance from scratch and arrive at the current build level.
Anything else I should look for?
Look for anything using resources external to SQL Server, e.g. Linked Servers using third-party drivers, OLE DB procs using COM objects, SQLCLR objects with external access, etc.
Some of the DB's are using SQL2000 comtibility.
The compat mode should have no impact on the OS upgrade, before or after.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 29, 2012 at 12:32 pm
Thanks opc !! you rock
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply