jcollings Posted October 19, 2007 Posted October 19, 2007 OK - I've finally decided to do this. Put the SQL 2005 CD in and it fires up but I was kind of expecting to see a box along the lines of "Upgrade" or "New Installation" - it isn't there. Any ideas or step by step guide for full fat SQL 2000 to SQL 2005. I think once I've got that installed I can do the SIMS bit. Cheers folks Jarrod
Oops_my_bad Posted October 21, 2007 Posted October 21, 2007 Is this for the SIMS upgrade? Are you doing a side-by-side upgrade or are you migrating over to a new box?
jcollings Posted October 21, 2007 Author Posted October 21, 2007 Thanks for the reply - it's a side by side and I think I've got SQL 2005 installed now. Yes it is for SIMS. If I can get the conversion tool released (harder than it sounds) I'm due to upgrade this week. Deep joy!
Oops_my_bad Posted October 21, 2007 Posted October 21, 2007 I planned to do mine this weekend and it almost slipped because despite after 2 weeks capita still hadn't officially released to us through solus the "simsqlinfrastructure" file. I did a search on the server and it was hidden away in one of the temporary setup folders
tech_guy Posted October 21, 2007 Posted October 21, 2007 I planned to do mine this weekend but despite after 2 weeks capita still hadn't officially released to us through solus the "simsqlinfrastructure" file. I did a search on the server and it was hidden away in a temporary setup folder Where exactly? I'm doing mine tomorrow & I think I'm going to be in the same situation as you. Thanks.
Oops_my_bad Posted October 21, 2007 Posted October 21, 2007 On ours it was in simsroot\SIMS\setups\c39fded9-746c-42e5-9d7e-348db8369dda - yours might have a different folder name but just do a search for "simssqlinfrastructure" and you should find it
Oops_my_bad Posted October 21, 2007 Posted October 21, 2007 Forgot to say we were on the August update when I did that so it probably came down then.
tech_guy Posted October 22, 2007 Posted October 22, 2007 Hi, Just looking to do the dreaded side-by-side install of SQL2005 prior to the migration and I've come across this little gem in the help file on the SQL2005 CD: "2.5.12 Installing SQL Server 2005 on a Windows Domain Controller Security Note: We recommend against running SQL Server 2005 on a domain controller. It is possible to install SQL Server 2005 on a Windows domain controller; however, it cannot run on a Windows Server 2003 domain controller as Local Service or Network Service. SQL Server service accounts should run as Windows domain user accounts. It is also possible to install SQL Server service accounts to run as Local System, but this option is not recommended". We've got Sims.Net & SQL2000 running on our DC at present ( don't laugh - it's the way the LEA set things up here :-( ). So am I buggered or do I just ignore this little pearl of wisdom?
Grommit Posted October 22, 2007 Posted October 22, 2007 Hi, Just looking to do the dreaded side-by-side install of SQL2005 prior to the migration and I've come across this little gem in the help file on the SQL2005 CD: "2.5.12 Installing SQL Server 2005 on a Windows Domain Controller Security Note: We recommend against running SQL Server 2005 on a domain controller. It is possible to install SQL Server 2005 on a Windows domain controller; however, it cannot run on a Windows Server 2003 domain controller as Local Service or Network Service. SQL Server service accounts should run as Windows domain user accounts. It is also possible to install SQL Server service accounts to run as Local System, but this option is not recommended". We've got Sims.Net & SQL2000 running on our DC at present ( don't laugh - it's the way the LEA set things up here :-( ). So am I buggered or do I just ignore this little pearl of wisdom? Why don't you demote the DC and make another server the DC ?
Oops_my_bad Posted October 22, 2007 Posted October 22, 2007 You'll be OK - it's just not recommended. Do the database upgrade then consider getting SIMS moved onto it's own member server when you can.
tech_guy Posted October 22, 2007 Posted October 22, 2007 @TeddyKGB - thanks for the advice - migration taking place as I type. Order going in for new Sims.Net/SQL server as well. Sod 'em they'll just have to spend the money!
jcollings Posted October 22, 2007 Author Posted October 22, 2007 Well mine's done and all seemed to go well. Took a bit of time but no real issues. Breathed a big sigh of relief when it all worked! Good news is that means the rest of half term off!! Hurrah!
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now