intuned computer unable to open programs as another user

Anne D_103 0 Reputation points
2023-04-27T22:30:38.9633333+00:00

Hi all, I hope you can help. I have two users on Windows 11 Enterprise(version 10.0.22000 Build 22000) Intuned computers (one being myself), both Azure AD joined, attempting to open Excel or Power Bi as a different user (AD domain\USERNAME). We use a bat file with the following details to open as a regular Active directory domain user to access our SQL databases.

Batch file text is as follows: C:\Windows\System32\runas.exe /netonly /user:DOMAIN\USERNAME "C:\Program Files\Microsoft Office\root\Office16\excel.exe" and a similar one for Power BI for Desktop. File works to enter password but fails on opening the Excel program or Power Bi program. Path to both files has been verified to be correct.

Both computes were completely reset through intune process/Azure AD joined, Intune logs show no errors for the two apps. Excel program opened ONE TIME as expected but after that either does not open at all or opens with error 1348:validation information class requested was invalid

We have many other users in our environment successfully working this way.

Please let me know if there is any further information you may need.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,646 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
9,413 questions
Microsoft Intune Application management
Microsoft Intune Application management
Microsoft Intune: A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.Application management: The process of creating, configuring, managing, and monitoring applications.
935 questions
Microsoft Intune
Microsoft Intune
A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.
4,949 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Crystal-MSFT 47,611 Reputation points Microsoft Vendor
    2023-04-28T01:40:30.6433333+00:00

    @Anne D_103, Thanks for posting in Q&A.

    To clarify our issue, please help to do the following test:

    1. For the two users, if we unenroll one affected device from Intune, will the issue still persists?
    2. Is there any difference between one working device and ode not working device? Did they use the same Excell version?

    If there's any update, feel free to let us know.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Limitless Technology 44,211 Reputation points
    2023-04-28T15:01:57.0566667+00:00

    Hi,

    I'd be happy to help you out with your question. Sorry for the inconvenience caused.

    I think that there might be an issue with the validation information being used to authenticate the user. Here are a few steps you can try to resolve the issue:

    Firstly, ensure that the user account being used to run the batch file has the necessary permissions to access the Excel or Power BI files. You can check the file permissions by right-clicking on the file and selecting Properties, then going to the Security tab.

    Next, try running the batch file as an administrator. To do this, right-click on the batch file and select "Run as administrator" to see if this resolves the issue.

    Check if the user account being used to run the batch file is allowed to log on as a batch job. You can check this by going to Local Security Policy -> Local Policies -> User Rights Assignment and ensuring that the "Log on as a batch job" policy includes the user account.

    Try running the batch file with the /savecred option. This will save the credentials used to run the batch file so that they can be reused in the future. To do this, modify the batch file to include the /savecred option: C:\Windows\System32\runas.exe /netonly /savecred /user:DOMAIN\USERNAME "C:\Program Files\Microsoft Office\root\Office16\excel.exe"

    Lastly, check if there are any updates available for Excel or Power BI. If there are, try installing them and see if the issue is resolved.

    If you have any other questions or need assistance with anything, please don't hesitate to let me know. I'm here to help.

    If the reply was helpful, please don’t forget to upvote or accept as answer, thank you.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.