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.
Hi v-deddai1-msft , When I send install requirements to customer, its listed as 1433 in my farm topology as its the default port. After that its up to the db admin to decide the port. In this case they decided they will go with 1433 as I sent.
Both tests, ping and udl was performed on report server.
Would that cause problem? I installed SharePoint without problem using the same db instance and port.
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
yes tried that as well, procudes same error.
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.