Home

Office 365 Pro Plus - Excel installed on RDS server keeps prompting for credentials

%3CLINGO-SUB%20id%3D%22lingo-sub-745329%22%20slang%3D%22en-US%22%3EOffice%20365%20Pro%20Plus%20-%20Excel%20installed%20on%20RDS%20server%20keeps%20prompting%20for%20credentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-745329%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BWe%20recently%20deployed%20Office%20365%20Pro%20Plus%20on%20our%20RDP%20server%20and%20purchased%205%20licenses%20for%20individual%20users.%20They%20use%20Excel%20mainly%20via%20export%20from%202%20remote%20apps.%20Sage%20and%20QuickBooks.%20We%20successfully%20launched%20Sage%20and%20started%20an%20export%20to%20Excel%20which%20prompted%20each%20user%20to%20sign%20in%20to%20Office%20365%20with%20their%20unique%20account.%20After%20signing%20in%20everything%20worked%20properly%2C%20and%20also%20worked%20in%20QB.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BThe%20issue%20is%20that%20Office%20365%20randomly%20asks%20user%20to%20re-authenticate%20when%20exporting%20to%20Excel%20via%20the%20remote%20app.%20This%20is%20an%20annoyance%20inside%20of%20Sage.%20The%20bigger%20issue%20is%20that%20the%20sign-in%20pop-up%20doesn't%20appear%20in%20QB.%20It%20just%20crashes%20the%20app%20which%20requires%20an%20admin%20to%20login%20to%20the%20RDP%20server%20and%20forcefully%20sign%20the%20remote%20user%20out%20of%20the%20server.%20That%20user%20then%20needs%20to%20sign%20in%20to%20Sage%2C%20prompt%20an%20export%20to%20Excel%2C%20sign%20in%20to%20Office%20365%2C%20and%20then%20export%20to%20Excel%20in%20QB.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BThe%20minor%20issue%20is%20the%20Office%20365%20sign-in%20prompt%20not%20showing%20in%20QB.%20The%20bigger%20issue%20is%20the%20repeated%20need%20to%20sign-in%26nbsp%3B%20to%20Office%20365.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20stop%20this%20from%20happening%3F%20From%20preventing%20the%20need%20to%20re-authenticate%20after%20the%201st%20sign-in%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-745329%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-746945%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Pro%20Plus%20-%20Excel%20installed%20on%20RDS%20server%20keeps%20prompting%20for%20credentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-746945%22%20slang%3D%22en-US%22%3ELooks%20like%20the%20account%20which%20Office%20uses%20is%20not%20properly%20signed%20into%20when%20the%20RDP%20instance%20launches.%20Perhaps%20these%20links%20help%3F%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Fwindowsserver%2Fen-US%2Fb07b2a6e-5833-41a8-b66a-d26a2bd0aaef%2Foffice-365-on-rds%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Fwindowsserver%2Fen-US%2Fb07b2a6e-5833-41a8-b66a-d26a2bd0aaef%2Foffice-365-on-rds%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdeployoffice%2Fdeploy-office-365-proplus-by-using-remote-desktop-services%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdeployoffice%2Fdeploy-office-365-proplus-by-using-remote-desktop-services%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-747319%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Pro%20Plus%20-%20Excel%20installed%20on%20RDS%20server%20keeps%20prompting%20for%20credentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-747319%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20and%20no.%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20users%20do%20not%20log%20in%20directly%20to%20the%20RDS%20server.%20They%20only%20have%20access%20to%20the%20remote%20apps.%20The%20sign-in%20window%20doesn't%20appear%20on%20a%20set%20pattern%20that%20I've%20noticed%20yet.%20Not%20when%20the%20server%20reboots%2C%20and%20not%20when%20I%20need%20to%20forcefully%20log%20a%20user%20off%20of%20the%20server.%20Users%20can%20only%20access%20MSOffice%20apps%20when%20they%20try%20to%20export%20from%20Sage%20or%20QB.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20have%20Microsoft%20Support%20install%20Office%20365%20ProPlus%20on%20the%20RDS%20server.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-747370%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Pro%20Plus%20-%20Excel%20installed%20on%20RDS%20server%20keeps%20prompting%20for%20credentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-747370%22%20slang%3D%22en-US%22%3EIn%20that%20case%20I%20would%20suggest%20to%20get%20hold%20of%20MSFT%20support%20and%20tell%20them%20they%20did%20a%20poor%20job%2C%20this%20issue%20should%20(IMHO)%20not%20exist.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-747374%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Pro%20Plus%20-%20Excel%20installed%20on%20RDS%20server%20keeps%20prompting%20for%20credentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-747374%22%20slang%3D%22en-US%22%3EHaha%2C%20the%20sad%20part%20is%2C....%20I%20did.%20They%20referred%20me%20to%20this%20community%20for%20expert%20support.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-747377%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Pro%20Plus%20-%20Excel%20installed%20on%20RDS%20server%20keeps%20prompting%20for%20credentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-747377%22%20slang%3D%22en-US%22%3EWow.%20Sad%20indeed.%20I%20have%20notified%20the%20Excel%20team%20about%20this%20one%2C%20I%20find%20it%20unacceptable.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-747385%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Pro%20Plus%20-%20Excel%20installed%20on%20RDS%20server%20keeps%20prompting%20for%20credentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-747385%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20awesome%20help%20Jan!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-747472%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Pro%20Plus%20-%20Excel%20installed%20on%20RDS%20server%20keeps%20prompting%20for%20credentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-747472%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373512%22%20target%3D%22_blank%22%3E%40jonb12345%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10827%22%20target%3D%22_blank%22%3E%40Smitty%20Smith%3C%2FA%3E%26nbsp%3Bwould%20you%20please%20help%3F%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECuong%3C%2FP%3E%0A%3CP%3EMicrosoft%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-747535%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20Pro%20Plus%20-%20Excel%20installed%20on%20RDS%20server%20keeps%20prompting%20for%20credentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-747535%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
jonb12345
New Contributor

