sql-serverserversql-server-2014power-bi-report-serverreportserver

Running Database Script Error SQL Server/ Report Server


I keep receiving this error and am unable to fix it - can anyone help?

What I did before?

At the end of creating process I receive this error message:

I receive that error message all the time...

Click on the link to see error message

Can anyone help me, please?


Solution

  • Your database user must be a member of dbcreator server role to create the ReportServer and ReportServerTemp databases.

    To add a member to dbcreator, you must be a member of that role, or be a member of the sysadmin.

    With the following script you can add permission required:

    ALTER SERVER ROLE dbcreator ADD MEMBER YourDatabaseUser;