Forum Discussion
Microsoft.Data.SqlClient.SqlException(0x80131904):User does not have permission Unable to create dbs
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.
Hi Is this permission require permanently i did not found any reference in installing PowerBI server
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.