Forum Discussion
Unable to install Power BI Report Server Due to blocking error
I was able to solve the problem by changing the hostnames to a smaller version that doesn't get shortened in "systeminfo".
Edit: before changing the hostname to a shorter version, I was also able to install it successfully by installing a new sql server on the report server hosting machine.
yes tried that as well, procudes same error.
Hi harunkara ,
If you're creating the report server database on a database server on a different machine, change the service account for the report server to a credential that is recognized on the database server.
Please refer to https://docs.microsoft.com/en-us/power-bi/report-server/install-report-server#creating-a-database-on-a-different-server
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
Can you elaborate on recognize? What rights should system admin give to that user on the db server?
Another info that came to light is that,
machine host name for db is OF-DEVQASQL-N but the netbios name is OF-DEVQASQL-N43,
I believe this is the reason for the error, But i have no idea how to fix it, other than requesting new servers with hostname-netbios name matching machines. Which might not be an option here so im open to suggestions.