MIS Systems Thread, Creating a new database in Technical; I am trying to create a new SIMS database and when folowing the instructions from the simsinstallautumn2009 iso I am ...
26th July 2010, 11:55 AM #1
Creating a new database
I am trying to create a new SIMS database and when folowing the instructions from the simsinstallautumn2009 iso I am getting the following error when trying to configure the database
Database Configuration Failed
Error when Configuring Database: The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
This is with SQL 2008 installed via the capita installers and we have raised a call through Supportdesk but are waiting for a call back.
anyone seen this or able to give me any advise?
IDG Tech News
26th July 2010, 12:08 PM #2
Use the spring installable.
Thanks to matt40k from:
Mcshammer_dj (26th July 2010)
26th July 2010, 12:12 PM #3
thanks mate just got you email.
Originally Posted by matt40k
9th December 2010, 10:42 AM #4
- Rep Power
Getting the same error when trying to install the Spring 2010 install on a new server:
"Error when Configuring Database: The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION."
Any help gratefully received!
18th December 2010, 05:49 PM #5
Are you restoring a database or doing a fresh install? If so, I have had that error (when using SIMS) and it was always because "Validate Memberships" had to be run
23rd May 2011, 10:35 AM #6
I've been doing a fresh install and getting this error message. Just as a test, I installed a brand new VM with Windows Server 2003 R2 and downloaded all critical updates. I didn't install anything else, as I wanted to check whether any other apps on the production server were causing the problem. I then ran the install from the Spring 2010 iso, and got exactly the same result. Despite getting the error message during installation, Sims runs, but it tells me I need to run the configuration utility. Trying to rerun this gives the same SQL error. Seems strange that it doesn't install straight "out of the box". Can't see how Validate Memberships can be relevant to a fresh install. Any ideas?
23rd May 2011, 10:43 AM #7
During install do you take the option to attach your db file?
I always just leave defaults and let it create a new db. Then upgrade to the latest version before adding my db backup.
Never had a problem with doing a clean install.
Thanks to vikpaw from:
waldronm2000 (23rd May 2011)
23rd May 2011, 10:54 AM #8
Thanks Vikpaw. I just stuck with the defaults all the way through, as wanted to rule out any complications.
Having had a look on SupportNet I found this message can be caused by insufficient RAM. I've upped the spec of my VM and trying again now.
23rd May 2011, 11:27 AM #9
Success! Just needed more RAM.
23rd May 2011, 11:39 AM #10
I don't believe you! How much did you give it to begin with? I'm sure i've done an install with 2GB on my laptop.
Originally Posted by waldronm2000
23rd May 2011, 12:04 PM #11
Well, I only have 2GB on my laptop, and this was a VM, so I started with 512MB. I figured (stupidly) it'd tell me if it needed more! For what I'm planning, I need 3 virtual SIMS servers running. 512MB wasn't enough, but 768MB worked ok. I've ordered a 4GB upgrade kit for my laptop.
23rd May 2011, 01:23 PM #12
Makes sense if the memory was that low, that it struggled to load and manage everything it needed to.
Is that +4GB or replace the 2 with 4? I replaced the 2 on my macbookpro to 4, and it barely could manage 1 VM server on vmfusion at a time. I wouldn't recommend trying to run them concurrently.
Does it have to be on your laptop? can't you do it on a desktop or ideally server, and then just connect to it via the laptop?
23rd May 2011, 03:55 PM #13
4GB to replace the 2GB, unfortunately. I'll probably end up doing this evenings and weekends (investigating school merging), so it'll have to be on my laptop if at all possible.
24th May 2011, 08:02 AM #14
If you're doing it at home, i'd still consider using a home server or something that you can load up with more RAM. I ran a server on my macbookpro for ages, but it lagged significantly, and that was with OS X. I can't imagine how a PC would cope. I ran a few servers off my PC using VMWare server and that was horrendous, but never more than one at a time.
4GB isn't really that much if you have to share it, unless you've got a really good VM infrastructure, i know somewhere that VMWare is managing hundreds of sims instances with only 8GB, but it's a full install, with decent memory management, and probably deduplication working extremely well.
If you can i'd prefer server side install, so you're not using the OS that it's based on at the time, and then just remote access it if you can. Logmein or such like.
Try it on your laptop, it might be with the latest tech, things run different. The new macbookpro i7, is quad core, and is shiny and new
24th May 2011, 09:37 AM #15
Only testing a concept currently, will be able to use real hardware when it comes to doing the job for real.
Current problem is I'm trying to replicate the school's current SIMS database in a VM, so now that I've got the VM working I've got a backup of the sims.mdf and sims.ldf files from the live server. When I try to attach these to the VM, it works fine but when I run SIMS I get an incompatible database error. I guess this is because VM has fresh install Spring 2010 release, while live server is up to date. I don't want to run Solus on the VM if I can avoid it, as this may affect the live server when it next runs Solus. I've copied the relevant updates into the Setups folder in the VM, but is there any way to get them to install without running Solus?
By jkmoch in forum EduGeek Joomla 1.0 Package
Last Post: 5th May 2008, 03:28 AM
By armadillo in forum How do you do....it?
Last Post: 21st September 2007, 02:44 PM
By sidewinder in forum Windows
Last Post: 28th February 2007, 09:37 AM
By StewartKnight in forum Web Development
Last Post: 21st February 2007, 08:53 AM
By Frazer in forum MIS Systems
Last Post: 28th March 2006, 12:15 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)