+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, 2008 Setup Questions in Technical; Is there a Capita Guide on how to install SQL 2008 Server? I've got the guide that leads you through ...
  1. #1

    Join Date
    Nov 2007
    Location
    Rotherham
    Posts
    1,675
    Thank Post
    122
    Thanked 126 Times in 102 Posts
    Rep Power
    45

    2008 Setup Questions

    Is there a Capita Guide on how to install SQL 2008 Server?

    I've got the guide that leads you through the SQL 2008 Express install and to be honest I can make a reasonable educated guess however...

    Given it's SIMS and I want to make sure I don't miss something I was wondering if there was a guide on how to install SQL server so SIMS is happy.

  2. #2
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Have you seen Resource 16101 from SupportNet?

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Forget that, install the express, put the kettle on, then bung the server 2008 standard disc in, maintenance tasks, upgrade edition. Normally the kettles just finished boiled by the time it's done.

  4. #4
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Just proves I ain't a Technical expert eh?
    Mind you - the kettle is one of my priorities too ..................

  5. #5

    Join Date
    Nov 2007
    Location
    Rotherham
    Posts
    1,675
    Thank Post
    122
    Thanked 126 Times in 102 Posts
    Rep Power
    45
    Quote Originally Posted by Sivadam View Post
    Have you seen Resource 16101 from SupportNet?
    Yeah got that. It steps you though the SQL Express install and it's about 95% the sames as SQL Server but as there are a few more options of what to install I wondered if there was a SQL server specific version. Just being a little overly paranoid to be honest but better safe than sorry. If I have to wing it I have to wing it.

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    i'm probably too late now stuart, but the answers to some of the questions you might have (which options need ticking on install) are below, taken from a document on SupportNet created by a user who raised a case with Capita asking the same thing. So it's not definitive but might be useful:

    Click on Installation in the left hand menu and then select the first option New SQL Server stand-alone installation. The SQL Server 2008 setup process will start.

    Now follow the instructions on page 12 of Capita’s Migrating SIMS to SQL2008 documentation, part 11. up to part 17 Feature Selection page. This is where SQL2008 Express differs from SQL Server.

    The Capita help-desk recommendation is to tick the following:
    - Database Engine Services.
    - SQL Server Replication.
    - Full-Text Search.
    - Analysis Services
    - Client Tools Connectivity.
    - Integration Services.
    - Client Tools Backwards Compatibility.
    - Client Tools SDK.
    - Management Tools - Basic
    - Management Tools - Complete

    It's optional if you wish to install the Reporting Services.

    On the Instance Configuration page, change the Named instance to SIMS2008. Your existing SIMS SQL instance is probably called SIMS2005 (see the installed instances panel). Click Next.

    The Server Configuration window will be displayed. It should look similar to the following. If so click Next.

    On the Analysis Services Configuration window, ass you users for which you want to give access. Click Next.

    Now follow the Capita documentation from section 22 on page 17, “Database Engine Configuration”.

    Once the installation has complete, the Installation Process screen should look similar to

    Click Next, SQL Server 2008 has now been installed.

    At this stage yo can run the SIMS SQL Migration Utility.
    I'd credit the author but the original link wouldn't work for me and i just copied the text out of the document and made my own. It should be on the Technical forum on SupportNet though.

    HTH

  7. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Be interested why you would want to install:

    - Full-Text Search.
    - Analysis Services

    - Integration Services.

  8. #8

    Join Date
    Nov 2007
    Location
    Rotherham
    Posts
    1,675
    Thank Post
    122
    Thanked 126 Times in 102 Posts
    Rep Power
    45
    Yep it's a bit late but cheers anyway vik.
    I've installed this as I could figure out based on the SQL Express install and it all seems to be working OK. Bonuses include it fixing the fact that the exam result import was very slow unless run on the server!

SHARE:
+ Post New Thread

Similar Threads

  1. New virtualisation / Win 2008 R2 setup
    By MRmr in forum Windows Server 2008 R2
    Replies: 2
    Last Post: 10th March 2010, 02:27 PM
  2. Switching to 2008 - Quick Questions
    By jmair in forum Windows Server 2008
    Replies: 4
    Last Post: 9th December 2009, 07:57 AM
  3. New exchange 2007 setup/admin questions
    By ranj in forum Windows
    Replies: 0
    Last Post: 25th September 2009, 03:27 PM
  4. iis7 server 2008 setup
    By PEO in forum Windows Server 2008
    Replies: 16
    Last Post: 28th July 2009, 09:41 AM
  5. Setup Exchange Server 2007 for Friend - Some Questions
    By Zoom7000 in forum How do you do....it?
    Replies: 3
    Last Post: 22nd July 2008, 10:23 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
  •