+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, SQL 2005 in Technical; OK - I've finally decided to do this. Put the SQL 2005 CD in and it fires up but I ...
  1. #1

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,555
    Thank Post
    112
    Thanked 177 Times in 144 Posts
    Rep Power
    71

    SQL 2005

    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

  2. #2
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30

    Re: SQL 2005

    Is this for the SIMS upgrade? Are you doing a side-by-side upgrade or are you migrating over to a new box?

  3. #3

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,555
    Thank Post
    112
    Thanked 177 Times in 144 Posts
    Rep Power
    71

    Re: SQL 2005

    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!

  4. #4
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30

    Re: SQL 2005

    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

  5. #5

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,135
    Thank Post
    1,908
    Thanked 1,343 Times in 742 Posts
    Blog Entries
    3
    Rep Power
    395

    Re: SQL 2005

    Quote Originally Posted by TeddyKGB
    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.

  6. #6
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30

    Re: SQL 2005

    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

  7. #7

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,135
    Thank Post
    1,908
    Thanked 1,343 Times in 742 Posts
    Blog Entries
    3
    Rep Power
    395

    Re: SQL 2005

    Cheers!

  8. #8
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30

    Re: SQL 2005

    Forgot to say we were on the August update when I did that so it probably came down then.

  9. #9

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,135
    Thank Post
    1,908
    Thanked 1,343 Times in 742 Posts
    Blog Entries
    3
    Rep Power
    395

    Re: SQL 2005

    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?

  10. #10
    Grommit's Avatar
    Join Date
    Sep 2006
    Location
    Weston-super-Mare
    Posts
    1,335
    Thank Post
    31
    Thanked 54 Times in 31 Posts
    Rep Power
    24

    Re: SQL 2005

    Quote Originally Posted by tech_guy
    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 ?

  11. #11
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30

    Re: SQL 2005

    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.

  12. #12

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,135
    Thank Post
    1,908
    Thanked 1,343 Times in 742 Posts
    Blog Entries
    3
    Rep Power
    395

    Re: SQL 2005

    @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!

  13. #13

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,555
    Thank Post
    112
    Thanked 177 Times in 144 Posts
    Rep Power
    71

    Re: SQL 2005

    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!

SHARE:
+ Post New Thread

Similar Threads

  1. ID Cards with SQL 2005
    By hayjo86 in forum MIS Systems
    Replies: 2
    Last Post: 20th December 2007, 10:34 AM
  2. Question about sql 2005
    By dezt in forum MIS Systems
    Replies: 11
    Last Post: 26th September 2007, 10:40 PM
  3. SIMS SQL 2005
    By steve in forum MIS Systems
    Replies: 54
    Last Post: 20th August 2007, 01:35 PM
  4. C#/SQL 2005 question
    By Gatt in forum Coding
    Replies: 4
    Last Post: 29th June 2007, 05:12 AM
  5. SIMS + SQL 2005?
    By Norphy in forum MIS Systems
    Replies: 22
    Last Post: 5th April 2007, 10:20 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •