Hoping for some much needed direction. We have a single Server 2003 Standard 32bit - 2 core server as a stand alone domain controller - just the one. We have to replace it with server 2012 R2 Standard 64bit server - migrating it into the domain role and removing the old 2003 server. I am not a SQL guy... and it appears daunting.
We have SQL 2005 32bit SP4 SSIS on the 2003 server with all the business data in it etc... no idea how it was originally licensed. About 25 users in AD. We have a new 2012 server and the new SQL 2012 installation media, licensed for 4 cores, the number of new server cores.
I wish to take the path where I add the new server to the domain and promote it / demote the old - migrate the AD and all other tasks - and have what I need for that. Its the SQL upgrade path that I need assist with. I have some instruction from MS as to migrating the server - but they specify 'no SQL installed on the old server'. I want to get the 2005 SQL into the 2012 with full 2012 functionality (as opposed to an article I read that mentioned being limited to 2005 functionality in 2012 if done a certain way).
1) Would having SQL installed on the old server affect the migration of the domain and all its parts? Should I worry about SQL 2005 affecting that?
2) Do you have or can point me to this task specific set of steps or a guide?
I looked at a couple search hits here on this - but they aren't specific enough to my situation.
Any and all input would be greatly appreciated here.... am a rookie with SQL... Thank you.