+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
MIS Systems Thread, SIMS - Training Datasets in Technical; Getting ready for the new year... I have downloaded the new Datasets for SIMS December. Now... the LA deal with ...
  1. #1

    Join Date
    Apr 2006
    Location
    West Midlands
    Posts
    314
    Thank Post
    29
    Thanked 19 Times in 18 Posts
    Rep Power
    20

    SIMS - Training Datasets

    Getting ready for the new year...

    I have downloaded the new Datasets for SIMS December.

    Now... the LA deal with the Live data in SIMS.net - I am not going to touch that... but would like on our the other network to install a training dataset SIMS.

    Can anybody give / tell me a step by step way to do it... I have so far managed to do so but just can't logon ... SIMS.net Configuration Fails!!! But can get in to the SQL tables.

  2. #2

    Join Date
    Jan 2007
    Location
    Enfield, London
    Posts
    159
    Thank Post
    7
    Thanked 3 Times in 3 Posts
    Rep Power
    16

    Re: SIMS - Training Datasets

    Quote Originally Posted by kiran
    Getting ready for the new year...

    I have downloaded the new Datasets for SIMS December.
    You can download the Green Abbey school training dataset?!!!

    Is this something your LA has made availible or did you download it from a Capita website?

  3. #3

    Join Date
    Apr 2006
    Location
    West Midlands
    Posts
    314
    Thank Post
    29
    Thanked 19 Times in 18 Posts
    Rep Power
    20

    Re: SIMS - Training Datasets

    Capita Support Website ...

  4. #4

    Join Date
    Jan 2007
    Location
    Enfield, London
    Posts
    159
    Thank Post
    7
    Thanked 3 Times in 3 Posts
    Rep Power
    16

    Re: SIMS - Training Datasets

    URL please please please!!!!!!!!!!

  5. #5

    Join Date
    Apr 2006
    Location
    West Midlands
    Posts
    314
    Thank Post
    29
    Thanked 19 Times in 18 Posts
    Rep Power
    20

    Re: SIMS - Training Datasets

    http://support.capitaes.co.uk/user/datasets.asp

    .... It was in my favorites!!

  6. #6

    Join Date
    Jan 2007
    Location
    Enfield, London
    Posts
    159
    Thank Post
    7
    Thanked 3 Times in 3 Posts
    Rep Power
    16

    Re: SIMS - Training Datasets

    Quote Originally Posted by kiran
    http://support.capitaes.co.uk/user/datasets.asp

    .... It was in my favorites!!
    Yes. Thank you! Thank you! Thank you!

  7. #7

    Join Date
    Apr 2006
    Location
    West Midlands
    Posts
    314
    Thank Post
    29
    Thanked 19 Times in 18 Posts
    Rep Power
    20

    Re: SIMS - Training Datasets

    @m2d2...

    Do you have any ideas how to get started then?

  8. #8

    Join Date
    Jan 2007
    Location
    Enfield, London
    Posts
    159
    Thank Post
    7
    Thanked 3 Times in 3 Posts
    Rep Power
    16

    Re: SIMS - Training Datasets

    I find it normally easiest to do a clean install using installers from my live system setups then use the db restore script.

    It's basically disaster recovery but using the training data rather than your actual live system backups.

    The data version must match the rest of system e.g. client executables.

  9. #9

    Join Date
    Jan 2007
    Location
    Enfield, London
    Posts
    159
    Thank Post
    7
    Thanked 3 Times in 3 Posts
    Rep Power
    16

    Re: SIMS - Training Datasets

    Quote Originally Posted by kiran
    Can anybody give / tell me a step by step way to do it... I have so far managed to do so but just can't logon ... SIMS.net Configuration Fails!!! But can get in to the SQL tables.
    I think something like this happened to me once. Have you done a clean install? Is it failing at the configuration of the blank database?

    If so then just proceed to the restore of the training data.
    Check that the connect.ini file in the client app folder or S:\SIMS folder (if you redirect) is pointing to the correct server, SQL instance and database. If not then amend accordingly.

  10. #10

    Join Date
    Apr 2006
    Location
    West Midlands
    Posts
    314
    Thank Post
    29
    Thanked 19 Times in 18 Posts
    Rep Power
    20

    Re: SIMS - Training Datasets

    Its a clean install as I don't touch the settings or anything related to Live Sims.net...

    I am installing on the other network as a trial for certain staff to familarise them with functions....

    Its fails to forward with "Sims.net Configuration" ... and when I run it manually it asks for SQL Login details ... you need 'Permission to configure database' I enter my SQL username and password which is the 'SA' login which I was prompted to do at install and fails with 'Invalid Login Details'. Trusted also fail ... even though it should work!!

    I don't have anything to restore... :?

  11. #11

    Join Date
    Jan 2007
    Location
    Enfield, London
    Posts
    159
    Thank Post
    7
    Thanked 3 Times in 3 Posts
    Rep Power
    16

    Re: SIMS - Training Datasets

    Quote Originally Posted by kiran
    I don't have anything to restore... :?
    From the initial post, I thought you were using the Green Abbey dataset as the training database.

    That's what I thought you were restoring on to your standalone system :?

  12. #12

    Join Date
    Jan 2007
    Location
    Enfield, London
    Posts
    159
    Thank Post
    7
    Thanked 3 Times in 3 Posts
    Rep Power
    16

    Re: SIMS - Training Datasets

    Quote Originally Posted by kiran
    Its fails to forward with "Sims.net Configuration" ... and when I run it manually it asks for SQL Login details ... you need 'Permission to configure database' I enter my SQL username and password which is the 'SA' login which I was prompted to do at install and fails with 'Invalid Login Details'. Trusted also fail ... even though it should work!!
    You sure your using mix mode rather than windows authentication?

    What happens if you use the username and password for the local admin on the SIMS server in order to connect to the database?

  13. #13

    Join Date
    Apr 2006
    Location
    West Midlands
    Posts
    314
    Thank Post
    29
    Thanked 19 Times in 18 Posts
    Rep Power
    20

    Re: SIMS - Training Datasets

    Quote Originally Posted by m2d2
    Quote Originally Posted by kiran
    I don't have anything to restore... :?
    From the initial post, I thought you were using the Green Abbey dataset as the training database.

    That's what I thought you were restoring on to your standalone system :?
    Oh... that is what I am doing! But what I did was attach it using DB Attach.

    Was that the wrong thing to do? ... Should I do the restore instead... May be I should uninstall everything and then start again?! :?

  14. #14

    Join Date
    Jan 2007
    Location
    Enfield, London
    Posts
    159
    Thank Post
    7
    Thanked 3 Times in 3 Posts
    Rep Power
    16

    Re: SIMS - Training Datasets

    Quote Originally Posted by kiran
    Oh... that is what I am doing! But what I did was attach it using DB Attach.

    Was that the wrong thing to do? ... Should I do the restore instead... May be I should uninstall everything and then start again?! :?
    Just had a look at the training data it has the MDF an LDF rather than sql BAK file. In that case dbAttach is the way to go.

    But I'm geting confused the Database configuartion normally happens towards the end of a clean install with a blank database. If you cannot connect to the database at this poin then wouldn't be able to use dbAttach.

    What you could do is create another instance and dbAttach onto that.

  15. #15
    guest
    Guest
    Hello Could Somebody please email me or upload the setup files for sims.net training dataset as I seem to be having trouble using the link that was uploaded.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. SIMs Manager Training
    By fiza in forum MIS Systems
    Replies: 6
    Last Post: 27th April 2009, 09:34 PM
  2. SIMS training
    By matt40k in forum MIS Systems
    Replies: 4
    Last Post: 14th April 2009, 07:57 PM
  3. SIMS training/reading [advice please]
    By contink in forum MIS Systems
    Replies: 7
    Last Post: 21st November 2007, 04:26 PM
  4. Merging data from two cmis datasets
    By gskelton in forum MIS Systems
    Replies: 1
    Last Post: 5th July 2007, 10:47 AM
  5. Using multiple Datasets for reporting in CMIS?
    By gskelton in forum MIS Systems
    Replies: 0
    Last Post: 25th June 2007, 10:29 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
  •