Search the Community

Hello, A few of our SIMS clients aren't connecting as expected. When SIMS is run under standard user privileges, the login works but takes approximately 15 mins to complete. However, if I run SIMS as an administrator, the login is almost instantaneous (even using the same SIMS creds). It can't be the firewall as we have Windows Firewall disabled on all of our clients (we have an external one to the WAN). I am certain that the problem is client-side because SIMS works properly on some clients, not others. We are experiencing issues with FMS and Discover client software on the same machines. Any help is much appreciated, Roger

Data Manager opportunity for a leading Independent school. Great benefits and salary package on offer. Salary on offer is £40,000 (Pro-Rata), 42 working weeks per annum. Salarty £36,000. Duties and Responsibilities - · Manage and administer the schools MIS systems and producing custom reports. · Managing all pupil reports and creating custom reports. · Provide support and guidance for all GDPR compliance matters. · Managing the schools learning platform, room booking and parent portals. · Administration of pupil data for target setting and analysis of examination data. · Providing IT support and assistance to the Examinations Manager Skills and Experience - · Working with Management Information systems. · Data analysis tools. · Advanced Microsoft Office skills. · Ability to work under pressure and working independently. · Experience working in a school is desirable. · SQL experience is desirable. APPLY NOW – Submit your CV to [email protected] or contact us today on 07904 015757 to discuss the opportunity further. GreatFind Recruitment is a London based recruitment agency specialising within the IT and EdTech sectors. We pride ourselves on our strategic, consultative approach, delivering tailored recruitment solutions that meet your goals. We help you grow, whether you’re exploring your career options or building your own team. Ravi Patel GreatFind Recruitment 19 Years Experience working with Schools! Tel - 020 3318 2128 Out of hours - 07904 015757 Email - [email protected] For our latest vacancies visit - http://www.greatfindrecruitment.com Follow us on LinkedIn - https://www.linkedin.com/company/greatfind-recruitment/ **APPROVED**

If I make simple changes in NOVA T - changing Non-contact of meeting times, for example - do I need to export these to SIMS for them to work or is this done automatically? If I need to export these - is this via SQL or just reapplying the timetable? Thanks

Salary £28,157.42 per annum Hours 36 hours per week Contract Full time, permanent Apply by 29th June Full details click here Hopwood Hall :: MIS Technical Officer We have an exciting opportunity for an MIS Technical Officer to join the college's MIS and Exams Team. You will play a pivotal part in the development, management and maintenance of core databases, tables, views, stored procedures and optimisation of the underlying reporting datasets. The successful candidate will be a committed team player with excellent organisational and specialist technical skills. You will have extensive experience of delivering outstanding customer service and possess the ability to develop relationships across our college community.

