Needs to uncheck sysadmin role of domain user in SQL Server

33 Views Asked by At

We've established connections between SQL Server views and Excel, utilizing pivot tables within Excel sheets for data analysis. Recently, we were directed to modify the sysadmin server role of a domain user. However, encountering an obstacle emerged when we attempted to revoke the sysadmin role from the domain user – following this action, the Excel report ceased to refresh. The requirement is for the Excel report to refresh even without the sysadmin role, presenting a challenge in this scenario

0

There are 0 best solutions below