+ Post New Thread
Results 1 to 7 of 7
Windows Thread, Problems installing SQL 2005 for SIMS in Technical; We are having a problem installing SQL 2005. The installation gets all the way to the end where it says ...
  1. #1
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    3,033
    Thank Post
    305
    Thanked 292 Times in 202 Posts
    Rep Power
    120

    Problems installing SQL 2005 for SIMS

    We are having a problem installing SQL 2005. The installation gets all the way to the end where it says creating the folder E:\program files\Microsoft SQL Server and throws up an error message about how it cannot create it. Now the user we are logging on as is full network admin and has full rights to install and make folders.

    Can someone help

    Thanks

    Tim

  2. #2

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17

    Re: Problems installing SQL 2005 for SIMS

    is it having a problem creating the shorcuts if so log on as local admin?

  3. #3

    Join Date
    Jun 2007
    Location
    Leicestershire
    Posts
    82
    Thank Post
    24
    Thanked 3 Times in 2 Posts
    Rep Power
    15

    Re: Problems installing SQL 2005 for SIMS

    Sorry for butting in to this thread, but am looking at getting sql 2005 installed for sims also.

    Was wondering whether there was anything special needed to be set up for sql for sims? Or whether if I just go through and install the default etc, it would be fine?

    CHeers if you (or anyone else) can help )

  4. #4
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    3,033
    Thank Post
    305
    Thanked 292 Times in 202 Posts
    Rep Power
    120

    Re: Problems installing SQL 2005 for SIMS

    I think you just need to install it as an upgrade. Well thats what our SIMS lady was telling me.

  5. #5

    Join Date
    Mar 2007
    Location
    Heywood, Lancs
    Posts
    211
    Thank Post
    7
    Thanked 50 Times in 45 Posts
    Rep Power
    28

    Re: Problems installing SQL 2005 for SIMS

    2005 is a straightforward install. If you already have 2000 you can install it side by side without effecting the older version at all - this is what we did to prepare our server for the migration. It needs to be patched to Service Pack 2 for use with SIMS, but you only need to install the basic sql bits - unless you use and understand all the optional tools, documentation and languages.
    As I recall the install is straightforward but you must put in an sa password and it must be 'strong' one - it's needed for the sims migration so make sure you make a note of it ! You will also need to give it an instance name and this needs to be different to the existing SIMS one if its on the same server. Took us about 1.5 hours including service packs and windows updates.

  6. #6

    Join Date
    Apr 2007
    Location
    York
    Posts
    559
    Thank Post
    10
    Thanked 4 Times in 4 Posts
    Rep Power
    20

    Re: Problems installing SQL 2005 for SIMS

    The problem we had was that it installed it on the default C:\ even though we selected to install it on E:\. We needed to install all the SQL options IE reporting services etc
    Once installed there is nothing to do in Sims.net, it works just the same. Be careful though as there is a current problem that all new workstation installations, installed after SQL2005 are incredably slow. Capita are working on this.
    For North Yorks schools, ring Jackie at SICT, on 0845 330 2922

  7. #7

    Domino's Avatar
    Join Date
    Oct 2006
    Location
    Bromley
    Posts
    4,169
    Thank Post
    217
    Thanked 1,284 Times in 799 Posts
    Blog Entries
    4
    Rep Power
    511

    Re: Problems installing SQL 2005 for SIMS

    Install as an upgrade? no, we installed side by side, then switched over to 2005 using the SIMS tool with the august update.

    just beware, if you want the management tools you'll need to go through the installer and select them - they don't seem to come by default.

    As for the folder problem, how much space is there on E:\? have you also checked its not a write protected drive?

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS on MSSQL 2005
    By AlexB in forum MIS Systems
    Replies: 9
    Last Post: 7th November 2007, 09:20 AM
  2. Upgrading SIMS to SQL 2005
    By AnnDroyd in forum MIS Systems
    Replies: 13
    Last Post: 9th October 2007, 03:02 PM
  3. SQL 2005 and SIMS FMS Finance
    By thom in forum MIS Systems
    Replies: 2
    Last Post: 30th August 2007, 04:50 PM
  4. SIMS SQL 2005
    By steve in forum MIS Systems
    Replies: 54
    Last Post: 20th August 2007, 01:35 PM
  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
  •