Access Denied Error while open SQL Server Business Intelligence Studio using service account

BeUnique 2,332 Reputation points
2023-03-21T11:56:31.72+00:00

I am trying to open SQL Server Business Intelligence Studio using service account.

I am getting error "Access is denied".

Service account already have the server admin access.

Normally i used admin account to open the SQL Server Business Intelligence Studio. It's working fine.

But, when i tried to open using service account, i am getting "Access is denied" error.

What is the problem and i have been facing the issue for a long days.

SQL Server Integration Services
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 47,586 Reputation points
    2023-03-22T06:39:14.3033333+00:00

    I am trying to open SQL Server Business Intelligence Studio using service account.

    And what could that be good for; don't make any sense?

    BIDS is a tool/GUI and that requires mostly a user profile; service account's don't have one.

    1 person found this answer helpful.
    0 comments No comments

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.