BatchFile

I've got the ReportSender spreadsheet from the SIMS Success Team (here). Run by itself, by double-clicking, it works fine through Outlook, but as a scheduled taks, it doesn't. I'm therefore exploring the SMTP option. The macro code I've got for that bit is as follows: Sub send_mail_SMTP() Dim CDO_Mail As Object Dim CDO_Config As Object Dim SMTP_Config As Variant Set CDO_Mail = CreateObject("CDO.Message") On Error GoTo Error_Handling Set CDO_Config = CreateObject("CDO.Configuration") CDO_Config.Load -1 Set SMTP_Config = CDO_Config.Fields With SMTP_Config .Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 .Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "smtp.office365.com" .Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 587 .Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1 .Item("http://schemas.microsoft.com/cdo/configuration/sendusername") = "[email protected]" .Item("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "MyP@55w0rd" .Item("http://schemas.microsoft.com/cdo/configuration/smtpencryption") = STARTTLS .Update End With With CDO_Mail Set .Configuration = CDO_Config End With CDO_Mail.Subject = ThisWorkbook.Sheets("Set up").Range("B9") CDO_Mail.From = ThisWorkbook.Sheets("Set up").Range("B6") CDO_Mail.To = ThisWorkbook.Sheets("Set up").Range("B7") CDO_Mail.TextBody = ThisWorkbook.Sheets("Set up").Range("B10") CDO_Mail.CC = "" CDO_Mail.BCC = "" CDO_Mail.AddAttachment thepath + "" + reportname + ".xlsx" CDO_Mail.Send Error_Handling: If Err.Description <> "" Then MsgBox Err.Description End Sub but it's failing with "The Server rejected the sender address. The server response was: 451 5.7.3 STARTTLS is required to send email" Any ideas, anyone?

I can answer this one for myself now I had Capita on Remote as I was having problems applying a patch - and it needed to be applied as SA. They reset the password for me (after an email of authority from SMT), by running a query and we've had no ill effects. So in my case at least, the answer is no, it won't break SIMS, if it's done like that

I'd like to change the SA password on our SIMS server. They guy that set it up has left, without leaving a record of what it was. It looks as if I can do it by going into SQL Management Studio using Windows Authentication - but I'm a bit worried as I'm not sure of the consequences! Is there any reason why I shouldn't do it by expanding Security > Logins, then right clicking on sa, selecting properties and entering a new password? Anything to watch out for? Then I can get on with scripting a DbAttach backup that can run without stopping the server:confused2:

I've just logged a change request for SIMS to import the batch XML files produced by the LRB. I've more confidence in that working than S2S being fixed 1710-3701211 if you'd like to vote on it Maybe @PhilNeal could give it a nudge for us...?

SIMS Teacher app is down due to an "Azure Service Relay Bus" issue... Methinks there's a connection there and this is two symptoms of the same M$ issue. Perhaps. Which doesn't get us any closer to fixing it :-(

Problems here (Cumbria) - getting a lot of this:

I've got a feeling that the only app currently available is for teachers - If not, please do let me know as we're just rolling out SLG homework here and are encountering "teething issues" with the web part not displaying correctly on a non-English O/S (and we're a boarding school with 40% international pupils!)

+1 for Ruckus - great kit - access points are like cockroaches - you can't kill 'em. One fell off the wall (was 10ft up) - top cover popped off when it hit the concrete floor; clipped it back on and it's fine. Another one, the PSU (external) died, replaced it with a non-oem one and accidentally reversed the polarity:doh: - got smoke out of the AP; disconnected, corrected polarity, plugged back in and that's fine too.

All Harry Potter here. As I'm leaving soon and we're recruiting a replacement for me (see: http://www.edugeek.net/forums/educational-jobs/154007-ict-technician-support-manager-cartmel-cumbria-25440-27123-a.html), I tried and failed to get "in depth knowledge of JK Rowling's novels" included in the person spec... but the Head wouldn't go for it

This is my current position, I've been here almost 15 years (with a 2 and a bit year gap in the middle but that's another story). I'm only leaving as I've got a better position paying more, closer to home; I'm definately not leaving "under a cloud", the management are great as are the staff and pupils. You're left to get on with it most of the time, but the support's always there if you need it. It's a smashing, REALLY varied network manager type position in a small, but secure future-wise, 11-16 secondary school in a beautiful area close to the Lake District. I really want to find the right person as I've got a lot of me invested here; it was my first "proper" job after uni and my Dad came here as a pupil, I've grown the network from 50 computers when I arrived in 2000 to over 300 now. I'd love it to go to someone on here as this is where a large chunk of my knowledge has come from over the years. Please feel free to DM me or reply below with ANY questions about the job or the area - and let me know if you're applying. (I'll edit this in a minute with a link to the website, where you can get the person spec, application form etc. My techie's just putting it up now!) Edit: HERE IT IS: http://www.cartmelpriory.cumbria.sch.uk/page/it_technician_and_support_manager

That's kind of what I thought; the router's taken it and trying to route it, then when it gives up it sends it back as unreachable... which presumably takes longer than my ping timeout interval most of the time. But if that's all it was wouldn't increasing the /w to 2000 or 4000, instead of the default 1000, mean more unreachables and fewer timeouts? I tried it and It didn't make a noticable difference... Unfortunately (!) the connection's fine again today and I don't really want to unplug it to play with it now as that would be unpopular!

Can any of you educated types shed any light on a little (and I mean tiny!) networking anomaly for me? Our internet connection was down yesterday (or "the internet's not working" as our users say - "I think you'll find it is, but our connection to it might not be" is my reply, but I digress), caused by a power cut at the next hop along to us. I set a "ping" going, pinging the LEA filters so I'd immediately see when it came back, which looked like the attached picture: The question is, why do most packets return "request timed out", while one in 10 or so get "reply from 10.105.16.1: destination net unreachable"? 10.105.16.1 is the default gateway and I'm only pinging every second or so - so why are they not all one response or the other? It messes up the statistics as it records the "reply from"s as a recieved packet not a lost one... but that's about as inconvenient as it gets. I've tried messing around with the wait time (/w) but it doesn't seem to make a difference to the ratio of "timed out"s to "reply from"s...

And that's my main gripe with 8.x for workstations - we don't wany big pretty apps on the home page, we want a nice, serene desktop to start work and a sensible start menu to select from, in the school environment. Just like XP. Or 7 if you must.

it maybe is NOW - but in that original version it was missing and I had to google a workaround:rolleyes: (I don't THINK it was a beta...)

Nope, and I hope not to for a while having installed the RTM of 8 early on just to have a look - It was a while ago, but I was astounded by what was missing (like a GUI to change the computer name and join the domain - ended up doing it from a command line IIRC) and the fact that, due to being behind a proxy, nothing on the front page full of apps worked. I dare say these issues have since been fixed, but it was at that time that I decided Linux was the way we would probably be going for curriculum use; I just don't like the way MS are heading anymore. Just my opinion, but these are my experiences summarised: NT4 - solid as a rock but lacking certain features (like USB support) XP - Worked. Easy to deploy and administer. Adequately featured Vista - Cluttered and unstable 7 - Adequate, but bloated and a backward step from XP deployment wise - sysprep a joke 8 - Didn't work. Released before complete. Crazy UI without start button, have to press Win+X to get it to do anything sensible.