Share via

How deploy copilot using Vscode when running PowerBI backend?

Garrett Settles 0 Reputation points
2026-02-25T22:25:54.2266667+00:00

I'm hosting a 2022 SQL Server Adminstrator on an Office instance of m365, but the boot screen doesn't allow for adminstrator privelege access for the powerbi backend. How to fix?

SQL Server | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yutaka_K_JP 1,655 Reputation points
    2026-03-08T09:44:16.75+00:00

    I think ur issue comes from the M365‑join dropping elevation before SQL wakes, so a single login with real local‑admin to bring the SQL svc up is the cleanest fix… and giving PowerBI read/exec on the share early avoids the next stall.

    0 comments
  2. Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator
    2026-02-26T06:30:12.77+00:00

    Hi @Garrett Settles ,

    When hosting SQL Server 2022 on M365 Office instance, the boot screen doesn’t allow administrator access for Power BI backend.

    1. Run SSMS as Administrator: Right-click SQL Server Management Studio and choose Run as Administrator to get full access.
    2. Check Permissions: Ensure your SQL login has sysadmin rights. In SSMS, go to Security > Logins and verify that the correct account has sysadmin role enabled.
    3. Power BI Access: Make sure the Power BI service has the right permissions to connect to your SQL Server. Use either Windows or SQL Authentication depending on your setup.
    4. Network/Firewall: Double-check that no firewall rules are blocking the connection between Power BI and SQL Server.

    If this doesn’t fix it, take a look at the error logs in both Power BI and SQL Server for more clues.

    Hope that helps. Let me know if you need further details.

    Thanks,

    Akhil.

Your answer

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