Forum Discussion

misaki233's avatar
misaki233
Helper II
5 years ago
Solved

Unable to create a report server database

Hi , I came up with a problem when I was configuring the RS. User does not have permission to perform this action.   System.Data.SqlClient.SqlException (0x80131904): User does not have permis...
RS
  • FarhanAhmed's avatar
    FarhanAhmed
    5 years ago


    Login to SQL Server with sa or sqladmin

    -Go to Object Explorer
    -Expand Security --> Logins
    -Right Click on Login and select "New Login"
    -Click on search and find that windows user which you are trying to install PBIRS
    -Under Server Role on the Left side assign this user as "sysadmin" role.

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi misaki233 ,

 

It means your current account don't  have permission for created database in sql server. You can try to use administrator account for sql server in configuration or you can add dbcreator role to the account:

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai