kxv2020 Posted December 27, 2007 Posted December 27, 2007 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.
m2d2 Posted December 28, 2007 Posted December 28, 2007 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?
kxv2020 Posted December 28, 2007 Author Posted December 28, 2007 http://support.capitaes.co.uk/user/datasets.asp .... It was in my favorites!!
m2d2 Posted December 28, 2007 Posted December 28, 2007 http://support.capitaes.co.uk/user/datasets.asp .... It was in my favorites!! Yes. Thank you! Thank you! Thank you!
kxv2020 Posted December 28, 2007 Author Posted December 28, 2007 @m2d2... Do you have any ideas how to get started then?
m2d2 Posted December 28, 2007 Posted December 28, 2007 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.
m2d2 Posted December 28, 2007 Posted December 28, 2007 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.
kxv2020 Posted December 28, 2007 Author Posted December 28, 2007 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... :?
m2d2 Posted December 28, 2007 Posted December 28, 2007 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 :?
m2d2 Posted December 28, 2007 Posted December 28, 2007 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?
kxv2020 Posted December 28, 2007 Author Posted December 28, 2007 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?! :?
m2d2 Posted December 28, 2007 Posted December 28, 2007 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.
Guest guest Posted April 27, 2011 Posted April 27, 2011 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.
NorthernSands Posted April 27, 2011 Posted April 27, 2011 (edited) Welcome! The training databases are too big to e-mail, and I'm not entirely sure Capita would want someone to host them outside of SupportNet. Your best bet is to ask your SIMS Support team (be that Capita or your LA). Either that, or take a copy of your existing SIMS DB and install it on a standalone system. The easiest way to do this, I find, is to take a copy of the entire SIMS folder from the server, copy it to a standalone system, then run SIMSInst.EXE. Either attach a previously copied .MDF & .LDF as you go through the install (don't copy the DB files without having detached them from the live server!), or choose to attach a DB later and restore from a .BAK (which you can obtain from the live SIMS 'on the fly' from within System Manager). Oh, and don't forget a copy of your DocStorage folder! Come back if you want more detailed instructions or further help. Edited July 5, 2011 by ZeroHour
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