Frazer

Hi All, Left the SIMS .net November 2007 upgrade running last night as it was taking an age to complete and this morning I found the following error on the server. sims error Your database has been restored correctly and can be used normally. The error reported was Cannot open database "SIMS" requested by the login. The login failed. Login failed for user 'sims_sysman'. The SQL Batch which caused the error was : ------------------------------------------------------------------------------------------------------------------ /* TEST Description: Unit Tests Author: Kient Date: 20/01/2005 Dataset: sims_dev_b2b_kient 1. Create Unauthorized B2B Contract begin transaction -------------------------- -- Check data -------------------------- declare @b2b_person_id int select @b2b_person_id = bb_per_export_person_id from sims.bb_per_export_person where external_id = 'aac7cbaa-96be-4195-abf4-fa64d649a6c4' print('bb_per_export_person_id: ' + convert(varchar(5),@b2b_person_id)) print('Data in Outbound') select * from sims.bb_per_export_contract where bb_per_export_person_id = @b2b_person_id -------------------------- -- Run sp -------------------------- print('Start execute') exec sims.per_pia_EditEmployee_UpdateB2BContracts @b2b_person_id, ' ' print('End execute') -------------------------- -- Check result -------------------------- print('Data in Outbound') select * from sims.bb_per_export_contract where bb_per_export_person_id = @b2b_person_id rollback transaction Result bb_per_export_person_id: 4 Data in Outbound bb_per_export_contract_id bb_per_export_person_id external_id ems_id authorised deleted unchanged comment post contract_type service_term_code start_date end_date hours_per_week payroll_number weeks_per_year termination_reason_code superannuation_code post_reason_code BIG SNIP as it wouldnt let me post it all! The first thing it says is your database has been restored - great I thought, ill just get westfield to try and do the upgrade tonight instead. When a client ran sims on their workstation it begun to upgrade and then doesnt log in giving the following error: Fault code : 1283-8946-9300 Cannot find table 20. : System.Index.OutOfRangeException I think what has happened is this: The CD Westfield sends copies across updated simsapplicationsetup.exe etc so the workstations see this and automatically update, but the database isnt patched upto the same version and thus a version mismatch and it fails. Support website says I should run the patches again but it complains about sysman being logged in and wont update, needing the SQL SA user/pass to force it. Rebooting server/restarting services doesnt rectify this and westfield isnt open till 9am Anyway I can fix this without hoping someone is at the end of the phone ~9am? EDIT: Managed to get it working-ish for now. Replaced the SIMS .net folder in program files with a non-updated workstation copy and renamed simsapplicationsetup.exe on the S drive so that it cannot be found by the auto-update. Just need the patches to be applied properly now so we can update!

Heres how I do it (probably the solution your looking for). Active Directory Users & Computers -> Create New Group (Global, Security) - Local_Admin is what i use Add the staff members in the domain to this group. Next create a group policy in the OU where your laptops/pcs are that the staff members will be using. Edit the Policy and find Startup/Shutdown (Under computer configuration, windows settings). Add a new batch file to the startup list as below: Startup.bat @ECHO OFF net localgroup Administrators /add "MYDOMAIN\Local_Admin" Change MYDOMAIN to your domain name and change Local_Admin if you didnt use that as your security group. Anyone you add to Local_Admin from now on will get Local Admin rights on the PCs in that specific OU.

Friggen whiteboard driver. Doesnt load up fully untill you login yet it halts a system shutdown when nobody is logged in. Activdriver_x32_v4.1.10.35_setup.exe - Promethean Seems this is the cluprit. Uninstall, restarts flawlessly, install and it breaks. Will try some other versions to see if they are affected too. EDIT: I only have v4.1.9 which also seems to have the same problem. 3.0 appears to be ok though.

Yeah sorry, this is the original machine that I will take the image off and duplicate to another 9 laptops. Dont want this problem transferring

We have bought some Dell Latitude D520's and ive just finished making the image - everything works fine. I came to restart the Laptop and forgot to start booting off the ghost disk, so I waited for it to get to the logon prompt, chose restart, the usual windows blurb appeared saying shutting down your computer then the screen goes blue (ive taken the backgrounds off) asif its about to shutdown, but it just halts there. Yet if i restart while im logged in it restarts fine? Ive tried it from safemode's logon box and it does restart but takes a while than it should but its ok. This leaves me to believe its driver/service related but why would it be fine when a user is logged in? Anyone come across this? any pointers? Thanks

BUMP! Ive also been having this problem for a long time (well, this is the first time Ive tried to solve it since its becoming a problem now that bbc's content is improving) Ive tried adding unrestricted anonymous access to bbc's ip's/name's but still no joy - microsoft suggest (http://support.microsoft.com/kb/288734)adding anonymous access for a client address set - which would make logging users access to other inappropriate sites a nightmare. Dont quite understand why anonymous access based on client address sets is supposed to work but based on a particular website address it doesnt. As above, I dont want to install the firewall client on the student pcs - this doesnt even work 100% of the time as I use it on my pc. Now looking to use an RTSP proxy running on ISA server with a registry fix for the proxy address to the students pcs. Any recommendations? Or other ISA fixes to try?

callumtuckey, Dont suppose you have the model name? Maybe it shows up in device manager if its not on the dongle itself? Where can we get them?

Over the Easter holidays I took the oppotunity to upgrade our pupil workstations to XP Pro SP2 (inc march/april updates) Office 2003 via a new image. Previously it was Office 2000 on XP Pro SP1 with updates. Some students are finding when they print their work, it comes out completely messed up. An example is below: On screen: Implementation of database On printout: Nslchshak, k18a 84 t,k,6,2h l, h I first printed out the document on one of our machines. This consisted of XP SP2, Office 2003, Admin logged in, no changes made to the document, HP 2200 (PCL - doesnt say what version) printer connected to other tech's pc and shared over network. This worked and the pupil went away happy. I then tried to fix the problem so that the pupil could print in their ICT suite properly next time. I tried copying and pasting the document into a new document - no joy. I then noticed at the top Word 2003 now incorperates the font into the Style field, rather than displaying "normal" and font serperately. This particular font was Veranda. I changed this to Times New Roman and the printing problem went away. To me this points to the printer supporting the font, but Veranda has been used in the past and has not caused any problems. This particular printer is a HP2300N (PCL 5e) which is installed as a 'local' printer on our Windows 2000 Server using TCP/IP port and then shared to the pupils. Does this point to a problem with Office 2003? Could something have messed up while copying the printer drivers over on first use?(we did this logged in as admins after ghosting) Has anything major been changed from SP1->SP2 in the way that XP handles printing? Any suggestions would be appreciated

@Ric Haha. Just wait till we get our 2nd specialism There is a reason I allow this ONE particular SMT member to 'walk all over me'. This one is my direct boss and apart from going to the Head, is next in line. If something is becoming difficult or awkward I can goto this person and they will bend over backwards to help me, unlike others who are only out for themselves. @artram: thanks for the link, will take a look today.

How did it go from robbie williams to where I work? As it 'appens! I work @ Hodgson in Blackpool/Poulton (Lancs). It was a member of SMT that asked me for the video - she saw it at a presentation and wants to use it for something of her own. I dont think its supreme. Its even more difficult because she cant remember the exact content other than robbie williams and films and then its difficult to get hold of her to say yay or nay to any I find!

Bit of an odd request this one! One of my boss's has asked me to source a robbie williams music video for them. It was ~2002 when they saw it and they swear blind that the video contains Robbie acting out a few different movie scenes. I showed them Millenium (~3min ver) and that doesnt seem to be the one. Anyone any ideas which it could be?

On the domain controller set "Microsoft network server: Digitally sign communications (always)" to Disabled. Start > Administrative Tools > Domain Security Policy > Security Settings > Local Policies > Security Options > in here! Alternatively a member server (not a DC) _should_ work without disabling this setting (move the image there)

There is a policy in 2K3 that stops insecure clients from authenticating (DOS), we had exact same problem! ..goes off to find it..

I set ours up like this for last years 'year 7': \\server\users\2005intake\%username% Users shares permissions are: everyone full access Users folder permissions are: domain admins full access only 2005intake folder permissions: domain admins full access only %username% is autocreated when you make the account, giving the user full access and permissions filterting down from users\intake to give domain admins full access. This stops them snooping around your user folders and also stops them saving random files to the users\intake folder instead of their homedir.

We are having a similar problem here. I rolled out a new version of our registration system (PARSql to Pars.net) using Group Policy->Computer Configuration->Software Settings->Software installation. After I did this I added a new line to the staff logon script to check that they were all getting the software installed. if exist "c:\program files\pars\bootstrap.exe" echo %DATE%,%TIME%,%USERNAME%,%COMPUTERNAME%,Yes >> \\hhapps\vars$\pars.txt if not exist "c:\program files\pars\bootstrap.exe" echo %DATE%,%TIME%,%USERNAME%,%COMPUTERNAME%,No >> \\hhapps\vars$\pars.txt What I found was that some staff laptops werent even processing this new part of logon script to output to my text file and others werent even getting pars installed. Its was a mixture of dell(d505) and toshiba(1400/2100) with the same image across the board for each (so network drivers etc are the same). To me this says that the group policy wasnt being updated properly (even over a period of one week) or that the network interface wasnt getting a connection quickly enough - this is still ongoing. We used to be able to login to the domain as soon as the login box appeared, now you have to try 2 or 3 times before the domain becomes available - This started around January. Another problem is that some network points cant get a connection at all one day then its perfectly fine the next - tried patching into a different port and even a different switch - still the same. One thing I have found is when one particular room works, another does not, then they swap round. Its proving very hard to track because people arent reporting it often enough and wont log it themselves. HELP (perhaps I should have started my own thread, but its semi-related )

Thanks! I really need to read up on vbs scripting, living in the dark ages using batch files!

Thanks. Can you modify that slightly so that it will copy them in sequence, ie copy files -> folder 1 copy files -> folder 2 instead of opening multiple instances of xcopy at the same time? Just incase I run into the same problem of the database being copied at the same time and locking.

The permissions/attributes arent a problem, after the file is copied across, the student has full control of the file and the file is not read only, there are no deny permissions. They still get the message that the database is read only. Students folders are arranged as intake years (since year 7 turns into year 8 etc), eg d:\users\2001intake (current year 11). Not too sure how to get a batch file to loop round all folders inside the intake folder to copy the files though. PS I was using 'copy' and have switched to 'xcopy', ive yet to see if this makes a difference

Thats a good idea, but I think ill run into a similar problem that Im currently getting. One of the files is a Database which seems to get screwed up when multiple people start copying at the same time (im guessing it gets locked while a few people are copying it across to their area). When its done copying across some people can open it normally and others get 'this database is read only bla bla bla' File permissions are fine for the student after copying and file is not set to read only. On top of that, for exam use, id like to have it done and working before the minute the exam starts to find out its not worked.

Has anyone written a script that has the following: 1. Ability to browse or change in code, the location of some files, eg d:\files-to-copy 2. Read all the users in a specific OU (eg, 'Year 10'), extract their home directory from active directory 3. Copy all the files from (1) to (2) in sequence? Ive written a lame way of doing it in a batch file but its just not reliable so I need it to read through all the Users in an OU and grab their home directory that way. Thanks

Thats the one thanks.

Our SIMS officer is going through the curriculum processes for creating a new accademic year. She is currently doing the 'mapping' (promoting year 7->8, 8->9 etc). It takes about 5minutes to save her changes to the database and every time she does this the SQL database becomes unresponsive to everyone else, meaning no PARS (registration) or SIMs access. Anyone else doing this? Ideas? Can anyone tell me the sims.net support forum address, ive lost it \o/ Dont you just love those all or nothing days, today is 'ALL'.

Sorted. You will need to print out Test Protection Codes though. http://www.rm.com/Security/Login/formslogin.asp?url=/Support/TechnicalArticle.asp&QS=cref%3Dtec564991%26nav%3D0

Has anyone managed to setup the DPS software on some staff laptops while disconnected from the network? Ive so far got the software installed, with the 2006 materials/tests, but I am unable to get it to allow me to run the practice tests (the anonymous configuration option doesnt seem to have helped) without being connected to the APS server. So, what im after is: Laptop, unplugged from network Staff member logging into laptop locally, running software Staff member running through the practice tests / familiarisation material (preferabley without having to enter codes for login) EDIT: Just re-read that, I dont mean scheduled practice tests, I mean on the Practice menu, running any of the 3 materials.

We are well past 87 reservations and have no problems accessing the DHCP console! (remotely or on the DHCP server itself)