Hello,

 

 We recently deployed Office 365 Pro Plus on our RDP server and purchased 5 licenses for individual users. They use Excel mainly via export from 2 remote apps. Sage and QuickBooks. We successfully launched Sage and started an export to Excel which prompted each user to sign in to Office 365 with their unique account. After signing in everything worked properly, and also worked in QB.

 

 The issue is that Office 365 randomly asks user to re-authenticate when exporting to Excel via the remote app. This is an annoyance inside of Sage. The bigger issue is that the sign-in pop-up doesn't appear in QB. It just crashes the app which requires an admin to login to the RDP server and forcefully sign the remote user out of the server. That user then needs to sign in to Sage, prompt an export to Excel, sign in to Office 365, and then export to Excel in QB.

 

 The minor issue is the Office 365 sign-in prompt not showing in QB. The bigger issue is the repeated need to sign-in  to Office 365. 

 

Is there a way to stop this from happening? From preventing the need to re-authenticate after the 1st sign-in?

 

Thanks in advance!

8 Replies

@Jan Karel Pieterse 

 

Yes and no. 

Our users do not log in directly to the RDS server. They only have access to the remote apps. The sign-in window doesn't appear on a set pattern that I've noticed yet. Not when the server reboots, and not when I need to forcefully log a user off of the server. Users can only access MSOffice apps when they try to export from Sage or QB.

 

I did have Microsoft Support install Office 365 ProPlus on the RDS server.

In that case I would suggest to get hold of MSFT support and tell them they did a poor job, this issue should (IMHO) not exist.
Haha, the sad part is,.... I did. They referred me to this community for expert support.
Wow. Sad indeed. I have notified the Excel team about this one, I find it unacceptable.

@jonb12345 @Smitty Smith would you please help? 

 

Thanks,

 

Cuong

Microsoft

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies