[ms office - 2013] Logging into Office 365 Sharepoint from Office 2013

[garethEds]

Morning all,

 

We have Office 2013 Pro on our machines as part of our deployment image. It's worked and we are happy with it. It's customised through GPOs etc.

 

We now have pupils with Office 365 who all have access to OneDrive for Business to store their documents should they need to. This is part of the free Office license that comes with EES.

 

The problem I am having is that we simply cannot sign into our OneDrive for Business when we try and add a service. The service is setup and I can access it all through login.microsoftonline.com

 

What am I missing? Is there a GPO I need to check? Interestingly enough we can sign in through the Office app on our iPads.

 

Any help is appreciated.

 

Thanks

 

Gareth

[Michael]

Is this anything to do with adding the likes of:

 

https://*.live.com
https://*.lync.com
https://*.microsoftonline.com
https://*.office.com
https://*.office365.com
https://*.outlook.com
https://*.sharepoint.com

 

To Trusted sites? You can do this via GPO:

 

User Config > Policies > Admin Templates > Windows Components > Internet Explorer > Internet Control Panel > Security Page - Site to Zone Assignment List. Add them all with a value of 2.

[garethEds]

Thanks Michael - all done but no change.

 

Not sure if it is related - but Word 2013 is showing me (on the right hand top of the screen) that I am logged in with my Office365 username and password. But I cannot see my Office365 OneDrive/SharePoint bit to open files.

 

I thought it would just be a case of Adding a Service. Time to ask Microsoft. @EduTech are you about?

 

Gareth

Edited July 9, 2015 by garethedmondson

[Michael]

I'm currently using a Powershell script to map OneDrive as a network drive with Office 2010, but workable from any application... not sure if Office 2013 is the same. Don't you still need to configure the OneDrive App separately?

[garethEds]

I'm not sure @Michael - could I see or grab a copy of the script?

 

I assumed that Word 2013 would let me add the service from within the application without the need for a separate application. This is OneDrive for Business.

 

Gareth

[Michael]

Have a look here

[garethEds]

I'm not entirely sure why this isn't working. I spoke to the Office 365 support guy on Friday and he told me I was running the wrong version of Office. I need to install the Office 365 version. Uh??? What???

 

I told him we were using the volume license edition etc and his response was that I should try and speak to the Office 2013 team - as this isn't an issue for the Office 365 team.

 

I don't get what the problem is.

 

Gareth

[Michael]

Hmm I don't think that's correct - there's OneDrive with Outlook/Hotmail and there's OneDrive for Business with Office 365.

 

I think Microsoft are somewhat silly in branding everything Office 365, as it causes mass confusion.

 

I know that the client included with Windows 8.1 is for OneDrive with Outlook/Hotmail, but it's unclear which version is included with Office 2013.

 

Again you'd think irrelevant where you're signing in from, Microsoft would be able to code it all from one client.

[garethEds]

Tell me about it @Michael - the weird thing is that within Office 2013 I have the option to add Office 365 SharePoint - which is what I assumed we were using. In every other version I use I can sign in (Mac/iPad etc).

 

It is slightly annoying when all I want to do is add a service. It was setup a while ago by me on the network so I'm wondering whether I have knocked a GPO setting somewhere. Time to go through them with a fine toothpick.

 

I'll come back here when I get two minutes.

[garethEds]

Need an Office 365 specialist to contact me.

 

GJE

[garethEds]

Okay - more updates.

 

Windows 8.1 running Office 2013 can log into our OneDrive for Business without any issues from within Word 2013

 

Windows 7 cannot.

 

I've turned off our Office 2013 GPO to see if there was a funny setting somewhere - not to be. Still receiving an error message.

 

Hair.Pulled.Out

[Michael]

Is this anything to do with the WebClient service? It is disabled by default in Windows 7 but not Windows 8.1 or Windows 10.

[garethEds]

Is this anything to do with the WebClient service? It is disabled by default in Windows 7 but not Windows 8.1 or Windows 10.

 

Nope. Set the GPO to turn it on across the site and to start it automatically.

 

Been trying other stuff... I have a personal account and an Education account both with the same email addresses. I thought it would might make a difference - but alas it doesn't.

 

So my username @ can log into the OneDrive Personal side - no issues at all. It works and becomes a location. Happy with that.

 

My school account - same login but with different password after choosing the Work option within Word 2013 - no go. WIll not let me log in.

 

All on Windows 7. Tried the same on 8.1 and it all worked.

 

Oh well. I'm ploughing through Google now. I'm not sure what setting would stop it. All the domains are in trusted locations, all the domains are passing through our SmoothWall - and all the accounts work (after checking them through the browser and through 8.1 machine + ipads)

 

Gareth

[garethEds]

So further updates - we have no idea what is going on. Something somewhere is stopping Office 2013 from logging into our Office 365 cloud storage. In addition I've discovered today that it also stops me logging into my Hwb Cymru Office 365 storage as well - yet we can get into the personal one.

 

I've run through our GPOs, disabling them, re-logging on etc etc - but all the same.

 

I've checked accounts and passwords - all works on a clean internet feet (at home). We've confirmed that it works on @rich_tech 's Windows 8.1 machine in work (which has no GPO inheritance except for some LEA ones).

 

So unless anyone can suggest a GPO setting that might be stopping this then I'm going to shut the book on it.

 

Gareth

[garethEds]

All sorted. Working with the LEA we disabled our SmoothWall access and it went straight through. Seems there is an issue with authentication. I then remembered the SmoothWall forum on here and found a possible answer:

 

http://www.edugeek.net/forums/smoothwall-direct-support/111398-office-2013-wont-add-sharepoint-online-links-backstage-without-auth-exception.html

 

So LEA guys put the settings in and bam - it worked.

 

Strange though that Wndows 8.1 didn't need these settings changed.

 

Thanks @Michael for your help with this as well (and anyone else)

 

Gareth

[Michael]

All sorted. Working with the LEA we disabled our SmoothWall access and it went straight through. Seems there is an issue with authentication. I then remembered the SmoothWall forum on here and found a possible answer:

 

http://www.edugeek.net/forums/smoothwall-direct-support/111398-office-2013-wont-add-sharepoint-online-links-backstage-without-auth-exception.html

 

So LEA guys put the settings in and bam - it worked.

 

Strange though that Wndows 8.1 didn't need these settings changed.

 

Thanks @Michael for your help with this as well (and anyone else)

 

Gareth

 

One possible explanation is that Windows 8.1 channels everything down ports 80/443, whereas Windows 7 may use a random port that needs opening.

 

Glad you got to the bottom of it, I didn't think it would be a firewall/port issue to be honest.