Forum Discussion

adilahmed's avatar
adilahmed
Frequent Visitor
1 year ago
Solved

Microsoft.Data.SqlClient.SqlException(0x80131904):User does not have permission Unable to create dbs

Hi, I am trying to configure Reporting Services manager and creating database on a different server I am using Domain Account as service account when i create databases i got below error   Micros...
Database error
Powerbi reportserver
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, adilahmed 

    When creating the database, you are logging in with a SQL Server user connection at this step:


    This user needs to have the sysadmin role. If user does not have a sysadmin role, the following error will occur:

     

    Please login to SQL Server with sa or sqladmin.

    Go to Object Explorer.
    Expand Security --> Logins.

    You can find the currently logged in user and give it the “sysadmin” role：


    After creating the database you have the option of removing the sysadmin role from this user.

     

     

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Fen Ling,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.