Hello, I have a weird problem with our SQL 2008 server that hosts SIMS (it was SQL 2005 before, but we migrated it to try and solve this problem, it didn't) We had Capita remote-in to install hosted SIMS Learning Gateway. They ran a tool to create a new user in SIMS to allow ADP to work. However, after creating it, we couldn't login. We went into SQL Management Studio to try and change the password, but when we tried to get into the properties for the newly created account we got this message: Cannot show requested dialog. (SqlMgmt) Property IsLocked is not available for Login '[CGSadp.client]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo) This was connecting logged on as administrator with a trusted connection. If we tried to login as sa, we got this: Login failed for user 'sa'. (Microsoft SQL Error: 18456) If we tried to go into properties for sa, it gave the same message as above. Thanks, David

Hi All - long time reader first time poster, hope someone here can lend a hand I work as a tech support in a college using RM CC3, and an IT lecturer has asked me to look into a way that students can be taught SQL, in the locked down environment that we give them. The first problem I have is that said lecturer has written some code in Visual Basic Express, linking to a database on her network drive. SQL will not support UNC or remote accessing the database, meaning we will have to access it locally (C:\ drive) - this is no good to us unfortunately. We have thought about installing Virtual PC and then putting an image into their user area, but we are conscious that giving students an essentially free reign over a PC may have repurcussions with what they do on the network! What do you other schools/colleges/HE's do for teaching SQL? what environment and software do you use? Cheers Mark

I have created a database for cartridge stock at my school, (its a hot topic here at the moment with a lot of money being spent on printing) but I am having a few issues with Access queries. I have currently got a query which shows the cartridges in stock and how many eg Cartridge Stock --------- ------ 339 7 344 5 Etc I also have a table which shows the required cartridges (some of which wont show up on the stock list becuase the query only counts items in stock). Is there a way of combining the tables to show 0 stock on some cartridges without using VBA? Apologies if its not clear :s

Hey. I know this topic has been covered ad nauseum, but I'm building a web gateway that extracts information from SIMS's SQL Server database; but I don't want to go through SIMS to get it. That means no SIMS SDK or anything of that kind. I don't see the need for those extra levels of abstraction. I just want to connect directly to the database, run some queries, then do whatever I want with the information. I've already had some success, and the project is going pretty well. Our LEA has given us its full support. Now, we only want to pull data from the database - there will be no writing back to it. Capita are aware of our intentions, and their response was: "We don’t support the schema as that implies direct connection to the database. We would rather the school use IMS or the Command reporter." So, they would rather we do things their way - but why wouldn't they? From what my LEA has told me, much of the talk on here about Capita rescinding their SIMS support if we circumvent their software is just so much scaremongering. Anyway, regardless of the Capita issues, we've been given the go-ahead by the LEA to look into this. It's going to happen. So, I know a lot of folks have had some success in this area already (penfold_99, I believe, with Moodle integration; and the chaps at SalamanderSoft who did a lot of work for Twyneham, to name a couple); and I was wondering if anyone has managed to do any extensive mapping of the SIMS/SQL relationships, perhaps using the SQL Server Profiler or something similar to log the requests that SIMS is sending to the database. We're really looking for people to collaborate with on this; and we would be massively appreciative to anyone who has already made substantial headway into mapping the relationships who might be willing to help. I know you're out there Thanks in advance, -Gdn

I did not set up our wsus server but it has been running just fine for several years until very recently. it was grabbing a bunch of updates and became stuck. i let it run for a while before canceling it out then applying the updates.. after it had installed updates the server needed rebooting which i did. server came back online just fine and all seemed good until i tried to load wsus. it seems to stick at loading, when you click on synchronization it stays at zero. after about 3 minutes, it will flash up a screen that it cannot connect to the wsus server, reset server node or copy to clipboard. i started the sql manager and can connect to the internal microsoft sql database.forgot to mention, this wsus in on this server computer.. all on same computer.

I am setting up a backup strategy for our SIMS SQL2008 server. Am currently using the SIMS scripts to do it which is fine, but I want less data loss in the event of a failure so am putting in transaction log backups every hour (maybe 2). My question is this, which dbs do I need to backup to ensure a complete restoration is possible without loss of login usernames/passwords (this happened to us once when the server went belly up and was a nightmare). Currently setting maintenance tasks to backup the following: sims solus3_deployment_server (discover when I actually deploy it) Do I need to also back up all/any of the following? master model msdb tempdb

SQL Native Client error Common link Failure with FMS 6.138. I have a school that have Server 2003 & windows 7 laptops. They are getting intermittent issue where it sates "You have altered your system clock. It strongly recommended that you re-start module in order to ensure client/server system date/time integrity." Both the server & workstation time are same. Regional settings are all set correctly. Even reset the faults on the windows 7 laptops. There is no time syncs going on the network. I have looked at "General Network error," "Communication link failure," or "A transport-level error" as per Error message when an application connects to SQL Server on a server that is running Windows Server 2003: "General Network error," "Communication link failure," or "A transport-level error". Still no resolved. Logged call with Capita and this was given the following rubbish response:- ================================================================ Activity Date: 20/07/2011 10:31:22 Communication Type: E-mail Activity by: Bradley Cotton Emailed Customer Hi Rob, I have spoken to a colleague regarding this issue. Unfortunately there is nothing that can be done with this issue as it is an intermittent issue. The same issues occur when running FMS over a virtual machine. Apologies for any inconvenience caused.

Hello everyone, I was just wondering if there are any instructions on how to successfully setup the quotas on HAP to pull information from FSRM and how to go about configuring SQL server and HAP so that the live logins part works. Thanks in advance. J.Worth.

Hi everyone, Just started a new post at a school, looking to dig around some of the data held in SIMS to help senior level leadership. Is it possible to run reports or query the SIMS database directly without interfacing with the SIMS GUI? Right now my current workflow is to query the database using Reports -> Run Report and attaching a macro enabled excel file to manipulate data. I'm sure there's a more useful way to be doing this? I've seen some posts relating to CommandReporter, could anyone point me in the direction of some documentation for this? Thanks for your help!

SIMS Summer 2025 release doesn't support SQL20214. Has anyone Installed this release on SQL 2014? Any issues? Etc

We are looking to recruit a Senior Systems Officer to administer and develop the College's business systems, databases and processes. Working with the MIS and Exams Manager and MIS team, you will be responsible for the analysis, development, testing, documentation, implementation, and maintenance of the MIS IT systems in use across the college. You will need to be flexible in your approach and have enthusiasm for supporting and improving data and information systems and can prioritise workload effectively. You will also enjoy problem solving, be self-motivated and work well as part of a team to deliver development projects to a high standard. You will be expected to have experience of student record systems or equivalent, complex database management skills and strong SQL and/or programming skills. https://www.hopwood.ac.uk/about/jobs/senior-systems-officer

A unique role that offers a host of exceptional benefits. Applicants will need a good understanding of data in the Education sector, and will be comfortable collating, collecting, analysing and reporting our client’s data. You will be joining a well established and respected organisation and will play a vital role in helping them to continue to improve upon their current success. Role Overview The successful candidate will receive an excellent salary of up to £40,000 per annum. The role is full time, and offers a range of exceptional benefits. Benefits of the role include: up to 25 holiday days, pension scheme, life insurance, free refreshments and meals, free use of fitness suite and swimming pool, a cycle to work scheme, free car parking and a computer loan scheme. As the Data Manager you will need a clear understanding of the Data Protection Act and how it relates to data in the Education sector. You will be responsible for managing our client’s information systems and ensuring data is collected, analysed and utilised in order to drive performance. Responsibilities: Capture and analyse our client’s data to help improve performance. Improve and develop our client’s use of data and management information systems (MIS) to efficiently collate data that can be used to improve performance. With the help of the Director of Transformation and IT, keep our client’s MIS up to date and operations, and solve any issues when needed. Create data pathways between systems. Manage our client’s internal portals. Assistant with administration of data entry when needed. Develop a strong understanding of the MIS and data systems used by our client. Write reports in SSRS and product detailed analysis reports. Work with our client’s web hosting partners to integrate the MIS with our client’s intranet. Perform SQL and database updates. Plan and coordinate our client’s data capture and progress tracking system on the MIS. Import and export data from third parties. Train staff on the use of complex data. Undergo training to further develop your own data management skill set. Essential Qualifications and Experience: Previous experience in data management and ICT systems. Previous experience in database management and Microsoft excel. Excellent knowledge of relational databases. Computer literate. Knowledge and understanding of the Data Protection Act and its implications. Excellent understanding of numerical data and previous experience of analysing numerical data. Nice to have, but not essential: Degree, or similar level qualification. Analytical academic qualifications. Experience of working in the Education sector. Previous experience of MIS, and SQL. Apply Today by sending your CV to [email protected] or contact me for a call in confidence for further information. .................................................. .................. Ravi Patel Managing Director GreatFind Recruitment Tel - 020 3318 2128 Out of hours - 07904 015757 Email - [email protected] For our latest vacancies visit - http://www.greatfindrecruitment.com Follow us on LinkedIn - https://www.linkedin.com/company/greatfind-recruitment/ **APPROVED**