Paul-K

We had this same issue with the HP 255 G7 devices and I have recently been testing after going back and forth between HO, Microsoft and AMD but think this is now working. We had to update the BIOS to the latest version from the HP site, I also updated the device to Windows 10 21H2 prior to provisioning the device for Intune but as it’s now half term I’ve not managed to test another device, I am looking to do another few next week to test fully. I am now having the same issue with tue last batch we received from the DfE which are HP 245 G8 devices. It seems anything with an AMD processor is the problem, something to do with the certificates as it doesn’t present them correctly.

Cheers for the reply DPenfold, I actually managed to solve it myself yesterday but until it had been tested I didn't want to post a reply, I used a slightly different method but got the URL Rewrite to work correctly in the end. I basically added two URL rewrites to the Default Web Site in the end, one to direct the traffic to HTTPS and one to append /hap onto the URL so that the Default Internet Information Services page doesn't come up when if they typed https://folders.schooldomain.com, now regardless of what they put in http/https or just folders.schooldomain.com it will still redirect to https://folders.schooldomain.com/hap/login.aspx, here is the code from my web.config showing the URL Rewrites I used. Hopefully this may help someone else in the future.

Hi all, I have setup HAP for another school but am having issues with the URL Rewrite, I have setup a dedicated sub-domain for HAP+ (folders.schooldomain.com) and have setup a URL Rewrite on the Default Web Site to redirect all HTTP traffic to HTTPS. The above works if I type folders.schooldomain.com it redirects to https://folders.schooldomain.com/hap/login.aspx?ReturnUrl=%2fhap which is fine, but if I type https://folder.schooldomain.com it shows me the default IIS page rather than redirect, I realise this is because the request is already HTTPS so doesn't redirect based on the rule but how can I get all requests to folder.schooldomain.com regardless of weather they are HTTP or HTTPS to go to https://folders.schooldomain.com/hap/login.aspx?ReturnUrl=%2fhap Many thanks in advance

@nickbro That's perfect Nick. I've applied the upgrade and all working again. Thanks again

@nickbro Hi Nick, is there a quick way to disable direct edit so that I can fix it for now or am I best to revert back to my previous install?

I have the same issue described above after upgrading to 10.3, I also have the same error when just trying to upload a file even if I am not using the direct edit feature though. I also receive the same error in the server logs.

@nickbro Office 365 uses TSL on port 587 and the SMTP address is smtp.office365.com Would it make a difference that Office 365 uses TSL rather than it's predecessor SSL? Would HAP just work with TSL if SSL was turned on? Just a thought.

@nickbro Hi Nick, sorry to bother you but do you know if this is possible to pass the logged in HAP+ credentials onto Office 365 to log a user into their mail?

Hi again, Does anyone know if this is possible? And how to start setting it up if it is possible?

Hi All, We have moved to Office 365 for our email today and I was wondering if it's possible to have SSO from HAP+ to Office 365 so that mail users can login to HAP+ and click the OWA link and it would take them straight into their mail using the credentials used to login to HAP+. All users have the correct email address provided in AD. Thanks in advance.

@fairm010 I didnt change that as I had it set to localhost but I've just changed it now to servername\SQL instance and that's sorted it. Don't suppose you know why I can't use localhost now thought? Does it need to have an alias set for the SQL instance to be set as localhost?

@nickbro Hi Nick, I have installed dirsync for Office 365 today which wanted to install a fresh version of SQL so I took a backup of the HAP database and restored it once dirsync install had complete, the original SQL instance was called SQLEXPRESS, the new one was named automatically by the install as MSONLINE. The restore of the database to MSONLINE has gone fine and all the tables are there but HAP+ won't login, it's showing the below SQL connection error. I have added the IIS AppPool to SQL, I have enabled named pipes and tcp/ip for the SQL server and when I type SQLCMD - L in command prompt, the server is in the list, I have also changed the SQL connection in IIS, is there anything I need to change in the HAP files because it already registered itself to another database name or something like that? Your help is appreciated

Cheers Nick, that sorted it.

@nickbro Would this feature request be possible or is this something only Microsoft Exchange can offer due to the way it integrates with AD?

@nickbro Hi Nick, Think I may have stumbled on a little glitch. I can copy and paste from folder to folder but if I try to cut and paste it does nothing. Please see screenshot below showing the firebug results.

@mattgrimley Hi Matt, you will need to use the HAP.sql file from the HAP+ Web Core v10.1 Update, this is the latest one which includes the column called hide in the note table. I would recommend dropping the three tables that have been created, Note, NoteFiles and Tickets providing that they are empty and running the HAP.sql again as it will error otherwise. You will need to delete these in a specific order as they depend on each other, I believe I did NoteFiles, Note then Tickets. I also took a backup of my HAP database to be sure but didn't need it. Hope this helps

Cheers Nick, that sorted it, all working perfectly now.

Have replace with the latest Help Desk update and now get the below error, the help desk is also no longer showing any of my tickets but they are still in the file tickets.xml

I'll try it now and post results, cheers Nick

I've just gone into the database and checked the three new tables and there is no information in any of them. It also still shows the option to migrate to SQL which I presume will disappear once it is using SQL as it did with the tracker. I've removed the tickets.xml and I receive the error 'Could not find file '\App_Data\Tickets.xml'.'

Cheers Nick, Sorry to be a pain as well but I've done the complete upgrade with the latest HAP+ v10.0, HAP+ v10.1, booking system and help desk v4, all of the upgrades have been completed, my HAP.sql has been run and I have changed the provider="SQLConnectionString" in HapConfig.xml file but when I click Migrate to SQL in the help desk, nothing seems to happen and it continues to use the XML file. Any Ideas?

@nickbro Just had a quick look through the SQL and it seems to be missing the NOT before EXISTS in the below statement which is what then drops the table. /****** Object: Table [dbo].[WebTrackerEvents] Script Date: 03/12/2011 17:44:19 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WebTrackerEvents]') AND type in (N'U')) DROP TABLE [dbo].[WebTrackerEvents] GO

@nickbro Hi Nick, great job on HAP+ v10. Just a quick one, I have run the latest HAP.sql to add the tables for the help desk but it seems to have cleared all my tracker/web tracker events during the process. I took a backup of my database before I upgraded so can restore the data, but is the script supposed to clear all the tables?

@mattgrimley Hi Matt, thanks for the response, I did notice some development from Nick on the codeplex site with regards to code that checks the UserAccountControl attribute in AD and was hoping it might now be possible to do the same as OWA in HAP+ and allow for changing of expired passwords directly through HAP+. Unfortunately I don't have an Exchange server so would be unable to forward to the OWA page as you are looking to do. @nickbro Is this a possibility for HAP+ or is this functionality only available directly with OWA and Exchange 2010 and above?

@nickbro Hi Nick, Is it possible to implement the same functionality as OWA and have the ability to change expired passwords? The website below shows how this can be done in exchange but I wasn't sure if this would be possible to implement on any other system. Blogs - Exchange Team Blog - Site Home - TechNet Blogs